← All use cases USE CASE · CSV CAMPAIGNS

How to send WhatsApp messages to 500 opted-in customers from CSV

You have a CSV export from your store or CRM with 500 customers who agreed to hear from you on WhatsApp. This is how to send them one personal message each without saving a single number.

Add to Chrome — free 5.0★ · 19 ratings · 257 users

Step by step

  1. Export only customers who opted in to WhatsApp messages. Keep a Phone column with the country code, plus any columns you want in the message.
  2. New campaign → Spreadsheet → upload the .csv. Duplicates, blank phones and too-short numbers are removed, and numbers on your opt-out list are skipped. Check the recipient count.
  3. Write one message with variables and a fallback for blank names, such as [name|there]. Preview several recipients.
  4. Keep human pacing and a daily limit. The free trial is 1 hour of Unlimited; after it, choose a paid plan or split the list over several days. A daily limit continues automatically the next day.
  5. Follow the live log, then open Reports to see delivered, failed, skipped and replied per recipient and export the results to Excel.

Sample spreadsheet

PhoneNameOrderPoints
12025550101MonaA-104212
+1 (202) 555-0101Duplicate MonaA-99994
—Missing phoneA-10434
123Invalid phoneA-10444
12025550102OmarA-10454
12025550103—A-104610

Paste this message into the campaign:

Hi [name|there], your order *[order]* is ready. Reply here to arrange pickup, or reply STOP to stop these messages.

What customers receive

The sample file has 6 rows but prepares 3 recipients: one duplicate, one blank phone and one invalid number are left out before anything is sent.

Related guide →

Chat with us