Hey - Big picture I am automating posting to instagram via Blotato. However, I want to analyse and put the statistics from Instagram i.e. Impressions, Likes, Comments, Shares, Saves etc, back into my Google Sheets.
It is posting correctly to Instagram, but I am having difficulty collecting the stats. AI suggests running a Code node between Posting Statistics and my Google Sheets to normalise the data, but it is having trouble guiding me on what code to input in there. Can anyone help or point me in the right direction?
Thanks!
If your question hasn’t been asked before, please follow the template below. Skip the questions that are not relevant to you. →
Describe the problem/error/question
What is the error message (if any)?
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.)
Share the output returned by the last node
Information on your n8n setup
- n8n version:
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app):
- Operating system:
see difficulty in error code in last node:
{
“errorMessage”: “Cannot read properties of undefined (reading ‘Row_ID’) [line 13]”,
“errorDescription”: “TypeError”,
“errorDetails”: {},
“n8nDetails”: {
“n8nVersion”: “1.116.0 (Cloud)”,
“binaryDataMode”: “filesystem”,
“stackTrace”: [
“TypeError: Cannot read properties of undefined (reading ‘Row_ID’)”,
" at VmCodeWrapper (evalmachine.:13:19)“,
" at evalmachine.:27:2”,
" at Script.runInContext (node:vm:149:12)“,
" at runInContext (node:vm:301:6)”,
" at result (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/@n8n+task-runner@file+packages+@n8n+task-runner_@[email protected]_@opentelemetry_5147392a3f2dab4b87aa45b14b25796a/node_modules/@n8n/task-runner/dist/js-task-runner/js-task-runner.js:176:61)“,
" at new Promise ()”,
" at JsTaskRunner.runForAllItems (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/@n8n+task-runner@file+packages+@n8n+task-runner_@[email protected]_@opentelemetry_5147392a3f2dab4b87aa45b14b25796a/node_modules/@n8n/task-runner/dist/js-task-runner/js-task-runner.js:169:34)“,
" at JsTaskRunner.executeTask (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/@n8n+task-runner@file+packages+@n8n+task-runner_@[email protected]_@opentelemetry_5147392a3f2dab4b87aa45b14b25796a/node_modules/@n8n/task-runner/dist/js-task-runner/js-task-runner.js:119:26)”,
" at process.processTicksAndRejections (node:internal/process/task_queues:105:5)“,
" at async Object.waitingForSettings (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/@n8n+task-runner@file+packages+@n8n+task-runner_@[email protected]_@opentelemetry_5147392a3f2dab4b87aa45b14b25796a/node_modules/@n8n/task-runner/dist/task-runner.js:256:17)”
]
}
}
Hi Teddy - currently Blotato does not have analytics or stats available for your posts. This is coming soon! Feel free to email me at help at blotato dot com to discuss further.
