Skip to main content
Question

Trigger Zap if date = today


I have a spreadsheet with multiple rows of data. One column is dates. I want Zapier to check daily and do an action if a date = today. Is this possible?

Did this topic help you find an answer to your question?

5 replies

  • Zapier Staff
  • 38 replies
  • January 23, 2025

Hey ​@BPHC, welcome to the Community! 👋

If you want to build Zaps that run on a schedule, like once a day, you can use the Schedule by Zapier app as the trigger. Then you can add a Lookup Spreadsheet Rows step in Google Sheets, and use the date returned by the Schedule trigger as the lookup value.

Please note that the lookup can only return up to 500 rows per search.

I hope that helps! Let me know if you have any other questions.


Troy Tessalone
Forum|alt.badge.img+14

Hi ​@BPHC 

Here are other approaches:


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7396 replies
  • January 27, 2025

Hi there, ​@BPHC 👋

Just checking in to see how you’re getting on—did Marge’s or Troy’s ideas help to point you in the right direction?

Want to make sure you’re all set here so let us know if there’s anything else we can do to help!


  • Author
  • Beginner
  • 1 reply
  • January 28, 2025
Marge wrote:

Hey ​@BPHC, welcome to the Community! 👋

If you want to build Zaps that run on a schedule, like once a day, you can use the Schedule by Zapier app as the trigger. Then you can add a Lookup Spreadsheet Rows step in Google Sheets, and use the date returned by the Schedule trigger as the lookup value.

Please note that the lookup can only return up to 500 rows per search.

I hope that helps! Let me know if you have any other questions.

Hi ​@Marge thank you so much for your response. I’ve been trying to do what you suggested but keep running into issues with “Failed to find a spreadsheet rows in Google Sheets”

Would you be available to privately walk me through this? I’d be happy to tip you for your time.

Thank you


  • Zapier Staff
  • 38 replies
  • January 29, 2025

Hi ​@BPHC!

Don’t worry about it! I am more than happy to continue assisting you over this thread 😄

The error message indicates that there were no matching rows found in Google Sheets based on the lookup value. Could you share a screenshot of the Lookup Spreadsheet Rows step configuration? Make sure to blur out any sensitive information before sending it over.

Additionally, are the dates in the worksheet in the same format as the lookup value in the Zap?

Once we can refine those details, the Zap will be up and running!

I’ll keep an eye out for your response.