How to Add Google Forms Submission in Airtable Using Pabbly Connect

Learn how to automate Google Forms submissions into Airtable using Pabbly Connect. This step-by-step tutorial guides you through the integration process. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Forms and Airtable Integration

To integrate Google Forms submissions into Airtable, you need to access Pabbly Connect. Start by visiting the Pabbly Connect website and signing into your account. If you are a new user, you can sign up for free and get 100 free tasks every month.

Once logged in, you will see the ‘All Apps’ window. Here, select Pabbly Connect by clicking on ‘Access Now’. This will take you to the Pabbly Connect dashboard where you can create a workflow for your automation.

2. Creating a Workflow in Pabbly Connect

To begin the automation process, you need to create a workflow in Pabbly Connect. Click on the ‘Create Workflow’ button, and a dialog box will prompt you to name your workflow. Enter a name like ‘Airtable Record for Google Form Submission’.

• Choose a specific folder to save your workflow.
• Click on the ‘Create’ button to finalize your workflow setup.

After creating the workflow, you will see two sections: ‘Trigger’ and ‘Action’. The trigger will be Google Forms, and the action will be Airtable. This setup is crucial for the automation to work effectively.

3. Setting Up Google Forms as the Trigger in Pabbly Connect

In this step, you will set Google Forms as the trigger application in Pabbly Connect. Click on the arrow in the trigger section and select ‘Google Forms’ as your trigger application. The trigger event will be ‘New Response Received’.

Pabbly Connect will generate a webhook URL. This URL is essential for connecting Google Forms to Pabbly Connect. Copy the webhook URL and follow the steps to link it with your Google Form:

• Open your Google Form and navigate to the ‘Responses’ tab.
• Click on ‘Link to Sheets’ and create a new spreadsheet.

Once the spreadsheet is created, you will link it back to Pabbly Connect so that every new form submission is captured automatically.

4. Connecting Google Sheets to Pabbly Connect

After creating the Google Sheets, you need to connect it to Pabbly Connect. Click on ‘Extensions’ in Google Sheets, then select ‘Add-ons’ and search for ‘Pabbly Connect Webhooks’. Install it if you haven’t done so already.

Once installed, go back to ‘Extensions’ and select ‘Pabbly Connect Webhooks’. Choose ‘Initial Setup’ and paste the copied webhook URL into the dialog box. Set the trigger column as the last column where data will be added (for example, Column F).

Submit a dummy form response to test the connection. Ensure that the ‘Send on Event’ option is checked to capture responses automatically.

Once this is set up, go back to Pabbly Connect to check if the response has been captured successfully.

5. Setting Up Airtable as the Action in Pabbly Connect

Now that the trigger is set up, it’s time to configure Airtable as the action application in Pabbly Connect. Click on the arrow in the action section and select ‘Airtable’. Choose the action event as ‘Create Record’.

Connect your Airtable account with Pabbly Connect by clicking on ‘Add New Connection’. Once connected, select the base you created in Airtable for storing customer data.

Map the fields from Google Forms to Airtable, such as first name, last name, email, mobile number, and remarks. Click on ‘Save and Send Test Request’ to test if the record is created successfully.

Check your Airtable to confirm that the new record has been created based on the form submission. This completes the integration process between Google Forms and Airtable using Pabbly Connect.

Conclusion

In this tutorial, we explored how to integrate Google Forms submissions into Airtable using Pabbly Connect. By following the steps outlined, you can automate the process of collecting customer feedback efficiently. This integration ensures that every form submission is recorded in Airtable without manual effort, enhancing your workflow.