Pabbly WhatsApp Automation with AiSensy
Introduction
WhatsApp marketing works best when it is automated. Sending messages manually may work for a few contacts, but it becomes impossible when you have hundreds or thousands of leads.
This is where automation tools come in.
By connecting Google Sheets with Pabbly and AiSensy, you can create a system where WhatsApp messages are sent automatically whenever a new lead is added. This setup is widely used by agencies, freelancers, coaches, eCommerce stores, and service businesses.
In this guide, you will learn how to set up Pabbly from scratch and connect it with Google Sheets and AiSensy in a simple and easy-to-remember way. No coding knowledge is required.
Why Use Pabbly with AiSensy
AiSensy is an official WhatsApp Business API provider. It allows businesses to send approved WhatsApp messages safely and at scale.
Pabbly Connect acts as a bridge between your data and AiSensy. It listens for new data and triggers WhatsApp messages automatically.
When combined with Google Sheets, this setup allows you to:
- Send WhatsApp messages automatically
- Personalize messages using customer data
- Eliminate manual follow-ups
- Build a scalable WhatsApp automation system
Tools Required Before You Start
Make sure you have the following:
- An active AiSensy account with WhatsApp API approved
- A Pabbly Connect account
- A Google account with access to Google Sheets
- At least one approved WhatsApp message template in AiSensy
Once these are ready, you can proceed.
How the Automation System Works
The automation follows a very simple flow.
Google Sheets stores your customer data.
Pabbly monitors the sheet for new entries.
AiSensy sends the WhatsApp message using the approved template.
Whenever a new row is added to the sheet, a WhatsApp message is sent automatically.
Step 1: Create and Prepare Your Google Sheet
Create a new Google Sheet and add the following column headers in the first row:
- name
- phone
- var1
- var2
- var3
These columns will store customer information and template variables.
Example Data
Name can be the customer’s name.
Phone should include the country code, for example 91 followed by the mobile number.
Variables can store order ID, city, date, or any custom information.
Make sure there are no spaces in the phone number and that the country code is included.
Step 2: Create a WhatsApp Template in AiSensy
Before connecting Pabbly, you must have an approved template in AiSensy.
Example Template
Hello {{1}},
Your order {{2}} has been confirmed.
Delivery location: {{3}}
Thank you for choosing us.
Template Variable Meaning
{{1}} represents the customer name
{{2}} represents order ID or reference number
{{3}} represents location or delivery date
Templates must be approved by Meta before they can be used.
Step 3: Create a New Workflow in Pabbly
Log in to Pabbly Connect and create a new workflow.
Give the workflow a simple name such as
Google Sheet to AiSensy WhatsApp Automation
This helps you manage workflows easily in the future.
Step 4: Set Google Sheets as the Trigger
Choose Google Sheets as the trigger application.
Select the trigger event that activates when a new row is added.
Connect your Google account and select the spreadsheet and worksheet where your data is stored.
After setup, run a test request so Pabbly can fetch sample data from your sheet.
Step 5: Understand Data Mapping in Pabbly
After testing, Pabbly will show all the column values from Google Sheets.
You should see fields like name, phone, var1, var2, and var3.
These values will be used later to personalize WhatsApp messages.
If the data appears correctly, your trigger is working properly.
Step 6: Connect AiSensy in Pabbly
Now add an action step in Pabbly.
Choose AiSensy as the action application and select the option to send a template message.
To connect AiSensy, you will need an API key.
You can find the API key inside your AiSensy dashboard under API or integrations settings.
Once connected, you are ready to configure the message.
Step 7: Configure the WhatsApp Message Action
This is the most important step.
Phone Number
Map the phone field from Google Sheets.
Template Name
Enter the exact template name created in AiSensy.
The name must match exactly.
Language Code
Use the language code selected during template creation, such as en or en_US.
Step 8: Map Template Variables Correctly
Template variables must be mapped in order.
The first variable goes to {{1}}, the second to {{2}}, and so on.
Example mapping:
- Variable 1 mapped to name
- Variable 2 mapped to var1
- Variable 3 mapped to var2
This order must always be followed.
Step 9: Test the Automation
After configuration, send a test request from Pabbly.
Check the WhatsApp number mentioned in the sheet.
If the message is received correctly, your automation is working.
Testing is important before using real data.
Step 10: Start Using the Automation Live
Now your system is live.
Every time you add a new row in Google Sheets, a WhatsApp message will be sent automatically using AiSensy.
There is no need to upload contacts manually or send messages one by one.
Common Mistakes to Avoid
- Using a personal WhatsApp number instead of API
- Forgetting the country code in phone numbers
- Using an unapproved template
- Mapping variables incorrectly
- Sending marketing messages without user consent
Avoiding these mistakes keeps your WhatsApp number safe.
Best Use Cases for This Setup
This automation is ideal for:
- Lead follow-ups
- Order confirmations
- Course enrollments
- Appointment reminders
- Payment notifications
- CRM replacement for small businesses
Why This Setup Is Business-Friendly and SEO-Worthy
This system is simple, scalable, and compliant with WhatsApp policies.
It saves time, reduces manual effort, and improves response rates.
Because it uses official APIs, it is safe for long-term business growth.
For anyone looking to implement intelligent WhatsApp marketing, this setup is one of the most reliable solutions available today.