How to Send a WhatsApp Broadcast from a Google Sheet

If your recipient list lives in a spreadsheet, you don't need to export a CSV every time. ConvoFly can read a Google Sheet directly as the audience for a broadcast or a drip campaign — and because it re-reads the sheet on every send, rows you add later are picked up automatically.

Set it up

1. In the audience picker, click the Google Sheet tab.
2. Click Sign in with Google and approve access — a one-time step. (ConvoFly can only ever read the one sheet you pick.)
3. Click 📄 Choose from Google Drive and select your spreadsheet.
4. Pick the Tab (worksheet) to use.
5. Pick the Phone number column — the column that holds each person's number. Make sure your column names sit in a row near the top of the sheet.

Personalize from the sheet

This is the best part — a proper mail-merge. In the Message template section (or each step, for a drip campaign), every {{1}}, {{2}} can be filled from:

• Sheet column — that person's own value from their row (e.g. their name or order number).
• Contact's saved detail — an attribute you already store on the contact.
• Custom text — the same for everyone.

Set an "If blank, use…" fallback for any column so a missing cell never sends an empty message.

It stays live

The sheet is re-read every time the campaign sends, so newly-added rows are automatically included — ideal for a recurring broadcast or a drip campaign you top up over time.

Good to know

• Read-only. ConvoFly only reads the sheet you choose — it never edits it or sees your other files.
• Header row needed. Put column names (Phone, Name…) in a row near the top so the columns can be detected.
• Opt-outs still apply. Anyone who unsubscribed is skipped, even if they're in the sheet.
• One row per person. If the same number appears twice, the last row wins.
• Keep it shared to the connected Google account, or the live re-read can't run.