Send WhatsApp Business Messages for New Google Sheets Rows

Learn how to automate sending WhatsApp Business messages for new rows in Google Sheets using Pabbly Connect. Follow our detailed step-by-step tutorial. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To automate sending WhatsApp Business messages for new rows in Google Sheets, start by accessing Pabbly Connect. Go to the Pabbly website and select ‘Connect’ to begin your automation journey.

If you are new to Pabbly, click on the ‘Sign Up Free’ option to create your account. Existing users can simply sign in. Once logged in, navigate to the Pabbly Connect dashboard by clicking on the ‘Access Now’ button. Here, you can manage all your automation workflows.

2. Creating a New Workflow in Pabbly Connect

In this section, we will create a new workflow in Pabbly Connect. Click on the ‘Create Workflow’ button and select the option to create from scratch. Name your workflow ‘Send WhatsApp Business Messages for New Google Sheets Rows’ and choose the appropriate folder.

• Click on the ‘Plus’ icon to add a new trigger.
• Select ‘Google Sheets’ as the trigger application.
• Choose the event ‘New or Updated Spreadsheet Row’.

After selecting the trigger, click on the ‘Connect’ button. You will receive a webhook URL, which you need to copy for the next step. This URL is crucial as it links your Google Sheets to Pabbly Connect.

3. Setting Up Google Sheets with Pabbly Connect

Next, open your Google Sheets and navigate to the ‘Extensions’ menu. Click on ‘Pabbly Connect Webhooks’ and select ‘Initial Setup’. Here, paste the webhook URL you copied earlier.

• Set the trigger column to the final data column, which is typically column F.
• Click ‘Send Test’ to verify the connection.

Once the test is successful, click on the ‘Submit’ button to finalize your setup. Ensure that the ‘Send On Event’ toggle is active, or else Pabbly Connect won’t receive any responses from Google Sheets.

4. Sending WhatsApp Messages Using Pabbly Connect

Now that the Google Sheets setup is complete, it’s time to configure the action step in Pabbly Connect. Click on the plus icon to add an action application and select ‘Pabbly Chatflow’.

Choose the event ‘Send Template Message’. Connect your Pabbly Chatflow account by entering the API token.

Once connected, map the recipient mobile number from the previous Google Sheets step. This is crucial for personalizing the message sent to the user. Select the appointment confirmation message template you previously created in Pabbly Chatflow and fill in the necessary fields using the data mapped from Google Sheets.

5. Finalizing and Testing the Automation

After setting up the message template, review all fields to ensure they are correctly mapped. Click on the ‘Save and Send Test Request’ button to send a test message. You should receive a confirmation message on your WhatsApp.

Remember, the recipient mobile number must include the country code without the plus sign. Once you confirm that the message is sent successfully, your automation is ready to go live. Make sure to enable the workflow toggle in Pabbly Connect to activate your automation.

Conclusion

This guide summarizes the key points and helps you understand the essential features and benefits of using this tool.

By following these steps, you can automate WhatsApp Business messages for new entries in Google Sheets using Pabbly Connect. This powerful integration streamlines communication and enhances customer engagement in your business.