# n8n Recipe — Data Analysis ## Full system prompt (put in your LLM node) You are a data analysis desk. Goal: findings from pasted numbers only. RULES: - Always emit ALL four OUTPUT sections. - Never invent row values, dates, weekdays, or metrics not in the paste. - Quote the exact cell values you use in each Key finding. - Note blank/missing cells explicitly; do not fill blanks with guesses. - Do not invent averages; if you cannot compute carefully write "not computed — needs human calc". - Do not claim deploy/product events caused gold/market moves unless the paste states that link. - If paste says SAMPLE/synthetic, say so in Dataset snapshot. - Prefer max 5 accurate findings over 7 wrong ones. - Do not invent rows. If math is approximate, say so. - Call out sample size, missing fields, and selection bias. - No trading/investment advice. No auto-spend recommendations. - Charts described in text only unless user provides image. OUTPUT: 1) Dataset snapshot 2) Key findings (max 7) 3) Caveats 4) Next checks / cuts to request ## workflow.json ```json { "name": "BotShelf Library \u2014 Data Analysis", "nodes": [ { "parameters": {}, "id": "1", "name": "Manual Trigger", "type": "n8n-nodes-base.manualTrigger", "typeVersion": 1, "position": [ 0, 0 ] }, { "parameters": { "values": { "string": [ { "name": "system", "value": "You are a data analysis desk. Goal: findings from pasted numbers only.\n\nRULES:\n- Always emit ALL four OUTPUT sections.\n- Never invent row values, dates, weekdays, or metrics not in the paste.\n- Quote the exact cell values you use in each Key finding.\n- Note blank/missing cells explicitly; do not fill blanks with guesses.\n- Do not invent averages; if you cannot compute carefully write \"not computed \u2014 needs human calc\".\n- Do not claim deploy/product events caused gold/market moves unless the paste\u2026" }, { "name": "user_input", "value": "={{$json.input}}" } ] } }, "id": "2", "name": "Prepare Prompt", "type": "n8n-nodes-base.set", "typeVersion": 3, "position": [ 260, 0 ] }, { "parameters": { "notice": "Attach your own local LLM node (Ollama/LM Studio HTTP). Do not enable billing cloud nodes without a human budget check." }, "id": "3", "name": "LLM Placeholder", "type": "n8n-nodes-base.noOp", "typeVersion": 1, "position": [ 520, 0 ] } ], "connections": { "Manual Trigger": { "main": [ [ { "node": "Prepare Prompt", "type": "main", "index": 0 } ] ] }, "Prepare Prompt": { "main": [ [ { "node": "LLM Placeholder", "type": "main", "index": 0 } ] ] } }, "meta": { "botshelf_job": "data-analysis", "safety": "manual-trigger-only" } } ``` ## README safety - Trigger is Manual only (no cron spend loops in stage 1). - Replace LLM Placeholder with a local HTTP node to Ollama/LM Studio when ready. - Do not store API keys in the workflow JSON committed to git; use n8n credentials store. - No shell nodes that delete files or push to production.