Describe the problem/error/question
When trying to use the Excel 365 Append to Sheet node I am getting an error no matter how I try to define the node settings. The error message is “Cannot read properties of undefined (reading ‘match’)”
What is the error message (if any)?
{
“errorMessage”: “Cannot read properties of undefined (reading ‘match’)”,
“errorDetails”: {},
“n8nDetails”: {
“n8nVersion”: “1.97.1 (Self Hosted)”,
“binaryDataMode”: “filesystem”,
“stackTrace”: [
“TypeError: Cannot read properties of undefined (reading ‘match’)”,
" at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@[email protected]_asn1.js@5_12b981d6b49d407a163f4d5244314033/node_modules/n8n-nodes-base/nodes/Microsoft/Excel/v2/actions/worksheet/append.operation.ts:213:29)“,
" at processTicksAndRejections (node:internal/process/task_queues:95:5)”,
" at ExecuteContext.router (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@[email protected]_asn1.js@5_12b981d6b49d407a163f4d5244314033/node_modules/n8n-nodes-base/nodes/Microsoft/Excel/v2/actions/router.ts:29:17)“,
" at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@[email protected]_asn1.js@5_12b981d6b49d407a163f4d5244314033/node_modules/n8n-nodes-base/nodes/Microsoft/Excel/v2/MicrosoftExcelV2.node.ts:26:10)”,
" at WorkflowExecute.runNode (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@[email protected][email protected][email protected]_/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:1185:9)“,
" at /usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@[email protected][email protected][email protected]_/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:1534:27”,
" at /usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@[email protected][email protected][email protected]_/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:2098:11"
]
}
}
Please share your workflow
{
“nodes”: [
{
“parameters”: {},
“type”: “n8n-nodes-base.manualTrigger”,
“typeVersion”: 1,
“position”: [
0,
0
],
“id”: “934358ed-a83c-4952-9312-8de4c2f31d77”,
“name”: “When clicking ‘Execute workflow’”
},
{
“parameters”: {
“assignments”: {
“assignments”: [
{
“id”: “b85015da-fdc1-40d5-aa07-8054d75b426a”,
“name”: “TestField1”,
“value”: “Testing”,
“type”: “string”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.set”,
“typeVersion”: 3.4,
“position”: [
220,
0
],
“id”: “81068d9b-456e-4142-92f8-645811fcf0cd”,
“name”: “Edit Fields”
},
{
“parameters”: {
“resource”: “worksheet”,
“operation”: “append”,
“workbook”: {
“__rl”: true,
“value”: “01MXVZWQASTPNZQB4PXRFLAPNHAGUCJTNT”,
“mode”: “list”,
“cachedResultName”: “n8n”,
“cachedResultUrl”: “zzz”
},
“worksheet”: {
“__rl”: true,
“value”: “{D8B2ECE7-4260-F049-BC3F-D4B3F35596ED}”,
“mode”: “list”,
“cachedResultName”: “Sheet1”,
“cachedResultUrl”: “zzz”
},
“dataMode”: “raw”,
“data”: “={{ [$json] }}”,
“options”: {
“rawData”: false
}
},
“type”: “n8n-nodes-base.microsoftExcel”,
“typeVersion”: 2.1,
“position”: [
440,
0
],
“id”: “08c16ae8-c44f-48ce-a039-e3163a790964”,
“name”: “Microsoft Excel 365”,
“credentials”: {
“microsoftExcelOAuth2Api”: {
“id”: “zzz”,
“name”: “Microsoft Excel account”
}
}
}
],
“connections”: {
“When clicking ‘Execute workflow’”: {
“main”: [
[
{
“node”: “Edit Fields”,
“type”: “main”,
“index”: 0
}
]
]
},
“Edit Fields”: {
“main”: [
[
{
“node”: “Microsoft Excel 365”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “558”
}
}
Share the output returned by the last node
last node returns error
Information on your n8n setup
- **n8n version: 1.97.1
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- **Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
- Operating system: