I just tested and found that if you have a colon in the sheet name, you can only update one cell. If you try to update multiple cells, you’ll get that error.
If you try to update multiple cells and remove the colon from the sheet name, it should update properly.
After some more research it appears this is actually a known bug in Google Sheets, and it doesn’t look like they’re going to fix it anytime soon. Best to just remove that colon or use one of the other workarounds.
I’ve not run into this error before, but after a quick Google search I came across some posts that indicate you may have a character encoding issue, specifically the colon symbol in the name of the sheet. It may not like “INPUT: Topics”. Can you try change it to something like “INPUT- Topics” ? This might be the quickest and easiest fix.
If you install the Integromat Dev Tool, it will allow you to see the exact API call(s) that module is using to complete your request. The error may become apparent after examining the request URL and body.
I just tested and found that if you have a colon in the sheet name, you can only update one cell.
If you try to update multiple cells, you’ll get that error.
If you try to update multiple cells and remove the colon from the sheet name, it should update properly.
After some more research it appears this is actually a known bug in Google Sheets, and it doesn’t look like they’re going to fix it anytime soon. Best to just remove that colon or use one of the other workarounds.
Just tested some more and found that if you can figure out a reliable way (for your situation) to determine the next usable row, you can use Google Sheets Update a Row on that row and it will accept the colon in the sheet name.
If you’re adding multiple rows, start with the first usable and increment by 1 for each row update.
Here’s one way to get the last used column, just tweak it to get the last used row.
