Google Sheets — send WhatsApp messages from spreadsheet rows

🎯 Goal

Add a row and a WhatsApp message goes out. Great for bookings, fee reminders, deliveries or Google Form sign-ups.

🧰 What you need

• A Google Sheet with a header row (one column holds the phone number)
• An approved template

Steps

1. In MeAPI: Integrations → Google Sheets → Connect. Copy the Webhook URL and the secret.
2. Open your Google Sheet. Row 1 holds column names; include one for the phone number, for example phone, plus anything your template needs (name, date, amount).
3. Extensions → Apps Script. Replace everything with the script shown in MeAPI, paste your secret into MEAPI_SECRET, and save.
4. Click Run once (choose sendNewRows) and allow access.
5. Open Triggers (clock icon) → Add trigger → function sendNewRows, event source Time-driven, every minute. For Google Forms use From spreadsheet → On form submit instead.
6. Back in MeAPI, switch on New row, pick a template and map columns to its variables. Column names become the field names.
7. Add a test row with your own number.

Each row is sent once (its sheet ID + row number is the reference), and the script writes the result into the MeAPI status column.

The other direction

To write from WhatsApp into a Sheet (for example, leads captured by a chatbot), use the Google Sheets: add row step in the flow builder. See Data steps.

Common mistakes

• No time-driven trigger. Nothing is sent until you run the script by hand. Add the trigger.
• Renaming header columns after mapping. The mapping breaks. Re-map in MeAPI.
• Numbers formatted as numbers in Sheets, losing the +. Format the phone column as plain text, or include the country code without the +.

What’s next

Incoming webhooks →Zapier, Make, Pabbly, your own app.Tutorial: leads to Google Sheets →A chatbot that fills a Sheet.