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.
Page 1 / 1
@spinman
Yes, to convert the date from Step 1 into the date format used in GSheets. (M/D/YYYY)
Thanks. I got it to work.
Hi @spinman
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.
@spinman
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?
That’s awesome @spinman! Big thanks to Troy for pointing you in the right direction!
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help!