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?
But it doesn’t check the date in the table and doesn’t work any way.
Any ideas?
Please!
OK, I’ve got that. The clue is “”.
That’s the right format:
=IF("
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...
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.