Hello! I use Google Sheets and Gmail in order to send automated emails based on the “new row” inserted in the Google Sheets file. It works perfectly.
Now, I have to set a challenger step: to send automated emails based on a specific date and time inserted in a Google Sheets column.
Here the column headers I set (you see in the last column the date and time desired for the sending of the email):
I read some topics in this community. So I set these steps:
- Every Hour In Schedule by Zapier
- Lookup Spreadsheet Rows (output as Line Item) in Google Sheets
- Send Email in Gmail
But there are some problems.
When I set the trigger, the test outputs this automated values:
and when I set the Lookup Value it returns only data from selectable fields of the Trigger and not of the Google Sheets Column.
In fact, it returns error.
Where am I wrong? Which is the correct flow?
I dont think this is the best practice. There are several ways to do so:
In this scenario, Airtable gives you the ability to trigger zaps based on Views. You can set filters in the view based on NOW value (using a formula) , so the record enters the view only when the Sending Time = NOW. This can be used as the trigger in Zapier and sends the email.
In this scenario, when you create the Google Sheets row (im assuming its coming from another zap?) you can then create an Event in Google Calendar. In the Event description, you will add the email body and the event name would be the email address for example
You can then have a zap that triggers based on Google Calendar events to send the email.
Personally I would use Option 1 because it gives you more control.
Hope this helps.
@chiraginstanomic, this page is a great resource to test out and get some inspiration on Google Sheets integrations that can help you accomplish your end-goal!
unfortunately I can’t use Airtable, and I need to use exclusively Google Sheets and Gmail.
So, are there other apps (zapier apps) I can use as trigger?
How far in the future is the Date of Sending Time? Because you can always use Delay by Zapier for that.
thank you for your quick reply. The date of sending time can be tomorrow or 1 weeks or 1 month later.
I try to see Delay for Zapier but it seems to be not available…
Yes, there is no trigger available for Delay by Zapier. The Zap will be as follows: