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

Look at the same place and repeat a step until this value change

  • 22 March 2021
  • 4 replies
  • 263 views
L

IMPORTANT

Approval by Zapier will be discontinued on February 28, 2023. If you’re using Approval by Zapier, you can still create approval steps in your Zaps using Zapier Tables and Zapier Interfaces. Request access to both apps through our Early Access Program.

Hi everyone!

Context

I’m a teacher of a course and I offer mentoring to my students.
I would like to automate the scheduling process (it will be at Calendly).

Process

Today students complete a submission form.

But, I would like to take the time to review each submission before authorizing the automation to continue.

Scenarios

This automation can have three scenarios:

  • ✅ = Approved
  • 🚫 = Refused
  • Waiting = I didn't have time to review

Help!

I would like to create a zap that:

  • Look daily, from time to time, for a value in a specific field in a Sheets
  • If this value remains the same (eg: Waiting), repeat until this value changes to "Approved" or "Declined"

How could I create this automation? Please help me.

I don’t now how to look in a specific place to watch if the value has changed and keep looping until the value changes.

icon

Best answer by Jhealyn Samson 22 March 2021, 05:34

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @lbrezende 

Check out the Approval app: https://zapier.com/apps/approval/integrations

AND

Consider using this trigger: GSheets - New/Updated Row

Then follow that with a Filter step to make sure the desired column value has changed (aka is NOT “Waiting”).

 

You may also want to consider using Airtable instead of GSheets: https://zapier.com/apps/airtable/integrations#triggers-and-actions

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Jhealyn Samson
Userlevel 1

@lbrezende 

Sems to me like you'll need to build 2 zaps. 

 

1st zap to fill up a Gsheet or airtable where it will show you that someone had answered the form and another column where it has the status (Waiting, rejected or accepted) 

 

The 2nd zap can be a trigger when a new row is updated (status is changed from rejected or accepted). 

Make sure that the second step after the trigger is a filter step. If it's Waiting, don't proceed. You only need this because whenever the 1st zap runs and a new row gets added it'll be set to waiting, and this will trigger your 2nd zap. 

 

Then in your 2nd zap you can add paths that will handle Rejected forms (maybe send them an email?) and Approved forms. 

 

Let me know if you get stuck anywhere else. 

L

@Jhealyn Samson — you really saved the day!

Thank you SO much! I’ve already tested and will be going to follow this path.

 

@Troy Tessalone — I loved your answer too, but I’m still don’t totally understood the Approval app. Have you some examples to illustrate?

May I use this alternative in the future to improve the automation if I see that could work better :)

nicksimard
Userlevel 7
Badge +11

Hi @lbrezende!

We have a series of articles here called Workflow Wednesday and my colleague thought your use case would make a great one, so I wrote Manually approve form submissions with Approval by Zapier.

It may not be 100% what you would want to do (there’s no “waiting” status built into this, for example) but it should give you a good idea of how Approval by Zapier could work as a “person in the loop” step in your Zap :)

 

Terms & Conditions