Google Forms + Airtable Integration

Create record in Airtable on Google Form Submission

What is Form Director?

Form Director is a Google Workspace add-on that directs data submitted from Google Forms to applications like Google Docs, Forms, Sheets, Contacts, Calendar, Tasks, Email, Trello, Slack, QuickBooks etc.


It is available in the Google workspace Marketplace.

Please check installation instructions to install the add-on.

What is Airtable?

Airtable is the all-in-one collaboration platform.

Airtable works like a spreadsheet but gives you the power of a database to organize anything.

Google Forms to Airtable: Use Case(s)

> Create record in Airtable on Google Form Submission

Google Forms

Create record on Form Submit

Form Director


Demo Video: How to insert into Airtable from Google Form submission?

Setting up Airtable in Form Director

  • Choose Airtable from the list of apps

  • Name your service

  • Choose Create record under services

Configuring Airtable

To connect Airtable you to configure three main elements

  • API key

  • Table Url

  • Fields

1. Generate and get API Key

Airtable uses Api-key authorization to connect to your account.

To Generate Api-Key follow the steps

2. Get Table Url

Table Url is required to connect to your table

To get Table URL follow the steps

  • Select Authentication from side menu list => then copy the table URL

  • Copy the URL and use it as Table URL for Form Director Airtable configuration.

3. Getting AirTable Fields

Fields are the table headers, Airbase doesn't have a direct way of getting table headers so you need to enter/copy required table headers.

Enter the comma separated headers as a Fields for Form Director Airtable configuration

In the above picture Headline, Status, Sub-Healine are the Fields


  • Click Setup Mapping and setup the mapping.

  • Mapping of form fields to that of app fields is to be done in order to create record on form submission.

  • Click on the add icon to add new mapping

  • Once you have done mapping you can save the service

  • Note : Mapping should be done between app field and form field of same type.


  • Notify your audience with success or error notifications.

  • Switch on Send Email to send email during execution.

Email Template

  • Send your own customized emails on form submission to your audience.


  • Click Pick Drive Files to attach files to Email.

  • Add attachments from previous service results.

  • Select the required service result.

Finish setting up

  • Save service

You are all set to send form data to Airtable on your Google Form submission

Submit the Form

Submit the Google Form

See Airtable

You can see a new record in your Airtable