I am creating a Zap that has two connects Google Sheets and Gmail.
The updates in the sheets are purchases from the customers, here one of the columns is the date of the purchase.
What I need to do is send an email after 14 days of this date but I can’t configure the filter for this.
Does anyone knows how can I do this?
+14
Hi
Good question.
Use Airtable instead of GSheets.
Airtable has a Formula field: https://support.airtable.com/docs/formula-field-reference
Airtable has Views, which are segments of data. (sort, filter, show/hide fields, reorder fields)
Airtable Views can be used to trigger Zaps.
Airtable has Automations.
Airtable Automations have a native integration with Gmail.
Hello
The problem is that every purchase the customer makes already creates a row in a Spreadsheet, that’s why I think I should use Google Sheets.
As far as I understand, all I need is a way to make Zapier recognize something like “{Todays date} - 14 days”.
+14
Maybe try this…
Again, if you were to use Airtable, then once the data is in Airtable, Airtable Automations could be used to send the Gmail.
I have these fields.
(Fecha = Purchase date)
If this doesn't work I might try the Airtable option you're saying. But I don't understand how this is causing me so much trouble.
+14
We’d need to see screenshots with how your Zap trigger step is configured.
The Filter step has no value set to compare against, which is why the warning is saying it won’t pass.
I did it! I didn’t notice but in Zapier there’s a step that it’s exactly for this. It’s called “Delay For”.
Thanks a lot for your help
+6
That’s great news
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
