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

From Google Sheets to WhatsApp: Send Messages with Images

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin integrating WhatsApp with Google Sheets, you first need to access Pabbly Connect. Open your browser and type in the URL pabbly.com/connect to reach the Pabbly Connect homepage.

Once there, you will see options to sign in or sign up. If you are new to Pabbly Connect, you can sign up for a free trial to start creating your automation without any coding skills.

2. Creating a Workflow in Pabbly Connect

After signing in, navigate to the workflow page in Pabbly Connect. Here, you will set up your automation workflow that triggers when a new entry is made in Google Sheets.

Select “Google Sheets” as the trigger application.
Choose the event as “New or Updated Spreadsheet Row”.
Copy the provided webhook URL for further steps.

This webhook URL acts as a bridge between Google Sheets and Pabbly Connect, allowing data to be captured automatically when new entries are made.

3. Setting Up Google Sheets with Pabbly Connect

Next, open your Google Sheets where you have your leads. Add a new entry with the user’s name, phone number, and image URL. This data will be sent to WhatsApp.

To link Google Sheets with Pabbly Connect, go to Extensions > Add-ons > Get Add-ons. Search for “Pabbly Connect Webhooks” and install it if not already installed.

Select “Pabbly Connect Webhooks” from Extensions.
Click on “Initial Setup” and paste the webhook URL.
Set the trigger column to the last data column (C in this case).

Once set up, send a test data to ensure the connection is successful. This step is crucial for the automation to work seamlessly.

4. Sending WhatsApp Messages Using Pabbly Chat Flow

Now that Google Sheets is integrated, the next step is to send WhatsApp messages using Pabbly Chat Flow. This application allows you to send personalized messages and images to your leads.

In Pabbly Connect, select Pabbly Chat Flow as the action application. Choose the event as “Send Image Message” to send an image along with a caption.

Enter the recipient’s WhatsApp number using mapping from Google Sheets.
Map the image URL from the Google Sheets response.
Provide a personalized caption using the user’s name.

After configuring these fields, click on “Save and Send Test Request” to send a test message. This confirms that your automation is working correctly.

5. Conclusion

In this tutorial, we demonstrated how to integrate WhatsApp with Google Sheets using Pabbly Connect. By following the steps outlined, you can automate sending personalized messages and images to your leads effortlessly.

This powerful integration not only saves time but also enhances customer engagement. Start using Pabbly Connect today to create your own automations and improve your workflow!