I have a WooCommerce zapier that is creating a new row for every new order in GoogleSheets. That is great for my dashboard but I also need it to update the row status for canceled or completed when appropriate. So far I can test the step to find the update in WooCommerce, but when I test the step to locate the correct row in GoogleSheets I keep getting the error below:
Failed to create a spreadsheet row in Google Sheets
Cursor has gone out of bounds.
The troubleshooting is not helpful. I did find another similar posts and tried to follow the steps prescribed but still getting the same error.