I need help with updating my Google Sheets through Zapier automation. Right now I can update specific rows by searching for a fixed text value, but I want to make this work with dates that change every day.
Current setup:
My automation looks for “Last 7 Days” in the Summary column and updates that row successfully.
What I’m trying to achieve:
Instead of searching for static text, I want to search for dynamic date formats like “Monday, August 15, 2022” in the Summary column. Each day the automation should find and update the row with today’s date.
The goal is to have daily updates where each row in my Summary column gets refreshed based on the current date. Has anyone figured out how to pass dynamic date values as lookup criteria in Zapier’s Google Sheets actions?
I hit this same issue a few months ago with a daily reporting workflow. Skip the separate date formatting - just use Zapier’s date functions right in the lookup step. In your Google Sheets “Update Spreadsheet Row” action, set Summary as your lookup column and drop {{zap_meta_human_now:EEEE, MMMM d, yyyy}} straight into the lookup value field. That’ll match your “Monday, August 15, 2022” format and auto-generate today’s date every time the zap runs. Just make sure all your Summary column dates use the same format or the lookup will break.
use zapier’s date formatter first, then send that to your lookup step. i had the same problem - fixed it by adding a “formatter by zapier” action before updating the sheet. just make sure it matches your summary column’s date format exactly.
Dynamic date lookup works great, but timing’s tricky depending on when your automation runs. I learned this the hard way - my zap ran at midnight and sometimes grabbed yesterday’s date because of timezone differences. Check your timezone settings in both Zapier and Google Sheets. They’ve got to match or you’ll get lookup failures. I created a test version first with a shorter date range to verify the format worked before doing daily updates. Still having issues? Try adding a delay step for a few minutes after midnight so the date calculation stays stable.