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.
-
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.
- 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.
