Question

Send email on specific date in Google Sheets

  • 8 February 2022
  • 2 replies
  • 1114 views

Hi,

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

@Zjeed 

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: https://zapier.com/apps/airtable/integrations#triggers-and-actions

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.

 

Steps

  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.