Describe the problem/error/question
Hi everyone, i’m having a bug in google sheet trigger. It will check every minute for every row added or updated in this sheet: Japanese unit db - Google Sheets
I activated the workflow and tried make some changes to the sheet file.
When i added new value in column “id”:
The trigger node output correct row_number, change_type, and the row fields:
But when I add the value to the column “json” (which is a long json string), the trigger node will output this strange value:
Just the full JSON in plain text, no key at all, no row_number, change_type, id.
Weirder, in table or schema view of the output i can see the JSON is broken down, each character to a “column” in table or “keys” in schema:
What is the error message (if any)?
No error message
Any one know what’s going on in this node and how to fix it? If this is a bug, i hope I have suggested a new problem. Thank you!
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
Information on your n8n setup
- n8n version: 1.91.2
- Running n8n via (Docker, npm, n8n cloud, desktop app): docker
- Operating system: ubuntu