About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Reverse Trigger

  • 14 April 2021
  • 2 replies
  • 126 views
P

Res.All

 I want something like Reverse trigger.. i.e. it will send an email only if a specific email is not received within specific time e.g. 15 minutes

The details are as follows

 I will setup my outlook to send an email every 15 minutes to Zappier. My outlook is flooded with VBA code. So if there is any mistake in the code it will hang and will fail to send the email to Zappier in time. So Zappier will be triggered if an email IS NOT RECEIVED FROM MY EMAIL ACCOUNT WITHIN STIPULATED TIME

 I hope you understand my problem.

Is it possible? How?

Thanks and regards

 

icon

Best answer by GetUWired 15 April 2021, 17:53

View original

2 replies

GetUWired
Userlevel 7
Badge +12

@prashantskin 

I believe this could be accomplished with no code in 2 Zaps. 

Zap 1: 
Trigger: New email received

Step 1: Create Row in Google Sheet (log in google sheet or some database what time the email came in)

Step 2: update last row with formulas to determine time since last email came in (time since previous row) More on this here: 


 *This step could be ommitted if using array formulas in Gsheets but in my experience that lags Gsheets so I tend to avoid it. 
 

Zap 2:

Trigger: New or Updated row in Google Sheets (specific column)

Action: Filter so only when trigger column equals “yes”

Action: Whatever your remaining actions are

It is not very task efficient but the above would solve your workflow, which is definitely bending Zapier to it’s max! 

Happy Zapping! 

Tim @ GetUWired

P

Thanks..I will try

Reply


Terms & Conditions