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 Docs
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 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

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.

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