Describe the problem/error/question
Automatic executions do not work if there is a Google Sheets node present anywhere in the canvas (even deactivated and not in the workflow). The same workflow will work if it is run manually or the Google sheet node is removed.
I have tried using different Google creds and the same thing happens.
This is really strange behaviour that I think must be a bug.
What is the error message (if any)?
Problem executing workflow
There was a problem executing the workflow.
Error: Cannot read properties of undefined (reading ‘execute’)
Please share your workflow
{
“nodes”: [
{
“parameters”: {
“rule”: {
“interval”: [
{
“field”: “seconds”,
“secondsInterval”: 5
}
]
}
},
“type”: “n8n-nodes-base.scheduleTrigger”,
“typeVersion”: 1.2,
“position”: [
112,
-96
],
“id”: “730cde10-3d1c-4d71-87f6-96cf5f84d8d2”,
“name”: “Schedule Trigger”
},
{
“parameters”: {
“authentication”: “serviceAccount”,
“operation”: “update”,
“documentId”: {
“__rl”: true,
“value”: “1MNRwf6stCoXB6AVC0G_WlDDm5PV8CjTdsYKnyXXvRP4”,
“mode”: “id”
},
“sheetName”: {
“__rl”: true,
“value”: “Sheet1”,
“mode”: “name”
},
“columns”: {
“mappingMode”: “defineBelow”,
“value”: {
“Test”: “ABC”,
“row_number”: 1
},
“matchingColumns”: [
“row_number”
],
“schema”: [
{
“id”: “Test”,
“displayName”: “Test”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “row_number”,
“displayName”: “row_number”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “number”,
“canBeUsedToMatch”: true,
“readOnly”: true,
“removed”: false
}
],
“attemptToConvertTypes”: false,
“convertFieldsToString”: false
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.7,
“position”: [
320,
32
],
“id”: “9361e534-3e97-45de-be0b-7249a4d78c4e”,
“name”: “Update row in sheet”,
“credentials”: {
“googleApi”: {
“id”: “MrmhZ3B4GR4rJ4De”,
“name”: “Google Service Account - Engineering”
}
},
“disabled”: true
}
],
“connections”: {
“Schedule Trigger”: {
“main”: [
]
}
},
“pinData”: {},
“meta”: {
“instanceId”: “339aea9d3f6415787ccca0c4ffdede8a055747ce4830d35b54e03fdc9f0d0706”
}
}
Share the output returned by the last node
NA - there is no data in the execution
Information on your n8n setup
- n8n version: 1.107.4
- Database (default: SQLite): Default
- n8n EXECUTIONS_PROCESS setting (default: own, main): default
- Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
- Operating system: mac
( </> button)