Google Forms + Airtable Integration
Create record in Airtable on Google Form Submission
You can integrate Google Forms with Airtable using Form Director. Form Director enables you to connect Google Forms with Airtable, allowing you to create records based on form responses.
When a user submits a Google Form, the responses are automatically sent to Airtable, where records are created accordingly.
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.
Airtable is the all-in-one collaboration platform.
Airtable works like a spreadsheet but gives you the power of a database to organize anything.
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
Fields
Airtable uses Api-key authorization to connect to your account.
To Generate Api-Key follow the steps
Click on "Generate Api key"
Once Key is Generated copy and paste it in Key placeholder
Table Url is required to connect to your table
To get Table URL follow the steps
Go to https://airtable.com/api
Click on the base that you need to connect from listed base list.
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.
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.
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.
Save service
You are all set to send form data to Airtable on your Google Form submission
Submit the Google Form
You can see a new record in your Airtable