Best answer

How to send e-mail when the date has come from the data in Google Sheets Row?

  • 23 September 2020
  • 5 replies
  • 709 views

Userlevel 2

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?

icon

Best answer by Troy Tessalone 23 September 2020, 16:34

View original

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

5 replies

Userlevel 7
Badge +14

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.

Userlevel 2

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...

 

Userlevel 2

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

That’s the right format:

=IF("[CELL]"="TODAY()","TRUE","FALSE")

Userlevel 2

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

Any ideas?

Please!

Userlevel 7
Badge +8

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