Do you spend a lot of time copying information from Google Sheets to Slides? Automation can help!...
In this tutorial, I will show you how to create slide decks in bulk that are automatically filled in with data from a Google Sheet.
Copying data into slides is such a pain! If you are a programmer, you could set up a Google Apps script to copy the data over, but for the rest of us, there is Slideform.
Slideform automation software links your data to your slide deck so you can generate up-to-date, accurate, and professional presentations on demand.
The scenario for this tutorial is a vacation rental management company. They track data on the performance of each property, such as the revenue and number of nights booked, in a Google Sheet. The sheet has one row for each property, like this:
How to create a new slide deck from each row in the sheet
Now imagine that we need to create a performance report for each of the owners of these properties. That would mean copying and pasting the data from the sheet into a new presentation for each property. However, it is so much easier to automatically fill in the data with Slideform. Take a look at this example to see how it works. Slideform's Bulk Create function can also generate a full slide deck for each row of the Google Sheet.
We start with a slide deck template. Since this is a client-facing report, I created a branded template to use for the performance report. I replace the property-specific text and numbers on each slide with placeholders. Then I enter the Google Slides template URL into Slideform.
Now, let’s generate a presentation for each of the properties in my portfolio. We will use the Google sheet shown above, which has one row of data per property. Just go to Slideform's Bulk Create option, enter the URL of the sheet, and the nine slide decks will be created.
Here is one of the presentations:
If I have more reports that I want to send out in the coming weeks, I can just add those properties to my sheet, go into Slideform, and generate the presentations with one click.
What if I want to create just one slide for each row?
Check out this post: Generate a slide for each row in a spreadsheet
I hope you’ve enjoyed this intro to Google Sheets to Google Slides automation. Get in touch today!
