Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for WhatsApp Integration

To start sending personalized WhatsApp messages using Pabbly Connect, you first need to sign in to your Pabbly account. Once logged in, select the Pabbly Connect option to access the dashboard.

From the dashboard, click on the “Create Workflow” button. You will be prompted to name your workflow; for this tutorial, name it “Send and Receive WhatsApp Message for Google Form Submission.” Select the appropriate folder, such as “Forms Automation,” and then click “Create” to proceed.

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

In this step, you will configure Google Forms to trigger the workflow in Pabbly Connect. Click on the trigger application box and select Google Forms. Choose the trigger event as “New Response Received” and click on “Connect”.

  • Select Google Forms as the trigger application.
  • Choose “New Response Received” as the trigger event.
  • Click on “Connect” to establish the connection.

A webhook URL will be provided by Pabbly Connect. You will need this to connect your Google Form responses to your workflow. Go to Google Forms, click on “Responses,” and then select “View in Sheets” to access your response spreadsheet.

3. Configuring Google Sheets to Capture Form Responses

After accessing the spreadsheet, copy the webhook URL from Pabbly Connect and set it up in Google Sheets. Click on “Extensions,” then “Add-ons,” and find “Pabbly Connect Webhooks.” If you haven’t installed it yet, search for it in the Google Workspace Marketplace and install it.

  • Install Pabbly Connect Webhooks from Google Workspace Marketplace.
  • Refresh Google Sheets to see Pabbly Connect Webhooks in the Extensions menu.
  • Enter the webhook URL and specify the trigger column.

Set the trigger column to the final data column (e.g., Column F). This ensures that whenever new data is added in that column, the entire row will be sent to Pabbly Connect. Click “Send Test” to confirm the setup, and then click “Submit” to finalize the configuration.

4. Sending WhatsApp Messages Using Pabbly Chat

Now that Google Forms is set up, you can proceed to send WhatsApp messages. Add a new action step in Pabbly Connect and select Pabbly Chat Flow as the action application. Choose “Send Text Message” as the action event and click on “Connect”.

In the connection settings, you will need to enter your API key from Pabbly Chat Flow. Navigate to the settings of Pabbly Chat Flow, then click on APIs and Webhooks to find your API key. Copy this key and paste it into the connection settings in Pabbly Connect.

5. Configuring Personalized WhatsApp Messages

After successfully connecting Pabbly Chat Flow, it’s time to configure the WhatsApp message. Enter the recipient’s phone number, including the country code but without the plus sign. You can map the phone number from the Google Form response dynamically.

Craft your WhatsApp message, making sure to personalize it using the name from the form submission. For example, you can write, “Hi {name}, thank you for getting in touch with us!” This ensures that every message sent via Pabbly Connect is tailored to the individual customer.

After setting up the message, save and send a test request to ensure everything is working correctly. Check your WhatsApp to verify that the message has been received. You can also clone this step to send a confirmation message to yourself, ensuring that you are notified whenever a new form submission occurs.

Conclusion

In conclusion, using Pabbly Connect allows you to effortlessly send personalized WhatsApp messages based on Google Form submissions. This integration enhances communication and ensures timely responses to customer inquiries.