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.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/246edf78-001d-43fd-bc76-a08702b05805.png)