I have a zap set up so that when we receive a sales email from a particular customer, some of the details (including the product name) are posted in a slack channel. It would be great if I could set up an alert zap that is triggered when x amount of the same product are purchased within, say, a two minute timeframe. Is this possible in anyway?
Question
Is this possible? A zap that is triggered when the metadata of two or more zaps match within a specific timeframe?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Good question.
You’d first need to start logging this info using a database app such as Airtable: https://zapier.com/apps/airtable/integrations
Then from there you can work on configuring the desired logic to detect conditions being met to trigger another Zap.
+11- Community Manager
Hi there
Have you had a chance to try out Troy’s suggestion of adding the information into an app like Airtable yet?
Assuming you were to go down the Airtable route, it looks like it’s possible to use a DATETIME_DIFF() function in a Formula field to compare two dates and times together.
If you wanted to handle the date/time comparison in a Zap you could potentially use a Formatter step to compare the values. We have a related article and guide on comparing dates and times which you may find helpful:
What you would also need to factor in, is a way of checking whether the products that’s just been purchased matches one that was previously purchased. So you may need to use a search action to search the app you choose to store the purchase info in. Then the Zap would need to compare the date/times of the purchase and use a filter action to check it’s within 2 mins before sending out the alert.
Hope that helps, please do keep us in the loop on how you’re getting on with this. 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.