Describe the problem/error/question
I have an n8n-hosted instance with a Google Sheets node in a workflow, and when the ‘Get Row(s)’ node ran, it intermittently showed some cells [empty] when they had values. It only skipped that one column in the row, so all other data was transferred.
What is the error message (if any)?
None shown
Please share your workflow
{
“nodes”: [
{
“parameters”: {
“documentId”: {
“__rl”: true,
“value”: “1w38tAHNj8fJFncSEoNHp6LCP0XHh-IbohFlAUgnsNMs”,
“mode”: “id”
},
“sheetName”: {
“__rl”: true,
“value”: “gid=0”,
“mode”: “list”,
“cachedResultName”: “Listings”,
“cachedResultUrl”: “vn8n Pro Community: Businesses for Sale - Updated Daily - Google Sheets”
},
“options”: {}
},
“id”: “2f9a3f73-17d8-4ad2-8465-9e4b5f79d021”,
“name”: “Read Source Sheet”,
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4,
“position”: [
-672,
112
],
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “Sinku9dmmcD6x4Fp”,
“name”: “Google Sheets account”
}
}
}
],
“connections”: {
“Read Source Sheet”: {
“main”: [
]
}
},
“pinData”: {},
“meta”: {
“instanceId”: “a952b8ea064519bc44a9f00710de83438ffdcc88c20ce4463c6063bbff2d122b”
}
}
Share the output returned by the last node
[empty] for some values that are present, but correctly returned most values in the same row and column
Information on your n8n setup
-
**n8n version:**1.102.3
-
**Database (default: SQLite): default
-
**n8n EXECUTIONS_PROCESS setting main
-
**Running n8n via n8n cloud
-
**Operating system: macOS