Join Makerpad today

Makerpad is home to over 9,000 thousands folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.
Tutorials
/
🖥 Dynamically generate Google Slides
Marked as complete!
Oops! Something went wrong while submitting the form.
Mark as complete

🖥 Dynamically generate Google Slides

Link to Demo

In this tutorial we'll show you how to dynamically generate Google Slides from Airtable data.

What you'll need

  • Airtable
  • Google Slides
  • Zapier

You must be a member to view the full lesson

Join Makerpad today

Makerpad is home to over 9,000 thousands folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

Go to Google Slides and select a template. Open it.

Next find the pieces of information that you want to dynamically map.

For each piece of data, enter a placeholder surrounded by curly brackets like this - {{clientName}}, {{contactName}} etc.

The text that goes inside of the curly brackets doesn't matter as that is for your reference only.

Go through your tutorial and add curly brackets to the items you need.

Next open Airtable. Create a simple base with columns and data that you want to bring across.

Make sure to add a Single Option column with options which will act to display the stage of the sales process your lead is at. Examples, Lead, Proposal, Contract, Won.

For this one we're going to use some company data from a dummy base we created for tutorial purposes you can get it here - https://airtable.com/shrz784W7Jk0eugZl

Add a new view, name it Proposal and add a Filter where Sales Stage is Proposal.

We'll

Now Create a new Zap in Zapier.

Use Airtable, New Record in View as the trigger. Connect your Airtable Base. Test and continue the check you have a record to work with.

Now add Google Slides as the Action. Select Create Presentation from Template. Connect Google Slides.

Find and select your template then map the data across to the fields below. You should be able to see fields for each piece of data you entered within curly brackets previously. Use this to customise the document info!

Once you have added the Airtable data into the Google Slides fields, press continue.

If it worked head over to Google Slides and check a new presentation was created with your data.

I hope you enjoy this tutorial preview, if you have any questions please reach out on Twitter @tomosman or @makerpad.

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.

Ready to get started?

Join the community and start turning your ideas into solutions