wassenderThe problem
Renewals slip because the expiry date lives in a spreadsheet nobody checks daily, and generic emails go unread.
Export members expiring in the next 7–14 days and send each one a personal reminder in a single campaign.
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 | Plan | Expiry date | Days left |
|---|---|---|---|---|
| +1 305 555 0144 | Carlos | Monthly | Nov 15 | 6 |
| +44 7700 900222 | Emma | Annual | Nov 20 | 11 |
| +61 412 345 678 | Liam | 10-class pass | Nov 13 | 4 |
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.
Renewal reminder
Hi [name|there]! Your [plan] membership ends on *[expiry_date]* ([days_left] days left). Reply RENEW and we'll send you the link. 💪Last call
[name|Hi], your [plan] expires on [expiry_date]. [if days_left<=3?That's only a few days away!|] Want to keep your spot? Reply here.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 an auto-reply send the renewal link when someone replies RENEW?
Yes. Create an Autopilot keyword rule for RENEW that replies with your payment or booking link.
Can I run this every week?
Yes. Export the new list each week and run the campaign, or schedule it for a fixed time on the Unlimited plan.
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: