Airtable

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.

Installation:

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

Airtable

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

Mapping

  • 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.


Notification

  • 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.

Attachment

  • 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