In this tutorial, I will show you how to automatically generate a Google Slides presentation from...
How to automatically generate Google Slides from Google Sheets
4 simple steps to automating your Google Slides
Get in touch with us to learn more
Check out the video summary here -->
1. Create a custom Google Slides template

- {{client}} - this will hold the client name
- {{seats}} - how many user licenses they are buying
- {{monthly rate}} - the total license cost per month
- {{annual cost}} - the total license cost per year
- {{image:clientlogo}} - the client logo
- {{fn:date}} - the date the slides are created
Save the template as a Google Slides presentation in your Google Drive workspace.
2. Create a Google Sheet with data needed to fill in the presentation
Slideform integrates with data from your Google workspace and other sources. You may already have a Google Sheet with data that you need to enter into your presentation. In this example I am creating several pricing proposals and I have the pricing info for each prospective client in a Google Sheet.

Notice that some of the columns in my sheet correspond to the pragmas in my template. These columns will be used to fill the pragmas in the final presentations. Other columns in the sheet are for internal calculations and will not appear in the presentation.
3. Upload your template and data sheet to Slideform
Now you upload the slide template and the data sheet to Slideform. Just enter the Google Sheet URL under the Add Data Source menu. Then enter your slide template URL in the New Form menu.
The last configuration step is to connect the data to each placeholder pragma in the template. You can either type in the data for a pragma or you can have it auto-filled from the Google sheet. Either way, your slides will be filled in and formatted beautifully each time you generate the presentation.
For example for the {{client}} pragma, I set the form up so that I can choose from a dropdown list based on the client names that are in column A of the spreadsheet.
Once I have the client name, I can auto-fill the remaining text or numeric pragmas based on which client I have chosen. For example, the {{seats}} pragma will be looked up in the sheet based on the client name like this:
select seats where client == {{client}}
Save the data configuration once all pragmas are set.
4. Fill in the form to generate the presentation
Now that my template and form are all set up, I can generate the presentation whenever I need to by clicking Generate.

Just select the client name and the presentation is done.

Now for the fun part! Automate!
Let’s generate a presentation for each of the clients in my Google Sheet. All I have to do is go to my form and click Generate. I choose the client’s name and click next and the slides are ready. No more copying and pasting!
If I have more proposals that I want to send out in the coming weeks, I can just add those clients to my sheet, go into Slideform, and generate the proposal slides with one click.
I hope you’ve enjoyed this intro to Google Sheets to Google Slides automation. Get in touch with Slideform at https://www.slideform.co/