How to Connect Webflow Forms to Google Sheets Using Pabbly Connect

Learn how to seamlessly integrate Webflow Forms with Google Sheets using Pabbly Connect in this step-by-step tutorial. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To connect Webflow Forms to Google Sheets, the first step is to access Pabbly Connect. Open your browser and navigate to Pabbly’s official website at Pabbly.com/n. This platform serves as the central hub for all your automation needs.

Once on the homepage, you can either sign up for a new account or log in if you already have one. After signing in, you will be directed to the Pabbly Connect dashboard, where you can start creating your workflow to automate the connection between Webflow and Google Sheets.

2. Creating a Workflow in Pabbly Connect

To begin setting up your integration, click on the ‘Create Workflow’ button located in the top right corner of the dashboard. This action will prompt you to name your workflow, so enter a relevant title such as ‘Add Google Sheets Row on New Webflow Form Submission’. using Pabbly Connect

• Click on the ‘Select’ button to choose the workflow builder.
• Select the Classic workflow for a more stable setup.
• Choose the folder where you want to save this workflow.

After naming your workflow and selecting the appropriate folder, you will be taken to the workflow configuration page. Here, you will set up triggers and actions for your automation.

3. Setting Up the Trigger for Webflow Forms

In this step, you need to establish the trigger that initiates the automation. Select ‘Webflow’ as your trigger application since you are receiving submissions from Webflow Forms. using Pabbly Connect

For the trigger event, choose ‘New Form Submission’. This means that every time a new form is submitted through your Webflow site, Pabbly Connect will capture this event. Click on the ‘Connect’ button to link your Webflow account to Pabbly Connect.

• Generate an API token in your Webflow account settings.
• Paste the API token into Pabbly Connect to establish the connection.
• Select your Webflow site from the dropdown menu.

Once the connection is established, you can proceed to test the trigger by submitting a test form on your Webflow site. This will allow Pabbly Connect to capture the response and confirm that the integration is functioning correctly.

4. Adding Google Sheets as an Action Step

After successfully setting up the trigger, the next step is to add Google Sheets as the action application. Select ‘Google Sheets’ from the list of applications for your action step. For the action event, choose ‘Add a New Row’. using Pabbly Connect

Click on the ‘Connect’ button to link your Google Sheets account. You will be prompted to sign in to your Google account and grant Pabbly Connect access to manage your sheets. This ensures that your data is secure while enabling seamless integration.

Select the spreadsheet where you want to add new rows. Choose the specific sheet within the spreadsheet. Map the fields from your Webflow form to the corresponding columns in Google Sheets.

Mapping the fields ensures that the data from your Webflow form is correctly entered into the designated columns of your Google Sheets. Once the mapping is complete, click on the ‘Save’ button to finalize the action setup.

5. Testing the Integration and Finalizing the Setup

Now that both the trigger and action steps are set up, it’s time to test the entire workflow. Submit a test form through your Webflow site to see if the data flows correctly into Google Sheets. Pabbly Connect will capture the submission and execute the action you configured.

Once you confirm that the data appears in Google Sheets as expected, you can activate the workflow. This means that every future form submission will automatically populate your Google Sheets without any manual intervention.

To summarize, you have successfully integrated Webflow Forms with Google Sheets using Pabbly Connect. This automation streamlines your data collection process, allowing you to focus on your event organization without worrying about manual entries.

Conclusion

In this tutorial, we explored how to connect Webflow Forms to Google Sheets using Pabbly Connect. By following these steps, you can automate your data management process, ensuring that every form submission is efficiently recorded in your Google Sheets.