Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Chatflow for Automation

To start automating your WhatsApp messaging, first access Pabbly Chatflow. Open your browser and visit pabble.com, then log in to your Pabbly account. If you’re an existing user, simply click on “Sign In” to access the dashboard.

Once logged in, navigate to the Pabbly Chatflow application from the dashboard. This is where you will set up the automation to send WhatsApp messages. Make sure you have your Google Sheets ready with the contact details you want to message.

2. Creating a Workflow in Pabbly Chatflow

To create a new workflow, click on “Create Workflow” and select “Create from Scratch.” Name your workflow something descriptive, like “Send WhatsApp Greetings to Customers,” and choose a folder to organize it.

  • Click on “Add Trigger” to start your workflow.
  • Select Google Sheets as the trigger application.
  • Choose the event “New and Updated Spreadsheet Row” to capture new data.

After selecting your trigger, connect your Google Sheets account to Pabbly Chatflow. This allows the workflow to receive data directly from your sheet whenever a new entry is made.

3. Setting Up Webhooks in Pabbly Chatflow

Next, you need to set up webhooks to connect Google Sheets with Pabbly Chatflow. Copy the webhook URL provided by Pabbly Chatflow and head to your Google Sheets.

In Google Sheets, navigate to Extensions, then Add-ons, and click on “Get Add-ons.” Search for “Pabbly Connect Webhooks” and install it if you haven’t already. Once installed, refresh your sheet and go back to Extensions, select Pabbly Connect Webhooks, and click on “Initial Setup.”

  • Paste the copied webhook URL into the designated field.
  • Enter the trigger column where your data will be sent.
  • Click on “Send Test” to ensure the connection is successful.

After confirming the setup, you will see a success message indicating that the webhook is correctly configured. This step is crucial for sending data from Google Sheets to Pabbly Chatflow.

4. Sending WhatsApp Messages Using Pabbly Chatflow

Now, it’s time to send WhatsApp messages. In your workflow, click on “Add Action” and select Pabbly Chatflow as the action application. Choose the event “Send Text Message” to initiate the messaging process.

If you already have a connection, save it; otherwise, click “Add New Connection” to enter your API token from Pabbly Chatflow. Once connected, you will need to map the recipient’s WhatsApp number and the message content from your Google Sheets.

  • Map the phone number field, ensuring it includes the country code without a plus sign.
  • Enter your personalized message, using dynamic fields to customize it for each recipient.

After mapping the details, click on “Save and Send Test Request” to verify that the message is sent correctly. Check your WhatsApp to confirm that you received the message.

5. Finalizing Your Automation with Pabbly Chatflow

After successfully sending a test message, you can finalize your automation. Return to your Google Sheets and click on Extensions, then Pabbly Connect Webhooks, and select “Send All Data” to send messages to all contacts listed.

Once you click “Send All Data,” all your customers will receive their personalized WhatsApp messages. This step completes the integration of Google Sheets with Pabbly Chatflow, allowing you to automate bulk messaging seamlessly.

Make sure to check your WhatsApp for the messages sent to all the contacts. You should see personalized greetings for each customer, confirming that the integration works perfectly.

Conclusion

This tutorial demonstrated how to automate WhatsApp messaging using Pabbly Chatflow and Google Sheets. By following these steps, you can efficiently send bulk messages to your customers with just one click.