How to send each person in a Google Sheet their own reminder email
By Jake Marsh · Updated
To send each person in a Google Sheet their own reminder, add a column with their email address, open Extensions > Due Date Reminders > Open reminders, click New reminder and choose that column under Plus each row's own address in column. Write the message with placeholders such as {{Name}} and {{date}}, pick how many days before the date to send, and click Turn it on. Each person gets an email about their own row only, on their own schedule.
Set up the sheet
One row per person or item, with a header row. For example, a training tracker:
| Name | Course | Expires | Renewed | |
|---|---|---|---|---|
| Ana Ruiz | ana@example.com | First aid | 2026-12-15 | |
| Ben Cole | ben@example.com | Forklift | 2027-01-09 |
Steps
- Choose Extensions > Due Date Reminders > Open reminders, then New reminder, and give it a Name like "Certification renewals".
- Under Your dates, pick the tab and set Date column to Expires.
- Under When to remind, tap 30 and 7 under Days before the date, and On the day.
- Set Skip rows that are done to Renewed is checked, so people who've renewed hear nothing more.
- Under Who gets them, set Plus each row's own address in column to Email. Add your own address in Email addresses or tick Send me a copy if you want to see every reminder too.
- Keep Delivery on One email per row.
- Write the subject and message with placeholders, for example:
Subject: Your {{Course}} certificate expires {{days}}
Hi {{Name}},
Your {{Course}} certificate expires on {{date}}. Please book a renewal and tell us when it's done.
- Click Preview next 30 days. You see every email that would go out, to whom and when, plus a full sample. Then Send test to me.
- Tick the box confirming the recipients and click Turn it on.
For Ana, 30 days before December 15 the subject reads "Your First aid certificate expires in 30 days".
When one person has several rows
If a person appears on many rows, such as a manager with ten items due, switch Delivery to One combined email per person per day. They get one email listing each row, using the Line for each row in combined emails and summaries template, for example {{Course}} for {{Name}}: {{date}}.
Placeholders you can use
Any column header in double braces, plus:
| Placeholder | Becomes |
|---|---|
{{date}} | The row's date, such as Tue, Dec 15, 2026 |
{{days}} | in 7 days, tomorrow, today or 3 days ago |
{{when}} | Which reminder this is, such as 7 days before |
{{link}} | A link that opens the spreadsheet at this row |
{{row}}, {{sheet}}, {{spreadsheet}} | The row number, tab name and file name |
Every email's footer says who set the reminder up and how to stop it.
What it costs
The free trial covers 50 notices or 14 days, whichever comes first; each row reminded is one notice, and tests and previews are free. Then $4.99 a month or $39 a year. Install from the Due Date Reminders page.
Due Date Reminders
Email and chat reminders before the dates in your Google Sheet, even with the sheet closed $4.99 a month or $39 a year per Google account.
Questions
Do recipients need access to the spreadsheet?
No. They get the email with the details you put in the message. The {{link}} placeholder only works for people the sheet is shared with.
Whose address do the emails come from?
Yours, the person who turned the reminder on. You can set a Sender name and a Reply-to address.
What if a row has no email address?
The row shows up as a warning in Preview and on the reminder's card, so you can fill it in.
Can I CC a manager on every email?
Yes. Addresses in Email addresses get every row's reminder along with the row's own address.
More Due Date Reminders guides
More Google guides
- How to combine text from two or more columns in Google Sheets (Cellwell)
- How to match addresses in two lists in Google Sheets (Fuzzwell)
- How to import JSON into Google Sheets (Cellfetch)
- How to calculate driving distance in Google Sheets (Geocode & Map Addresses)