Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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

Triggering a Zap from a dropdown list in Google Sheets

L
Forum|alt.badge.img

Hi Zapier Community,

The context is that I have a dropdown list with 2 options that can be chosen from a dropdown list “Not Done”, “Done”. This is a list of projects that i have on hand which i would like to transfer the information to ClickUp. 

The idea here is that i would like the zap to trigger on a specific column that had its status change from “Not Done” to “Done” and trigger that rows project information to ClickUp.

My current zap uses the “New or Updated Spreedsheet Row” Trigger, only to continue if Status = “Done”. 

The problem is that im not able to get the zap to trigger using this method. I have been trying to find out what are the different ways to properly trigger a zap but im currently not able to find one. Is there any documentation/examples on this?

And how do i implement a solution/workaround to make this work for me?
Thank you

Best answer by LaksaBest answer by Laksa

Thanks both ​@Troy Tessalone ​@shane.massey 

I’ve managed to do it using the other trigger option “New or Updated Sheets in Team Drive”
Seems to be a viable option given my current structure

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@Laksa 

Issue could be related to how your GSheet is configured.

Post screenshots showing the top 3 rows of your GSheet.

 

Here’s an alternative, use Zapier Tables or Airtable instead of GSheets.

Those apps have better controls for triggering automations based on column conditions.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
L
Forum|alt.badge.img
  • LaksaBeginner
  • Author
  • Beginner
  • 3 replies
  • January 3, 2025

Hi Troy, thank you for your response. This is how the google sheets look like and I am using the last column on the right “Status” and toggling it between “Not Done” and “Done”.

Most of my records are on google sheet and moving to another app would not be possible at the moment unfortunately, thank you for the suggestion. Ultimately, we would have to resort to manual input of the data should it not be possible at the moment.

Troy Tessalone
Forum|alt.badge.img+14

​@Laksa 

NOTE: Using Zapier Tables in Zap steps count as 0 Tasks in Zap Runs.

 

From the screenshot we can’t see the row numbers or the column letters in the GSheet.

Help link with how GSheets need to be configured to work with Zaps: https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps

 

Help link for why Zaps using a GSheet trigger may not fire: https://help.zapier.com/hc/en-us/articles/29384048552205-Google-Sheets-error-Zap-not-triggering

 

Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
Forum|alt.badge.img+1

​@Laksa 

This is easily done with GoogleSheets, no workarounds required. Although there is some cool simple stuff once we sort this out for you. I set up the same zap (working) in 5 minutes, inculing 3 minutes to make the Googlesheet.

I would say you just have a technical problem here.

 

Can you confirm if the zap is not triggering, ie starting? or is it your filter not responding correctly to the data you receive?

I did notice you used the term Status = Done. For Strings you will want to use 

Status, Exactly Matches, Done 

 

Also note, Zapier can take up to 2 minutes to respond to the trigger even though it is “instant”.

 

L
Forum|alt.badge.img
  • LaksaBeginner
  • Author
  • Beginner
  • 3 replies
  • Answer
  • January 10, 2025

Thanks both ​@Troy Tessalone ​@shane.massey 

I’ve managed to do it using the other trigger option “New or Updated Sheets in Team Drive”
Seems to be a viable option given my current structure

 

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7472 replies
  • January 10, 2025

That’s great news, ​@Laksa! 🎉

Thanks so much for following up here to let us know that switching to the team drive version of the New or Updated Spreadsheet Row trigger did the trick. And thank you to ​@Troy Tessalone and ​@shane.massey as well for helping out here! 🤗

Sounds like you might be all set for now but please do get back in touch if you need any further help at all. Until then, happy Zapping! ⚡

Terms & Conditions