I'm getting 'column "0" not found' when everything is just fine. I created a Read and Write Query at first sheet and Secondly, I created another one to append data in spreadsheet. All set and updated. When I run, It shows, 'column "0" not found'. expected column name to be one of 'rest of the column names' when all it just exist and all set already. Due to this, Can't add data and not updating on spreadsheet. Why this error keeps popping up. Help me out please.
Hey @JayVeni! Would you mind sharing a screenshot of your current query?
We've seen this error pop up when the values to append aren't formatted exactly how the query expects. It expects an array of objects, where each key in the object is a column and each value in the object is a single value!
