Back to the home page
Email being written
Renewal reminders, without the copy-pasting
The real version saved a Malaysian insurance brokerage 61 hours per 1,000 renewals. This replay uses made-up clients, and nothing is sent.
Step 1
Delete
Before, every reminder was done by hand, one at a time.
- Open last year's email and copy itDeleted
- Change the name, amount and expiryAutomated
- Find the right forms and attach themAutomated
- Send it, then start the next oneAutomated
- Remember who already got oneSimplified
Step 2
Simplify
One renewals sheet, one row per client, one email template.
Renewals sheet
| Client | Expires | Cover | Premium | Forms | Status | |
|---|---|---|---|---|---|---|
| Klinik Pergigian Seri Aman | aina@seri-aman.example | 2 Nov 2026 | Professional indemnity | RM 1,850 | 2 | |
| Kedai Kopi Ah Seng | tan@ahseng.example | 5 Nov 2026 | Fire | RM 620 | 1 | Sent 15 Oct |
| Farmasi Nur Sihat | nurul@nursihat.example | 9 Nov 2026 | Professional indemnity | RM 1,240 | 2 | |
| Pusat Tuisyen Cemerlang | liyana@cemerlang.example | 12 Nov 2026 | Public liability | RM 480 | 1 | |
| Bengkel Motor Jaya | 14 Nov 2026 | Fire and theft | RM 950 | 1 | ||
| Butik Hana | hana@butikhana.example | 18 Nov 2026 | Fire and burglary | RM 710 | 1 | Sent 15 Oct |
| Katering Mak Long | rohani@maklong.example | 21 Nov 2026 | Product liability | RM 560 | 2 | |
| Studio Lensa | wong@studiolensa.example | 27 Nov 2026 | Equipment | RM 890 | 1 |
Step 3
Automate, with rules only
Press run. The rules work down the sheet, row by row.
- Pick rows with an email and no status
- Fill in the template
- Attach that client's forms
- Send it from Gmail
- Mark the row SENT
- Wait 2 minutes, then the next row
- Sent
- 0
- Skipped
- 0
- For a person
- 0
- Copy-pasting avoided
- 0 min
The real one waits 2 minutes between emails so Gmail does not flag it. The replay skips the wait, but the times in the sheet follow the real pace.
Press run to watch the first reminder being written.
Time saved uses the real result: 61 hours per 1,000 renewals, about 3.7 minutes per reminder.