How to set up a Zap to email reminders based on Google Sheet dates?

Hi ​@jstro,

Welcome to the Community.

To set up a Zap that sends an email reminder based on a Google Sheet date, first, use Google Sheets as the trigger with "New or Updated Spreadsheet Row." Then, add a "Delay Until" action using Zapier's Delay app, selecting the column with follow-up dates. Finally, an email action (Gmail or Outlook) should be set up to send a reminder at the specified time. Test the Zap and turn it on to activate the automation.

This helps you get started with Zapier. If you have any other questions or issues, please don't hesitate to ask!

Hi ​@jstro 

Try this instead…

Use Airtable.

Airtable has field types. (e.g. Date, Dropdown, Checkbox, etc.)

Airtable has native Automations that can be configured when fields meet conditions. (e.g. Date = Today)

Airtable Automations have a native integration with Gmail.

Help link for how to send an automated email: https://support.airtable.com/docs/send-an-email-action

Hey there, ​@jstro 👋

Just checking in to see how things went with Jammer and Troy’s suggestions—did they help point you in the right direction, or did you find a different solution?

Let us know if you need any further help! 🙂