Want to automate WhatsApp messages directly from Google Sheets? Whether you’re reminding customers about dues or sending updates, this trick saves time and effort!
Let’s walk through the step-by-step guide 👇
Table of Contents
📋 Sample Data
| Name | Phone Number | Amount | Message | WhatsApp Link |
|---|---|---|---|---|
| Rahul Sharma | 9876543210 | ₹500 | (Auto-generated) | (Auto-generated) |
| Priya Verma | 9123456789 | ₹1200 |
🛠️ Step 1: Create the Auto-Message
In the Message column, use this formula:
="Hi "&A2&", your amount due is ₹"&C2&". Kindly make the payment as soon as possible!"
🔹 Explanation:
A2= NameC2= Amount- Output:
Hi Rahul Sharma, your amount due is ₹500. Kindly make the payment as soon as possible!
🧷 Step 2: Create the WhatsApp Link
Now generate a clickable WhatsApp message link:
=HYPERLINK("https://api.whatsapp.com/send?phone="&C2&"&text="&ENCODEURL(D2), "Send WhatsApp Message")Explanation:
C2: contains the phone number (with country code, no + sign, e.g., 919876543210)D2: contains the custom message textENCODEURL(): ensures message formatting works- The clickable text will be “Send WhatsApp Message”
✅ Final Output (Example)
| Name | Phone Number | Amount | Message | WhatsApp Link |
|---|---|---|---|---|
| Rahul Sharma | 919876543210 | 500 | Hi Rahul Sharma, your amount due is ₹500. Kindly… | Click to send |
🚀 How to Use It
- Copy the formula down for all rows.
- Click the link in WhatsApp Link column.
- It will open WhatsApp (Web or App) with the message pre-filled.
- Hit Send.
⚠️ Important Tips:
- Use phone numbers with country code (e.g., 91 for India).
- Make sure
ENCODEURL()is used to avoid message errors. - This does not send automatically; it prepares the message — user clicks and sends.
🎯 Final Words
This is a simple and effective automation to improve your communication with clients or customers. It works great for reminders, confirmations, and alerts — all straight from your Google Sheet!
