Watch Step By Step Video Tutorial Below





1. Setting Up Pabbly Connect for Integration

To start integrating your website forms with Google Sheets, you first need to access Pabbly Connect. This platform enables seamless connections between various applications, enhancing your workflow efficiency.

Begin by logging into your Pabbly Connect account. Once logged in, navigate to the dashboard where you will create a new workflow. Click on ‘Create Workflow’ and select ‘Create from scratch’. You will then need to name your workflow, for instance, ‘Save Leads from Website Forms to Google Sheets’. After naming, choose the folder ‘Forms Automation’ and click on ‘Create’.

2. Adding a Trigger with Webhook by Pabbly

In this section, you will set up the trigger that initiates the workflow using Pabbly Connect. Click on ‘Add Trigger’ and select ‘Webhook by Pabbly’. This will allow you to connect your website’s form with Pabbly Connect.

  • Choose ‘Catch Webhook’ as the trigger event.
  • Click on ‘Connect’ to generate a unique webhook URL.
  • Copy the provided webhook URL for use in your website form.

After copying the webhook URL, return to your website’s form code. Replace the existing webhook URL with the new one you copied. Once saved, return to Pabbly Connect, where you will see a message indicating that it is waiting for a webhook response.

3. Submitting the Form to Test the Webhook

Now that you have set up the webhook, it’s time to test it. Go back to your form and refresh the page to ensure the new webhook URL is active. Enter the required details such as name, email address, and phone number, then submit the form.

Once the form is submitted, Pabbly Connect will capture the webhook response. You can check the response details in your workflow to confirm that the connection is working correctly.

After submission, navigate back to Pabbly Connect. You should see the details captured from your form submission, confirming that the Pabbly Connect integration is functioning as intended. This setup ensures that all form submissions are automatically tracked.

4. Adding Google Sheets as an Action in Pabbly Connect

With the webhook successfully set up and tested, the next step is to add Google Sheets as an action in your workflow using Pabbly Connect. Click on ‘Add Action’ and select ‘Google Sheets’ from the list of applications.

  • Choose ‘Add New Row’ as the action event.
  • Click on ‘Connect’ to link your Google account.
  • Select the spreadsheet you want to use for storing the form data.

Once connected, map the fields from your webhook response to the respective columns in your Google Sheet. This mapping ensures that the data from your form submissions is accurately recorded in the spreadsheet.

5. Finalizing the Setup and Testing the Integration

After mapping the fields, click on ‘Save and Send Test Request’ to finalize the setup. This action will send a test row to your selected Google Sheet. Check your Google Sheets to verify that the data has been added correctly.

With everything set up, you can now enjoy automated data entry from your website forms to Google Sheets, thanks to Pabbly Connect. This integration eliminates the need for manual tracking of form submissions, allowing you to focus on other important tasks.

Whenever a new form submission occurs, all details will be automatically added to your Google Sheet, streamlining your data management process.

Conclusion

In this tutorial, we explored how to integrate your website forms with Google Sheets using Pabbly Connect. This setup automates the data entry process, ensuring that all form submissions are efficiently tracked in your spreadsheet.