Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Google Sheets + WhatsApp: Diwali automation in 10 minutes

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Chatflow for Integration

To start integrating applications like WhatsApp and YouTube, first access Pabbly Chatflow. Open a new tab and go to Pabbly’s official website. If you’re new, click on “Sign Up for Free” to create your account.

Once logged in, navigate to the workflow builder within Pabbly Chatflow. Here, you can set up automation to send messages based on triggers from other applications.

2. Setting Up Trigger in Pabbly Chatflow

In this section, you will set up a trigger to initiate the workflow. Choose Google Sheets as your trigger application and select the event as ‘New or Updated Spreadsheet Row’. This event will capture any new data added to your sheet.

Open your Google Sheets and add the necessary customer details.
Copy the webhook URL provided by Pabbly Chatflow.
Install the Pabbly Connect Webhook add-on from the Google Sheets add-ons menu.

After installing, paste the webhook URL in the initial setup of the add-on. This will allow your Google Sheets data to trigger actions in Pabbly Chatflow.

3. Sending Test Request to Pabbly Chatflow

Once your trigger is set up, it’s time to send a test request. Click on the ‘Send Test’ button in the Pabbly Connect interface. This action will capture the response from your Google Sheets.

After capturing the webhook response, you can proceed to the action step. Here, add Pabbly Chatflow as the action application. Choose the event ‘Send Text’ to send a WhatsApp message.

Click on “Add a New Connection” and enter your API token from the Pabbly Chatflow dashboard.
Map the customer’s WhatsApp number from the test response to the appropriate field.
Customize your message with dynamic fields for personalization.

After setting this up, save your changes and send a test request to ensure everything is working correctly.

4. Sending Messages to Multiple Customers

To send messages to all customers listed in your Google Sheets, go back to Pabbly Chatflow. You will use the “Send All Data” option in the Pabbly Connect Web interface.

Click on the button to send all data, which will automatically trigger messages to every customer in your sheet. This allows you to send personalized greetings like “Happy Diwali” to multiple recipients at once.

Ensure all customer details are correctly filled in your Google Sheets.
Verify your WhatsApp message template in Pabbly Chatflow for any necessary approvals.
Monitor the responses to check if messages were sent successfully.

Once you click the button, your messages will be sent automatically, ensuring a seamless experience for your customers.

5. Conclusion

In this tutorial, we demonstrated how to use Pabbly Chatflow to automate the sending of WhatsApp messages using data from Google Sheets. By integrating these applications, you can efficiently manage communications with your customers.

With the ability to send up to 100 free messages, you can easily reach out to your audience during special occasions. Pabbly Chatflow simplifies this process, making it easy to connect various applications for effective automation.