← All templates

Client Retention

Client Anniversary Touchpoints

Relationship businesses are won on small acts of attention. This workflow reads a dates sheet each morning, finds anyone with something worth acknowledging today, and either sends the note directly or hands you a drafted one so it still sounds like a person wrote it.

5 stepsRequires Zapier Starter or higher15 minEasy
Google SheetsGmailSlackSchedule by ZapierFilter by Zapier

What you get

No anniversary or renewal date is ever missed.
Clients hear from you when nothing is being sold.
Renewal conversations start before the renewal date, not after.

Workflow blueprint

SC
When this happens
Schedule by ZapierEvery Day
1GS
Google SheetsLookup Spreadsheet Row
2FI
Filter by ZapierOnly continue if
3GM
GmailCreate Draft
4SL
SlackSend Direct Message

The full blueprint — every field mapping, example value and the written copy for each message — is included with purchase.

Getting it into Zapier

Build this one from the recipe. The blueprint gives you the exact trigger, action events and field mapping for all 5 steps, so it is a copy-and-paste job rather than a design job.

You need your own Zapier account. Zapier’s Free plan runs single-step Zaps only; multi-step Zaps need a paid plan, and Paths and Webhooks need Professional. How this works →

Not on Zapier?

n8n — import and go

An n8n workflow JSON ships with this template. Import it and all 5 steps arrive on the canvas wired in order, and 5 of the 5 nodes arrive with their fields already filled in — the subject lines, the message copy, the delays, the column names. Every step maps to a native n8n node.

What an import cannot carry is your credentials, and the IDs that only exist inside your own account — which spreadsheet, which channel, which board. Those stay in a sticky note under the node, listing what is already done so you do not retype it, and what is left so you can see it.

Make — build guide

A Make-specific guide ships with this template: every module in order, every field value, and the concept translations that catch people out — filters live on the links between modules, and the schedule lives on the scenario rather than in a trigger module.

Self-hosted n8n has no per-task fee, which is worth knowing if this workflow runs at volume. Platform coverage →

Setup steps

1
Check the dates sheet each morning

Configure this step using the field mapping in the blueprint.

2
Find anyone with a date today

Configure this step using the field mapping in the blueprint.

3
Draft or send the message

Configure this step using the field mapping in the blueprint.

4
Notify yourself to add a personal line

Configure this step using the field mapping in the blueprint.

Implementation notes

  • Draft rather than send. An entirely automated anniversary note is worse than none, because clients can tell.
  • Keep renewal dates in the same sheet — the same workflow then warns you 30 days before a contract ends.
  • A single sheet with Client, Email, Date, Occasion and Detail is all the infrastructure this needs.