The problem
Confirmation emails land in promotions tabs, and buyers message you asking “did my order go through?”. Answering each one by hand eats the day.
Most store platforms export orders to CSV. Wassender turns that file into one personal message per buyer without a paid API integration.
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 | Items | Total | Delivery ETA | Tracking link |
|---|---|---|---|---|---|---|
| +1 416 555 0190 | Olivia | #10482 | 2 × Linen shirt | $84.00 | Nov 14–16 | track.example/10482 |
| +65 8123 4567 | Wei Ling | #10483 | Ceramic mug set | S$39.90 | Nov 13 | track.example/10483 |
| +44 7700 900321 | Tom | #10484 | Running cap | £18.00 | Nov 15 | track.example/10484 |
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.
Order confirmation
Hi [name|there], thanks for your order *[order_no]*! 🧾
Items: [items]
Total: [total]
Estimated delivery: [delivery_eta]
Reply here if anything needs changing.Shipped notice with tracking
Good news [name|there] — order [order_no] has shipped. Track it here: [tracking_link]. Questions? Just reply.
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
Can I attach the invoice?
Yes. Add a PDF, image or video as an attachment with the campaign. The same file goes to every recipient; per-customer details go in the text via variables.
Does it connect to Shopify automatically?
No. Wassender works from a spreadsheet: export the orders to CSV or Excel and import that file. There is no automatic store integration.
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: