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 Docs
Marked as complete!
Oops! Something went wrong while submitting the form.
Mark as complete

๐Ÿ“‘ Dynamically generate Google Docs

Link to Demo

In this tutorial we will show you how to dynamically create Google Docs using Zapier and Airtable.

What you'll need

  • Google Docs
  • Airtable
  • 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.

First, head to Airtable and create a simple base with some columns containing some template data for an invoice.

Add in some dummy data, we'll use this as the info that we'll pass through to the Google Doc.

Next head into Google Docs. Find and select a template from the template gallery.

Open it and edit it to suit the information you want to pass through.

For each piece of data, you want to dynamically pull from Airtable, enter some placeholder text surrounded by two curly brackets. Example: {{firstName}}, {{lastName}} and so on.

This will let Zapier know that this is the info to replace with the info from Airtable.

Format to suit.

Now inside of Zapier, create a new Zap.

First step is Airtable. Select New Record. Connect Airtable and the Base. Test and continue.

Next select Google Docs as the Action. Select New Document from Template. Find and select your template that you just created. Press Continue.

Next, map across the fields from Airtable to match the Fields created below.

Press test and continue then head to Google Docs to check the document has been created with the desired info.

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