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.
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
Create record on Form Submit
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
To connect Airtable you to configure three main elements
- API key
- Table Url
3. Generate and get API Key
Airtable uses Api-key authorization to connect to your account.
To Generate Api-Key follow the steps
- Go to https://airtable.com/account
- Click on "Generate Api key"
- Once Key is Generated copy and paste it in Key placeholder
- 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
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
You can see a new record in your Airtable