ExploreEducationHow do I build?MembersToolsWorkshopsJobs

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible without writing code.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates

The perfect way to keep on top of everything Makerpad.

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.

My Profile:

Edit your bio
My profileMy progressSubmit a project

Share

Bring no-code to work

Save time, avoid the backlog and ship faster. Implement automated workflows to eliminate repetitive tasks in minutes.
For BusinessesFor individuals
Tutorials
/
🖥 Dynamically generate Google Slides
Added to your list!
Oops! Something went wrong while submitting the form.
Marked as complete!
Oops! Something went wrong while submitting the form.
Mark as completeSave to watch later

🖥 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

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.

You must be a member to view the full lesson

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible without writing code.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates

The perfect way to keep on top of everything Makerpad.

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.

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