How to send WhatsApp messages from Google Sheets

Last updated: 12 October 2026

Google Sheets is where a lot of small teams actually keep their contacts, and it has its own set of habits that can quietly wreck a send. This guide covers the Google-Sheets-specific path: why there is no send button, the safe export, the traps that mangle phone numbers, a thirty-second cleanup recipe, and the errors that stop a row from sending. If you use desktop Excel instead, our Excel and CSV guide covers that side.

Why Google Sheets has no "send to WhatsApp" button

Sheets is a spreadsheet, not a messaging client. It has no connection to your WhatsApp account, and WhatsApp has no import feature that reads a spreadsheet. When you see a "send to WhatsApp" add-on, it is not WhatsApp listening to Sheets — it is the add-on reading your rows and then driving something else, usually the WhatsApp Web session already open in your browser. That means the whole job reduces to two steps you can control yourself: get the data out of Sheets cleanly, then hand it to a sender you trust. This guide is about doing the first step properly, because almost every failure downstream is a spreadsheet problem.

The safe export path

Google Sheets exports CSV well, and it does one thing better than desktop Excel: it writes CSV as UTF-8 by default, so accented names and other non-Latin characters survive without you hunting for a special option.

1. Check the grid first. Your export is only as good as what is on screen, so remove blank rows, confirm the phone column, and make sure the header row names your columns.
2. Choose File → Download → Comma-separated values (.csv, current sheet). Pick the single sheet you need rather than a workbook export.
3. Open the downloaded file once and confirm the first column shows your headers and the numbers look intact. If the numbers already look wrong here, fix them in Sheets and re-export — do not try to repair them in the CSV.

The Google Sheets traps that break a send

These are the patterns that cause the most failed rows, and every one of them happens before you ever reach the sender.

Clean the phone column in 30 seconds

If your numbers are already in shape, skip this. If they are not, this recipe rebuilds the whole column from what is there and leaves you with clean, consistent values. It assumes your numbers are in column A starting at A2 with a header in A1.

1. Insert a helper column next to the phone column (say, column B).
2. In B2, build the international form by stripping everything that is not a digit and adding the country code. For a US list that is ="1"&REGEXREPLACE(TO_TEXT(A2),"\D",""). Change the "1" to your own country code for other countries.
3. Drag the fill handle down to the last row so every row has a clean value.
4. Select the helper column, copy it, then use Edit → Paste special → Values only to paste it back into the original phone column. This replaces the formula with the finished text.
5. Delete the helper column, then set the phone column to Format → Number → Plain text so nothing reinterprets the values.

The point of the last two steps is that you end with static text, not formulas. If you export while the helper column is still a formula, the CSV contains the formula's result only for the current locale and the column may not line up with your header — always paste as values and delete the helper before exporting.

Import and send

1. Install the extension and open web.whatsapp.com in the same browser, signed in. That tab is the account your messages will come from, so leave it open.
2. Open the extension and import your exported CSV. It is read locally in your browser to build the contact list.
3. Compare the number of contacts it reports against the number of rows in your sheet. A mismatch almost always means a blank row, a stray header or a row the importer could not parse.
4. Write your message with placeholders, set a randomised interval and your daily cap, then run a small test batch to yourself before sending the full list.
5. When the run finishes, export the delivery report and use the failing rows to clean next month's list.

Troubleshooting: why a row did not send

Personalise with {column} placeholders

The header row is what makes personalisation possible. Whatever you call a column becomes a placeholder you can use in the message: a name column feeds {name}, a company column feeds {company}, and any other column you keep — an order number, an appointment date, a membership tier — becomes its own variable. Each recipient's message is then assembled from their own row.

Before sending, it is worth seeing the finished messages rather than trusting the merge. The free WhatsApp Message Personaliser lets you paste your template and sample rows and preview exactly what each person will receive. Our guide to personalised WhatsApp messages goes deeper on structuring the sheet and the wording so the merge reads naturally.

Frequently asked questions