· 4 min · TextMeFlow Team

Send WhatsApp Messages from Google Sheets Without Code

Many businesses simply track bookings, orders or leads in a Google Sheet: a salesperson fills in a row, a form writes to the sheet, or someone copies data over from another system. That row is a perfect moment to send a WhatsApp message: a confirmation, a reminder, a welcome message. This article shows how to set that up without writing a line of code, using Google Sheets, Make.com and the TextMeFlow API.

Why Google Sheets as a trigger

Sheets isn't a CRM, but it's everywhere. Sales tracks leads in a sheet, the front desk notes bookings, an internal form (Google Forms, Typeform) writes responses to a tab. If you connect an automatic WhatsApp message to that, nobody has to type a message by hand or copy and paste into WhatsApp Web.

Typical uses:

  • A new row in "Bookings" → confirmation message to the customer.
  • A lead with status "new" → welcome message with a follow-up question.
  • A row in "Orders" gets status "shipped" → tracking message.

What you need

  • A Google account with the sheet.
  • A free TextMeFlow account with a linked WhatsApp number (QR scan, no Meta Business verification needed; see /en/docs/getting-started).
  • A Make.com account (the free plan is enough to test this).

Step 1: build the scenario in Make.com

  1. Create a new scenario and choose Google Sheets → Watch Rows as the trigger. Select your spreadsheet and the tab.
  2. Add a second module: HTTP → Make a request.
  3. Configure the HTTP module:
    • Method: POST
    • URL: your TextMeFlow send endpoint (found in your dashboard under API settings)
    • Headers: Content-Type: application/json and your API key as Authorization: Bearer <your-key>
    • Body (JSON), with fields mapped from the sheet row:
{
  "to": "{{1.telefoonnummer}}",
  "message": "Hi {{1.naam}}, your booking for {{1.datum}} is confirmed!"
}
  1. Replace {{1.telefoonnummer}}, {{1.naam}} and {{1.datum}} with the columns from your sheet. Make shows them automatically when you click the field.
  2. Set the trigger to an interval of, say, 1 or 5 minutes, or use a watermark column ("sent: yes/no") so you never send twice.

Step 2: format phone numbers correctly

The most common mistake is a wrongly formatted phone number in the sheet: 0470123456 instead of 32470123456. WhatsApp numbers must be in international format without + or 00. In Make, add a Text parser or a simple formula that converts local numbers, or enforce a fixed format in the sheet itself with data validation. A wrong number doesn't cause a crash; the message simply never arrives anywhere.

Step 3: prevent duplicate sends

Without extra logic, "Watch Rows" re-reads all rows that match the filter on every run. Solve this with a status column: add a "WhatsApp sent" column, filter the trigger on rows where that column is empty, and after the HTTP module add an Update a Row module that sets that column to "yes". That way you send each row exactly once.

Personalising without spam risk

Because every message sent through the API is personalised with a name, date or order number, it doesn't look like a bulk broadcast, and that's exactly what protects WhatsApp numbers from being blocked. On top of that, TextMeFlow automatically applies rate limiting, a risk score and respect for quiet hours to every outgoing message, regardless of which tool you send through. Want to understand in more depth how that works? Read /en/docs/anti-spam.

Alternative: n8n or Zapier

Prefer to work with n8n (self-hosted, free) or Zapier? The principle is identical: a Google Sheets trigger followed by an HTTP node to the same endpoint. We described that setup in detail with all three tools in Sending WhatsApp messages from n8n, Make.com or Zapier.

Know the limits

The free TextMeFlow plan gives you 50 messages per month, forever, which is enough to test this scenario. For production volumes (daily bookings, order updates) you switch to a paid plan with higher quotas and, if needed, multiple linked devices from the Business plan.

Google Sheets isn't the most robust data source, but for small teams without a CRM it's the fastest way to go from a manual process to automatic WhatsApp communication, without needing a developer.

Ready to set it up yourself? Create a free account and send your first automated message within ten minutes.

Want to send WhatsApp messages via API yourself?

Free forever up to 50 messages/month. Scan a QR and send your first message within 5 minutes.

Free forever