Send WhatsApp Messages from Excel with Power Automate
Many small businesses in Belgium and the Netherlands plan appointments, orders or leads in a plain Excel file — often shared via OneDrive or SharePoint so the whole team can work in it. Every new row is a good moment to send a WhatsApp message automatically: a confirmation, a reminder, a status update. This article shows how to set that up with Excel, Power Automate and the TextMeFlow API, without writing a line of code.
Why Excel as a trigger
Excel isn't a CRM, but inside Microsoft 365 environments it's often the first system where data lands: a schedule, an order list, an intake form that writes to a worksheet. If a WhatsApp message is hooked up to that automatically, nobody has to phone, email or copy-paste into WhatsApp Web by hand.
Typical uses:
- A new row in "Appointments" → confirmation message with date and time.
- A row in "Orders" with status "shipped" → tracking message to the customer.
- A row in "Leads" → welcome message with a follow-up question.
What you need
- An Excel file on OneDrive for Business or SharePoint (Power Automate doesn't work with a local
.xlsxfile on your own drive). - The data must be in an Excel table (not just a range of cells) — select your data and use "Insert → Table" so Power Automate recognizes the columns.
- A free TextMeFlow account with a linked WhatsApp number (QR scan, no Meta Business verification needed — see /en/docs/getting-started).
- A Power Automate license (included with most Microsoft 365 Business subscriptions).
Step 1: build the flow in Power Automate
- Create a new automated cloud flow with the trigger "When an item is created or modified" (SharePoint) if your data lives in a SharePoint list, or use a scheduled flow instead that periodically checks the Excel table for new rows via the "Get rows" action (Excel Online Business).
- For the Excel route: after "Get rows", add a Filter array that only lets through rows where the "Sent" column is empty.
- Add an HTTP action:
- Method:
POST - URI: your TextMeFlow send endpoint (you'll find it in your dashboard under API settings)
- Headers:
Content-Type: application/jsonand your API key asAuthorization: Bearer <your-key> - Body, with dynamic fields from the row:
- Method:
{
"to": "@{items('Apply_to_each')?['Telefoonnummer']}",
"message": "Hi @{items('Apply_to_each')?['Naam']}, your appointment on @{items('Apply_to_each')?['Datum']} is confirmed."
}
- Wrap the "Apply to each" loop around the HTTP action so every row is processed separately.
Step 2: format phone numbers correctly
The most common mistake is a locally formatted phone number in the column: 0470123456 instead of 32470123456. WhatsApp numbers must be in international format without + or 00. In Excel, add a helper column with a formula that replaces the leading zero with the country code (="32"&MID(A2,2,20)), or add a Compose action in Power Automate that does the same replacement with the replace() expression. A wrong number doesn't produce an error in Excel, but the message simply never arrives anywhere.
Step 3: prevent duplicate sends
A scheduled flow that runs "Get rows" every few minutes reads all rows that match the filter again on every run — unless you prevent that. Add a "Sent" column to the table, filter on rows where that column is empty (step 1), and after the HTTP action use "Update a row" to set that column to "yes". That way the flow sends each row exactly once, even though it runs continuously in the background.
Handling status codes
The TextMeFlow API returns an HTTP status code on every call. After the HTTP action, add a condition that checks whether the status is 200; if not, write the error code back to an "Error message" column so you can see in Excel right away which rows weren't sent — for example because of an invalid number or a rate limit that was reached. You can read more about how TextMeFlow manages sending speed and risk at /en/docs/anti-spam.
Feeding status updates back via webhooks
Power Automate can also work the other way round: TextMeFlow sends an HMAC-signed webhook on every status change (sent, delivered, read, failed). Catch it with a "When an HTTP request is received" trigger and write the status back to the same Excel row, so your Excel file always shows the current delivery status without anyone having to open the dashboard. The structure of those webhook payloads is described at /en/docs/webhooks.
Alternative: Power Automate Desktop or Zapier
If your file really is local and not on OneDrive/SharePoint, cloud Power Automate isn't an option — look at Power Automate Desktop instead, which can read local Excel files through an RPA flow, or move the table to Google Sheets and use Make.com or Zapier as described in our article on WhatsApp from Google Sheets. For teams who prefer a script over a visual flow, a direct API call in PHP, Python or Node is also possible — see /en/blog/send-whatsapp-messages-php-python-nodejs.
Getting started
You don't need Meta Business verification or approval to start: link your WhatsApp number with a QR scan and test the flow with a few rows. TextMeFlow's free plan gives you 50 messages a month to set it up and test it — create a free account and connect your Excel file today.
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