How to Add/Update Additional Data in Google Sheets on Form Submission Using Pabbly Connect

Learn how to seamlessly add or update additional data in Google Sheets upon form submission using Pabbly Connect. Follow this step-by-step tutorial for integration. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin integrating Google Sheets with form submissions, first access Pabbly Connect by visiting its official website. Sign in or create a new account if you are a first-time user. This platform allows you to automate processes seamlessly.

Once logged in, navigate to the dashboard. Here, you can create a new workflow. Click on the ‘Create Workflow’ button, which will prompt you to name your workflow. For this integration, name it ‘Add or Update Additional Data in Google Sheets on Form Submission’.

2. Setting Up the Trigger in Pabbly Connect

In this step, you will define the trigger application in Pabbly Connect. Select your form builder application, such as Jotform, and set the trigger event to ‘New Response’. This event will activate the workflow whenever a new form submission is received.

• Select Jotform as the trigger application.
• Choose ‘New Response’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

Next, go to your Jotform account, edit the form you created, and navigate to the ‘Settings’ tab. Under ‘Integrations’, search for ‘Webhooks’, remove any existing webhook, and paste the copied URL. This establishes a connection between Jotform and Pabbly Connect.

3. Mapping Data to Google Sheets with Pabbly Connect

After setting up the trigger, the next step is to map the data received from the form submission to your Google Sheets. In Pabbly Connect, select Google Sheets as your action application and choose the action event ‘Lookup Spreadsheet Rows’. This allows you to find the specific row that corresponds to the submitted form data.

• Connect your Google Sheets account to Pabbly Connect.
• Select the spreadsheet and the specific sheet you want to update.
• Set the lookup column to the email column of your sheet.

Ensure to map the email field from the Jotform response to the lookup value in Google Sheets. This step is crucial as it allows Pabbly Connect to identify the correct row to update based on the submitted form data.

4. Updating Google Sheets with Feedback Data

Now that you have mapped the data, it’s time to update the Google Sheets with the feedback received. In Pabbly Connect, add another action step and select Google Sheets again, this time choosing the action event ‘Update Cell Value’. This will allow you to write the feedback in the correct cell.

In this step, specify the range for the update. The format should be the column letter followed by the row index. For instance, if you are updating column E, you would enter ‘E’ for the column and map the row index from the previous step. Then, map the feedback value from the Jotform response to the value field.

5. Testing and Verifying the Integration

After setting up the action steps, it’s essential to test the integration. Submit a form response through Jotform and check if the feedback appears in the Google Sheets as expected. This verification step ensures that Pabbly Connect is functioning correctly.

Open your Google Sheets to see if the feedback from the form submission has been added to the corresponding row. If everything is set up correctly, you should see the new feedback in the designated cell, confirming that your integration is successful.

Conclusion

In this tutorial, you learned how to use Pabbly Connect to add or update additional data in Google Sheets upon form submission. By following these steps, you can automate your data entry processes efficiently, ensuring that feedback is logged accurately and promptly.