Sending WhatsApp Messages from Google Sheets Using Pabbly Connect

Learn how to send WhatsApp messages from Google Sheets using Pabbly Connect in minutes without any coding. Follow this step-by-step tutorial for seamless integration. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect to Start the Integration

To send WhatsApp messages from Google Sheets, you first need to access Pabbly Connect. This integration platform allows seamless automation between various applications, including Google Sheets and WhatsApp API.

Begin by signing up for a free account on Pabbly Connect. Once logged in, navigate to the dashboard and click on ‘Create Workflow’. Name your workflow, for example, ‘Google Sheets to WhatsApp’, and select the appropriate folder for your automation.

2. Setting Up Google Sheets Trigger in Pabbly Connect

In this step, you will set up Google Sheets as the trigger application in Pabbly Connect. Choose Google Sheets from the application list and select the trigger event as ‘New or Updated Spreadsheet Row’. This will initiate the automation whenever a new row is added.

• Select Google Sheets as the trigger application.
• Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

After copying the webhook URL, go to your Google Sheets, click on ‘Extensions’, and then ‘Add-ons’. Search for the Pabbly Connect Webhooks add-on and install it. After installation, refresh your Google Sheet to see the new add-on.

3. Initial Setup in Google Sheets for Pabbly Connect

Once the Pabbly Connect Webhooks add-on is installed, you need to perform the initial setup. Go to ‘Extensions’, hover over Pabbly Connect Webhooks, and select ‘Initial Setup’. Here, you will configure the selected sheet and paste the webhook URL you copied earlier.

• Select the sheet you want to send data from.
• Paste the webhook URL into the designated field.
• Choose the trigger column, which is the last data entry column.

After completing these steps, click the ‘Send Test’ button to ensure that the test data is sent successfully to Pabbly Connect. This confirms that your Google Sheets is correctly linked to the automation workflow.

4. Sending WhatsApp Messages Using Pabbly Connect

Now that the trigger is set up, the next step is to send WhatsApp messages using Pabbly Connect. In the action step of your workflow, search for your chosen WhatsApp API partner, such as Vati or WhatsApp Cloud API. Select the action event as ‘Send Template Message’.

Connect your WhatsApp API account by entering the API endpoint and access token. Map the WhatsApp number field to the mobile number received from Google Sheets. Select the template message you want to send.

Make sure your WhatsApp number is formatted correctly, and enter the template message details. After configuring these settings, click on ‘Save and Send Test Request’ to verify that the message is sent successfully through Pabbly Connect.

5. Final Testing and Automation Completion

After setting up the WhatsApp message sending feature, it’s time to test the entire automation. Go back to your Google Sheets and add a new row with the user details. Once you enter the details, Pabbly Connect will automatically send the WhatsApp message based on the template you created.

Check your WhatsApp to confirm that the message has been received. You should see the personalized message with the user’s first name included. This confirms that the automation is working correctly and that you can send WhatsApp messages directly from Google Sheets using Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to send WhatsApp messages from Google Sheets quickly and efficiently. By following the steps outlined, you can automate your communication process without any coding knowledge.