How to modify Google Sheets rows with changing values in Zapier

Other Questions Zapier
1

I need help with updating Google Sheets through Zapier using different lookup values each time. Right now, I can update a specific row by searching for a fixed text, but I want to make this process work with dates that change automatically.

Currently working method:

  • Column name: Summary
  • Search value: ‘Previous Week’

Desired approach:

  • Column name: Summary
  • Search value: ‘Monday, August 15, 2022’ (changes daily)

I want the automation to find and update rows based on the current date format. Each day should create or update entries with that specific date in the Summary column. What’s the best way to set this up in Zapier so it works with dynamic date values?

2

totally agree, the date formatter in zapier is so useful! I was stuck too, but once I set it up, it worked like a charm. just make sure to match the format in your google sheets and it should find the rows without any hassle.

3

Add a Formatter by Zapier step before your Google Sheets action. Set it to Date/Time formatter and convert the current date to your format (“EEEE, MMMM d, yyyy” gives you Monday, August 15, 2022). Then use that formatter’s output as your search value in Google Sheets instead of static text. Your automation will generate the right date string every time it runs. I’ve used this for similar workflows and it works perfectly. Just make sure your Google Sheets column has dates in the exact same format or the lookup won’t work.

4

I’ve had better luck using a calculated value step instead of the formatter. Just create a custom date string with Zapier’s built-in date functions - grab the current timestamp and format it exactly how you need it. Pro tip: test your date format in a separate zap first to make sure it matches your Google Sheets perfectly. Tiny differences like AM/PM or timezone will break the lookup (learned this the hard way). Once your dynamic date works, add a fallback action that creates a new row if the search comes up empty. Your automation will handle both updating existing entries and creating new ones without missing a beat.