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.

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

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.

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.

​@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

Reply


Terms & Conditions