Question

Cursor has gone out of bounds Updating Google Sheet.

  • 3 January 2023
  • 2 replies
  • 816 views

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

Userlevel 7
Badge +14

Hi @seanmpiper 

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

 

 

 

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!