Best answer

How do I trigger an event based on a date/time listed in a Zapier Table?


I have a Zapier table that captures start date/times and end date/times that I would like to use to trigger various events.  What is the best way to setup this trigger using the data in this table?

Data sample from the table:

 

icon

Best answer by Troy Tessalone 9 June 2024, 02:15

View original

5 replies

Userlevel 7
Badge +14

Hi @LoftGolf 

Try these Zap steps:

  1. Trigger: Schedule
    1. https://zapier.com/apps/schedule/help
  2. Action: Zapier Tables - Find Records
    1. https://zapier.com/apps/zapier-tables/integrations#triggers-and-actions
  3. Action: Filter
    1. https://zapier.com/apps/filter/help
  4. Action: Looping
    1. https://zapier.com/apps/looping/help
  5. Action: [APP] - [EVENT]
    1. Up to you!

 

 

Thank you @Troy Tessalone, this will work in principle; however, I am needing to schedule something hourly at a minimum (probably should have mentioned that earlier). and see that the Schedule by Zapier only has monthly, weekly and daily increments.  Any suggestions aside from creating 24 separate zaps?

Userlevel 7
Badge +14

@LoftGolf 

Zap trigger: Schedule - Every Hour

 

@Troy Tessalone thank you.  Not sure how I missed that option in the drop-down list.

Userlevel 7
Badge +6

That’s awesome @LoftGolf! A huge 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! 🤗

Reply