Skip to main content

Hello World!

Do you know how to make a Zap wich sends email when the day in Google Sheets row has come?

For example: I have a table with columns: Agent, Contract № and Date of the end of the Contract (DOEC).

How do I make it zap to compare the current date and the date from the DOEC field and if the date comes send an email to me?

Is there any ways to do that?

Formula: =IF([cell]=TODAY(),TRUE,FALSE)

Replace [cell] if the cell to reference that has the DOEC.

Then the Zap trigger should be GSheets New/Updated Row with a filter step that checks the column value is TRUE.


Formula: =IF([cell]=TODAY(),TRUE,FALSE)

Replace [cell] if the cell to reference that has the DOEC.

Then the Zap trigger should be GSheets New/Updated Row with a filter step that checks the column value is TRUE.

 

Thank you very much!

But...

Something goes wrong...

 


OK, I’ve got that. The clue is “”.

That’s the right format:

=IF("


But it doesn’t check the date in the table and doesn’t work any way.

Any ideas?

Please!


@Troy Tessalone - Making sure you saw this since you provided the original solution. Thanks!