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:

NameEmailCourseExpiresRenewed
Ana Ruizana@example.comFirst aid2026-12-15
Ben Coleben@example.comForklift2027-01-09

Steps

  1. Choose Extensions > Due Date Reminders > Open reminders, then New reminder, and give it a Name like "Certification renewals".
  2. Under Your dates, pick the tab and set Date column to Expires.
  3. Under When to remind, tap 30 and 7 under Days before the date, and On the day.
  4. Set Skip rows that are done to Renewed is checked, so people who've renewed hear nothing more.
  5. 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.
  6. Keep Delivery on One email per row.
  7. 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.
  1. 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.
  2. 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:

PlaceholderBecomes
{{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