Im creating a zap that triggers from the “Schedule by Zapier” at 5am each day. From there I do a google sheet lookup in col A for the current days date. The date in the google sheet is formatted as the “Pretty Date”. Below are screen shots of the lookup fields in zapier.
Hi
Good question.
Make sure each GSheet column has a Header label.
Post screenshots with how your GSheet is configured to give us true context.
NOTE: The GSheet cell display value may be different from the GSheet cell internal value, which can be seen in the formula bar in GSheets.
This is the actual value in the cell.
For the Lookup Value, you can add this Zap action: Formatter > Date & Time > Format
so add a formatter step after the schedule by zapier step?
Yes, to convert the date from Step 1 into the date format used in GSheets. (M/D/YYYY)
Thanks. I got it to work.
That’s awesome
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.