Describe the problem/error/question
This is my first automation in n8n but I have been using make.com for about a year. I am trying to take data from a folder listing page on the NM legislative website, parse the links, then split the pdf links from the html links. Once in html I need it to pull the data of the page, get rid of all the code and markup, then run it through open ai to get some info from it including a synopsis, then run the synopsis through google gemini to have it match to a list of my wifes client keywords. I have all of this working to here, maybe not correctly, but where I am getting stuck is trying to get the data into a google sheet. I am being met with undefined and node path errors like crazy. Thank you in advance for any help.
What is the error message (if any)?
Node path errors and undefined.
Please share your workflow
Share the output returned by the last node
{
“errorMessage”: “Info for expression missing from previous node”,
“errorDetails”: {},
“n8nDetails”: {
“itemIndex”: 0,
“runIndex”: 1,
“parameter”: “columns.value”,
“causeDetailed”: “Missing pairedItem data (node ‘Code Cleanup 1’ probably didn’t supply it)”,
“time”: “1/14/2025, 5:31:07 PM”,
“n8nVersion”: “1.73.1 (Self Hosted)”,
“binaryDataMode”: “default”,
“stackTrace”: [
“ExpressionError: Can’t get data for expression”,
" at createExpressionError (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/WorkflowDataProxy.js:484:20)“,
" at createMissingPairedItemError (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/WorkflowDataProxy.js:503:20)”,
" at getPairedItem (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/WorkflowDataProxy.js:570:27)“,
" at pairedItemMethod (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/WorkflowDataProxy.js:816:40)”,
" at Object.get (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/WorkflowDataProxy.js:819:40)“,
" at Proxy.eval (eval at getFunction (/usr/local/lib/node_modules/n8n/node_modules/@n8n/tournament/dist/FunctionEvaluator.js:14:22), :6:54)”,
" at FunctionEvaluator.evaluate (/usr/local/lib/node_modules/n8n/node_modules/@n8n/tournament/dist/FunctionEvaluator.js:20:19)“,
" at Tournament.execute (/usr/local/lib/node_modules/n8n/node_modules/@n8n/tournament/dist/index.js:43:31)”,
" at evaluateExpression (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/ExpressionEvaluatorProxy.js:123:16)“,
" at Expression.renderExpression (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Expression.js:238:70)”
]
}
}
Information on your n8n setup
- n8n version: Version 1.73.1
- Database (default: SQLite): SQLite
- n8n EXECUTIONS_PROCESS setting (default: own, main): main
- Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
- Operating system: CasaOS on Ubuntu