Coding · Automation

Send Automatic Email Reminders From Google Sheets

Get a small Apps Script that emails reminders based on dates in your sheet, with setup steps.

Prompt Code output

I have a Google Sheet with these columns: [SHEET_COLUMNS]. I want an email reminder sent automatically when [REMINDER_RULE]. The email should say something like: [EMAIL_TEXT]. Please write a Google Apps Script that does this. Explain how to open the script editor from my sheet, where to paste the code, how to run it once to test, and what the permission screens mean when Google asks me to allow access. Show me how to set it to run every day on a timer. Add a column that marks a row as already reminded so nobody gets the same email twice. Tell me to try it first on a copy of the sheet using my own email address as the recipient.

Fill in the brackets

[SHEET_COLUMNS]
e.g. A = client name, B = email, C = appointment date, D = status
[REMINDER_RULE]
e.g. the appointment date is tomorrow and status is not Cancelled
[EMAIL_TEXT]
e.g. Hello {name}, a reminder of your appointment tomorrow at our clinic.

How to use

  1. Copy the prompt.
  2. Replace the text inside [BRACKETS] with your own details.
  3. Paste it into ChatGPT or another AI assistant.
  4. Read the result and ask for changes if needed.

Tip: Run the test on a copy with your own email in every row, then switch to the real sheet once it works.