How to Automatically Send Google Forms Responses to WhatsApp Using Pabbly Connect

Learn how to integrate Google Forms with WhatsApp automatically using Pabbly Connect. Follow our step-by-step tutorial to streamline your response notifications. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google Forms and WhatsApp Integration

To get started with automating Google Forms responses to WhatsApp, you need to access Pabbly Connect. This platform allows you to create workflows that link your Google Forms with WhatsApp notifications seamlessly. First, visit the Pabbly Connect website and log in to your account. If you are a new user, you can sign up for free and get started with 100 free tasks each month.

Once logged in, you will see the Pabbly apps dashboard. Click on the Pabbly Connect icon to access the integration dashboard. Here, you can create a new workflow by clicking on the ‘Create Workflow’ button. Name your workflow something descriptive, like ‘Get Google Form Responses to WhatsApp Automatically,’ and select a folder to save it in.

2. Creating the Workflow in Pabbly Connect

After naming your workflow, it’s time to set up the trigger. In the trigger section, select Pabbly Connect and choose Google Forms as the trigger application. The trigger event will be ‘New Response Received.’ This means that every time a new form submission occurs, the workflow will be activated.

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

Next, you will need to connect this webhook URL to your Google Form. Go to your Google Form, click on the ‘Responses’ tab, and select the ‘Link to Sheets’ option. Create a new spreadsheet to capture the responses. After that, go to the spreadsheet, click on Extensions, then Add-ons, and search for Pabbly Connect Webhooks. Install the add-on if you haven’t already.

3. Connecting Google Forms to Pabbly Connect

To establish a successful connection between Google Forms and Pabbly Connect, open the spreadsheet associated with your Google Form and navigate to Extensions. Select Pabbly Connect Webhooks and then Initial Setup. Here, paste the webhook URL you copied earlier. Set the trigger column to the final data column, which is usually column A.

After setting up the webhook, ensure you enable the ‘Send on Event’ option in the Pabbly Connect Webhooks menu. This step is critical because it allows the webhook to send data to Pabbly Connect whenever a new response is recorded in the spreadsheet.

• Open your Google Sheets and go to Extensions > Pabbly Connect Webhooks > Initial Setup.
• Paste the webhook URL and set the trigger column.
• Enable ‘Send on Event’ to ensure data is sent to Pabbly Connect.

After completing these steps, your Google Form is now connected to Pabbly Connect, and you can proceed to test the integration with a form submission.

4. Testing the Google Forms and WhatsApp Integration

Now that you have set up the trigger, it’s time to test the integration. Go back to your Google Form and submit a test response. Fill in the required fields, such as first name, last name, email, and phone number, and click the submit button. After submission, check your spreadsheet to ensure the response has been recorded.

Once the response is captured in the spreadsheet, return to the Pabbly Connect dashboard. You should see that the trigger has received the new response data. This confirms that the connection between Google Forms and Pabbly Connect is working correctly, and the next step is to set up the action to send this data to WhatsApp.

Submit a test response in Google Forms. Check the Google Sheets for the recorded response. Verify that Pabbly Connect has received the trigger data.

If everything looks good, you are ready to set up the action step to send notifications via WhatsApp using Pabbly Chatflow.

5. Sending Notifications to WhatsApp Using Pabbly Chatflow

To send WhatsApp notifications, you will need to set up Pabbly Chatflow as the action application in your Pabbly Connect workflow. Select Pabbly Chatflow and choose the action event as ‘Send Template Message.’ This allows you to send a customized message to your WhatsApp number whenever a new Google Forms submission is captured.

To configure the action, you will need to connect your Pabbly Chatflow account. Log into your Pabbly Chatflow account, go to settings, and generate an API token. Use this token to establish the connection in Pabbly Connect. After connecting, specify the recipient’s mobile number (including the country code) and select the template message you created for notifications.

Select Pabbly Chatflow as the action application. Choose ‘Send Template Message’ as the action event. Connect your Chatflow account using the API token.

Once you have configured the action step, click on ‘Save and Send Test Request.’ If everything is set up correctly, you will receive a WhatsApp message containing the details of the form submission. This confirms that your automation is complete and working as intended.

Conclusion

In this tutorial, we successfully integrated Google Forms with WhatsApp using Pabbly Connect and Pabbly Chatflow. By following these steps, you can automate the process of receiving form submissions directly to your WhatsApp, streamlining your communication. This integration not only saves time but also helps you respond to inquiries promptly, enhancing your workflow efficiency.