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

Cursor has gone out of bounds Updating Google Sheet.

  • 3 January 2023
  • 2 replies
  • 791 views
S

Hello I am trying to create a Zap that will do the following. When we get a new Patron on Patreon they are added to a Google Sheet. Then once they cancel their pledge we update the sheet COL of active to NO. I am able to get the first part of this working just fine. But I am having issues on the update column portion. 


  1. I am able to setup the lookup step just fine and all the data is visible.
 


 

  1. Next step I use the ID value that’s looked up in the spreadsheet from the previous step.
     



    Then I update the sheet with all of the same data except I change the Active column to NO. 

     

     

  2. This is where the issue comes in, when I run the test it comes back with Cursor Out Of Bounds. I am not sure how to resolve this. Any insight would be great.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @seanmpiper 

Looks like you may have Col J mapped but instead should map the Row Number or Row ID.

 

 

 

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

Hey there @seanmpiper! It looks as though Troy may well have spotted the cause of the issue here.

Were you able to get it working by selecting the spreadsheet Row ID or Row Number instead? Eager to know how you got on with this!

Terms & Conditions