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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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.

Question

"New or Updated Spreadsheet Row" only triggers 50% of the time

  • 26 January 2022
  • 4 replies
  • 465 views
D

Hello,

 

it seems like I don’t understand quite correctly the nuances of the “1. New or Updated Spreadsheet Row in Google Sheets” trigger.

It seems like the it gets triggered only 50% of the time (not referring to the time it takes to trigger, but simply it does not get triggered at all).

Here’s what I’m looking to do :

  1. When col D gets set to “En Route”, apply timestamp on col E
  2. When col E gets set to “Arrived”, apply timestamp on col F

 

i have a path following the trigger : 

 

The trigger is set to a specific column, which is Status in this case.

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

Have you checked your Zap Runs to help troubleshoot if the Zap is triggering and if the Zap is being filtered or if there are errors/issues?https://zapier.com/app/history/

 

“New or Updated Spreadsheet Row” trigger behavior

If you’re using the New or Updated Spreadsheet Row trigger and choose Any column to monitor, any change to a row will trigger your Zap. If you select a specific column, then the Zap will only trigger when there are changes on that column.

 
Note

Zaps using New or Updated Spreadsheet Row will also trigger for any new rows in the spreadsheet, even if the specified column is blank. To avoid triggering in those cases, add a Filter step to your Zap.

 

The "Updated Spreadsheet Row" trigger stopped triggering

If you're watching for changes to a column, we only see new values in that column. If you update the column of an existing row to a value that Zapier previously saw in that column, in that row, we won't see the new value. You will need to either choose a column that will only have unique values, or make a new one which will.

For example, if you had X in the Trigger column, then changed it to Y, the Zap would trigger. If you then changed it back to X it would not trigger again, because the Zap has already seen X in that column.

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

Yeah, it does not trigger at all. My history looks like this : 

 

Referring to this here : The "Updated Spreadsheet Row" trigger stopped triggering

If my cell goes from Blank to En-Route to Arrived, I am not sure why some times it would trigger just for one of those two instances or non or both.

Troy Tessalone
Userlevel 7
Badge +14

@djudes

Try removing all the Zap Run filters to make sure you are looking at all the data:

 

Alternative is to use Airtable: https://zapier.com/apps/airtable/integrations

Airtable has Views.

Views have Filters.

Views can be used to trigger Zaps.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
jesse
Userlevel 7
Badge +9

@djudes I would second @Troy Tessalone’s recommendation of using Airtable and their “view” functionality. It makes things a lot easier when it comes to status changes triggering updates to your Zap(s) or even other areas of your table! 

Here is some additional info into this functionality if you’re interested! https://support.airtable.com/hc/en-us/articles/360042311914-What-is-a-view-

Terms & Conditions