Send email on specific date in Google Sheets

  • 8 February 2022
  • 2 replies


I have this huge google sheet with hundreds of entries and I’d like to send me an email / slack notification when TODAY is the date in the cell.

Seems simple, tried a few things but couldnt manage to get it working except looking manually at every row..


On the example below, I’m expecting to receive 3 emails on the 2022-02-08 


Thanks for your help




Edit :
Seems to work by using like below : 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +12


Glad you’ve figured out a solution!

The only other way i’ve seen this done without getting too custom is to add a column for today’s date on each row using something like =today() then you can have zapier trigger when that column changes each day. 

Follow it up with a filter to only continue if today’s date matches the date value in the row but i think i like your solution more! 

Userlevel 7
Badge +14

Hi @Zjeed 

Alternative is to use Airtable instead of GSheets:

Airtable has Views.

Views have Filters. (e.g. Date = Today)

Views can be used to trigger Zaps.

This would use less Zap Tasks as well.



  1. Trigger: Airtable - New Record (in View)
  2. Action: Slack - Send Channel Message




NOTE: There are limitations with the GSheets Find Rows actions, which has a limit of 10 results MAX.