Send Real-Time WhatsApp Messages from New Google Sheets Entries

Learn how to send real-time WhatsApp messages automatically from new Google Sheets entries using Pabbly Connect. Step-by-step guide included. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To send real-time WhatsApp messages using Pabbly Connect, you first need to access the platform. Open a new tab and type Pabbly.com/connect in the URL bar. This will take you to the Pabbly Connect homepage.

If you are new, click on the Sign Up Free button to create an account. Existing users can simply log in. Once logged in, you will see the dashboard where you can manage your integrations.

2. Creating a New Workflow in Pabbly Connect

After logging in, click on the Create Workflow button to initiate a new automation process. You will be prompted to select a workflow builder, either the beta or classic version. Choose the beta version for a modern experience.

• Enter a name for your workflow, such as Send Real-Time WhatsApp Messages from New Google Sheets Entries.
• Select a folder to organize your workflow.
• Click on the Create button.

Your workflow page will now display options for adding a trigger. This is where you will set up the Google Sheets integration.

3. Setting Up Google Sheets as a Trigger

In the workflow page, click on Add Trigger and select Google Sheets as your trigger app. Choose the event as New or Updated Spreadsheet Row. This means every time a new entry is added to your Google Sheet, the automation will activate.

Next, click on Connect to link your Google account. If you already have a connection, select it; otherwise, create a new one. After connecting, you will receive a webhook URL which acts as a bridge between Google Sheets and Pabbly Connect.

4. Configuring Google Sheets for Automation

In your Google Sheets, go to Extensions, then Add-ons, and select Get Add-ons. Search for Pabbly Connect Webhook and install it if you haven’t done so already. After installation, navigate back to Extensions and select Pabbly Connect Webhooks to set up the webhook.

• Paste the webhook URL you copied from Pabbly Connect.
• Set the trigger column as the last column of your data, for example, E.

Once configured, click Submit. This will ensure that every new entry in your Google Sheet sends data to Pabbly Connect automatically.

5. Setting Up WhatsApp Integration in Pabbly Connect

Now that your Google Sheets trigger is set, it’s time to configure WhatsApp. In your Pabbly Connect workflow, search for WhatsApp Cloud API and select it as your action app. Choose Send Template Message as the event.

Click on Connect and enter your WhatsApp business account details, including the token, phone number ID, and business account ID. This information is crucial for sending messages through WhatsApp.

For the recipient’s phone number, use mapping to pull data from the Google Sheets response. This allows Pabbly Connect to dynamically insert the lead’s phone number into the message template, ensuring personalized communication.

Conclusion

Using Pabbly Connect, you can effortlessly send real-time WhatsApp messages from new Google Sheets entries. This automation not only saves time but also enhances customer communication by ensuring prompt responses. Start using Pabbly Connect today to streamline your business processes.