Airtable

Google Forms to Airtable - Insert into table of Airtable base from Google Form submission

What is Form Director?

Form Director is a G Suite 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 G Suite Marketplace and Chrome Web Store. 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

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

Steps for mapping from field with Air table fields

  • Click on setup mapping
  • Choose the form field
  • choose the app field
  • click save

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