wassenderThe problem
A share of cash-on-delivery orders are refused at the door, mistyped or never meant seriously, and each one costs shipping both ways.
Calling every buyer is slow. A WhatsApp message with the exact order, amount and address — answered with 1 or 2 — filters most bad orders before dispatch.
Sample spreadsheet
One customer per row. Each column header becomes a variable you can put in the message, e.g. a column called Order No becomes [order_no]. Keep the phone column formatted as text, with the country code.
| Phone | Name | Order No | Product | COD amount | City |
|---|---|---|---|---|---|
| +971 55 123 4567 | Ahmed | A-7781 | Wireless earbuds | AED 149 | Sharjah |
| +92 300 1234567 | Bilal | A-7782 | Smart watch | Rs 6,500 | Lahore |
| +62 812 3456 7890 | Dewi | A-7783 | Hijab set | Rp 189.000 | Bandung |
Ready message templates
Copy a template into the campaign editor. Words in [brackets] are replaced by that row's value; [name|there] uses “there” when the name cell is empty; {Hi|Hello} picks one wording per message.
Confirm before dispatch
Hi [name|there], we received your order *[order_no]*: [product] — *[cod_amount]* cash on delivery to [city].
Reply *1* to confirm or *2* to cancel. Unconfirmed orders are not shipped.Out for delivery
[name|Hi], your order [order_no] is out for delivery today. Please keep [cod_amount] ready. Reply here if you won't be home.How to send it with Wassender
- Install Wassender from the Chrome Web Store, open web.whatsapp.com in Chrome and link your phone by scanning the QR code.
- Save your list as Excel (.xlsx/.xls) or CSV with one customer per row. Put full numbers with the country code in a phone column and format that column as text.
- Open the Wassender dock on WhatsApp Web (Alt + W), choose New campaign → Spreadsheet, upload the file (or paste a public Google Sheets link), pick the phone column and set a default country code for numbers without one.
- Paste a template below. Column headers become variables in [brackets]; add an attachment such as a PDF invoice or an image if you need one.
- Preview the message for several rows, keep the default human pacing, and start — or schedule the campaign for a date and time (Unlimited plan).
- Follow the delivery report (delivered, failed, skipped, replied) and export it to Excel. Replies arrive in WhatsApp as usual; an Autopilot keyword rule can answer common ones, and anyone who replies STOP is skipped in future campaigns.
Safe-sending tips (avoid bans)
- Message only people who gave you their number and expect to hear from you: customers, patients, parents, leads who asked.
- Keep Wassender's randomized delays and rests between batches on; do not shorten them to finish faster.
- On a new or rarely used number, start with a small daily limit (for example a few dozen) and increase slowly over weeks.
- Use sending hours so messages arrive during the day in the recipient's time zone.
- Personalize with real data ([name], order or appointment details) and vary the greeting with {Hi|Hello}; identical text to hundreds of people looks like spam.
- Add one line on how to stop messages (Reply STOP). Wassender adds those numbers to an opt-out list automatically.
- Wassender skips numbers that are not on WhatsApp and pauses automatically after repeated failures — check the list before resuming.
Frequently asked questions
How do I see who confirmed?
Replies land in WhatsApp and the campaign report marks who replied; export it to Excel and filter. An Autopilot rule can thank people who reply 1.
Can I send in several languages?
Yes. Run one campaign per language, or keep a Language column and use a condition to choose the text.
Do I need the WhatsApp Business API?
No. Wassender works inside your own WhatsApp Web session in Chrome, with a normal WhatsApp or WhatsApp Business account. There is no API approval, template review or per-message fee from Meta.
Do the numbers have to be saved in my phone?
No. Numbers come from the spreadsheet's phone column; they do not need to be saved as contacts. Make sure each has the right country code.
Can my number get banned?
Any number that sends unwanted messages can be restricted by WhatsApp. Wassender adds human pacing, daily limits, sending hours and automatic pauses, but the most important rule is to message only people who expect your messages.
Related pages
Last checked: