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):
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/747456de-7ee3-4fa9-8275-f1fbcd45bfbc.jpg)
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
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/5204bf6b-1ee2-4cf0-8f66-4b7f6db7142b.jpg)
But there are some problems.
When I set the trigger, the test outputs this automated values:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/2cf00d47-b242-494d-8ffb-8139bf5ee19f.jpg)
and when I set the Lookup Value it returns only data from selectable fields of the Trigger and not of the Google Sheets Column.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/c5db8ea1-88ff-4246-a741-bfa73672b4af.jpg)
In fact, it returns error.
Where am I wrong? Which is the correct flow?