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

How do I trigger on an update from a specific cell in my Google Sheet?

  • 16 April 2022
  • 7 replies
  • 1436 views
T

Hi! 

I am trying to trigger a zapier response when a specific value changes in my existing Google Sheets workbook. 

I am setting up the zapier using the “ New or Updated Spreadsheet Row in Google Sheets”. I have removed all blank columns in my workbook (is this neccessary ?) and have only 3 columns. When I select the 3rd column from the “Trigger Column” it seems to only select the last row when I do the “test trigger’ 

I am trying to set up the zap filter as the 2nd step, to say only when data in that 3rd column AND the 3rd row (which I am using ROW ID 3) changes… then trigger a response do something. But it keeps saying there is no 3rd row. Appreciate any help! As you can see for the screen shot it seems to default the row ID to the last row only. I am unable to select specific cells with the row ID

icon

Best answer by jesse 22 April 2022, 19:17

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

7 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @TL505 

Good question.

The Zap trigger for GSheets will pull back test data for the 3 highest row IDs.

Try turning the Zap ON and testing, then check your Zap Runs: https://zapier.com/app/history/

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

Thanks @Troy Tessalone! So to confirm the maximum number of zaps from a sheet like this can be 3, and they would have to be the highest row IDs? 

Troy Tessalone
Userlevel 7
Badge +14

@TL505 

Zap triggers return from 1-3 of the most recent data samples (or dummy data) to use to test and configure.

In the case of GSheets, it will pull back rows with data starting at the bottom of the GSheet.

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

@Troy Tessalone got it! So if I wanted it to trigger from a piece of data from the middle of the spreadsheet am I able to do that - it just won’t show up with the test triggers. Or that wouldn’t be possible?

Troy Tessalone
Userlevel 7
Badge +14

@TL505 

Correct.

You can either remove the other rows of data, then refresh the Zap trigger to get new test data, then add that data back.

Help article about to change the trigger test data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger

OR

Configure the Zap, turn the Zap ON, test the Zap, check your Zap Runs to see the DATA IN/OUT for each Zap step to make sure the Filter conditions are working as expected: https://zapier.com/app/history/

 

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

Got it to work, I now I see you can’t just “test’ it with the triggers. 

Appreciate the help Troy!

jesse
Userlevel 7
Badge +9

Really glad to see you have this working now, @TL505! I am going to summarize Troy’s posts into a single answer here for anyone following along:

 

The Zap trigger for GSheets will return from 1-3 of the most recent data samples (or dummy data) to use to test and configure. The data that is pulled starts at the bottom of the sheet, which is why you might not be finding rows that exist in other positions within your sheet.

If you’d like them to appear in the test data, you’ll either need to:

  1. Remove the other rows of data, then refresh the Zap trigger to get new test data (You can add the other rows back later on). Here is a help article about to change the trigger test data. OR
  2. Finish configuring the Zap, turn it ON, test the Zap by adding a new row or updating an existing row. You can then check your Zap Runs to see the DATA IN/OUT for each Zap step to make everything is working as expected: https://zapier.com/app/history/
Terms & Conditions