How to Send WhatsApp Messages from Google Sheets Automatically

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 👇

📋 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 = Name
• C2 = 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 text
• ENCODEURL(): 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

1. Copy the formula down for all rows.
2. Click the link in WhatsApp Link column.
3. It will open WhatsApp (Web or App) with the message pre-filled.
4. 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!

Example: