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

Set Up Google Sheets to WhatsApp Automation in 5 Minutes 🔥

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect to Start Automation

To begin using Pabbly Connect, you need to access the platform by typing the URL pabbly.com/connect in your browser. This will take you to the homepage where you can either sign in or sign up for a free account.

If you’re a new user, click on “Sign Up Free” to create an account, which will give you 100 free tasks every month. Existing users can simply click “Sign In” to access their accounts and start creating automations.

2. Creating a Workflow in Pabbly Connect

Once signed into Pabbly Connect, navigate to the workflow page to start your automation. This is where you will set up the integration between Google Sheets and WhatsApp.

Click on “Create Workflow”.
Select Google Sheets as your trigger application.
Choose “New or Updated Spreadsheet Row” as the trigger event.

After selecting the trigger, click on the “Connect” button to generate a webhook URL. This URL is essential for connecting Google Sheets with Pabbly Connect.

3. Setting Up Google Sheets with Pabbly Connect

Now, open your Google Sheets where you want to track new entries. You will need to add the webhook URL generated from Pabbly Connect to your Google Sheets.

To do this, go to “Extensions” > “Add-ons” > “Get add-ons” and search for the Pabbly Connect Webhooks add-on. Once installed, navigate back to Extensions and select “Pabbly Connect Webhooks” > “Initial Setup” to paste the webhook URL.

Enter the webhook URL in the setup dialog.
Specify the last data column in your Google Sheet.

After submitting the setup, you will receive a confirmation popup indicating that the configuration was successful. This means your Google Sheets are now linked to Pabbly Connect.

4. Integrating WhatsApp with Pabbly Connect

Next, you will set up WhatsApp as your action application in Pabbly Connect. This enables sending WhatsApp messages automatically when new entries are added in Google Sheets.

Select WhatsApp Cloud API as your action application and choose “Send Text Message” as the action event. Click the “Connect” button to set up the connection.

You can either use an existing connection or create a new one.
Input your WhatsApp Business Account details including token, phone number ID, and account ID.

Once the connection is established, you can map the fields from Google Sheets to WhatsApp, ensuring that the correct information is sent to your leads.

5. Testing and Finalizing Your Automation

After mapping the necessary fields, it’s time to test your automation. Click on “Save and Send Test Request” in Pabbly Connect to verify that the WhatsApp message is sent successfully.

Check your WhatsApp to confirm that the message appears as expected. If the test is successful, your automation is ready to go live! Ensure that you enable the “Send on Event” option in Google Sheets to automate the process fully.

With this setup, every time you add a new row in your Google Sheets, Pabbly Connect will automatically send a WhatsApp message to the specified number, making your workflow efficient and streamlined.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate sending WhatsApp messages for new entries in Google Sheets. This powerful integration enhances productivity and simplifies communication with leads.