https://www.gumloop.com/pipeline?workbook_id=4SS82XZa7NTv98Q1whjB8k&run_id=T75VSRHfZbVKGNnqSNFg2M
The node reports this error: Google Sheets Updater Failed!
No row found with Name = Alexandra Ebert. But I clearly check the sheet and there’s that value in the search column of that sheet.
At first, I thought the problem was due to the limit of how many rows can it be updated one time. My sheet has 4000 rows that need to be updated in a day. I have a custom script that dynamically determine which chunk of rows will be updated.
I thought the limit was 150 rows a run, I tried with the first chunk and it works (row 0 - row 150) but it didn’t work for the 2nd chunk (row 150 - row 300). Then I tried to decrease the chunk size to 100, and the same situation happens. Now, as I decrease the chunk size down to 30 rows per run, it does not seem to solve the issue.