Do you spend a lot of time creating presentations? Presentation slides are a standard tool for...
How to generate a Google Slide for each row in a Google Sheet
Do you spend a lot of time copying information from Google Sheets to Slides? Automation can help! 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.
In this tutorial, I will show you how to create slides in bulk that are automatically filled in with data from a Google Sheet.
Slideform automation software links your data to your slide deck so you can generate up-to-date, accurate, and professional presentations on demand.
How to bulk-generate Google Slides
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:
Create a new slide in the presentation for each row in the sheet
In this scenario, I want to construct a summary presentation that has one slide for each property. The slide will look like this, with the name of the property at the top and the data and KPIs in the center:
First, I create a slide template that has placeholders (or pragmas) for each of the data fields I want to copy over from the Sheet. The name of the pragma matches the column name in my sheet. The slide template looks like this:
Then, I use Slideform's Bulk Create capability to generate one slide per row in my sheet. I just have to enter the template URL and the sheet URL and click Bulk Create.
Now I have a slide deck with nine slides, each corresponding to one of the houses in my spreadsheet! All the formatting, fonts, text, and sizing is taken care of and I just get a clean, professional, and accurate presentation very quickly. And I can download it as a pdf, PowerPoint, or save it to my Google Drive.
Check out the video tutorial here:
What if I want to create a whole new slide deck for each row in the sheet ?
Slideform's Bulk Create function can also generate a full slide deck for each row of the Google Sheet. Check out that example here.