{ "edges": [ { "to": "289a652b-ba27-4d5e-963d-a1bca7fb4380", "from": "854eb94c-dfb8-4619-9751-c7f107157606", "toPort": "0", "fromPort": "0" }, { "to": "aeea1ae9-28f7-4e07-b4a3-eeab52888e96", "from": "688ca90b-8d7c-4baf-9a85-3647c8be1cd5", "toPort": "0", "fromPort": "0" }, { "to": "60d086ed-d2d1-4789-9727-8ccc3984550c", "from": "b8ee7fdb-5084-4014-906a-d1f5e24cb3e0", "toPort": "0", "fromPort": "0" }, { "to": "59158f78-222c-4c3c-9d32-90ad90be2ac7", "from": "aeea1ae9-28f7-4e07-b4a3-eeab52888e96", "toPort": "0", "fromPort": "0" }, { "to": "8a3f8345-f5a3-44bd-b5f7-400c8bf046f3", "from": "59158f78-222c-4c3c-9d32-90ad90be2ac7", "toPort": "0", "fromPort": "0" }, { "to": "2d4e662b-f03e-406d-b337-8a33ab80aa1a", "from": "8a3f8345-f5a3-44bd-b5f7-400c8bf046f3", "toPort": "0", "fromPort": "0" }, { "to": "854eb94c-dfb8-4619-9751-c7f107157606", "from": "60d086ed-d2d1-4789-9727-8ccc3984550c", "toPort": "0", "fromPort": "0" }, { "to": "b8ee7fdb-5084-4014-906a-d1f5e24cb3e0", "from": "2d4e662b-f03e-406d-b337-8a33ab80aa1a", "toPort": "0", "fromPort": "0" }, { "to": "aeea1ae9-28f7-4e07-b4a3-eeab52888e96", "from": "85d0dee7-7180-4ef4-a6ae-7b9f9c33e866", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "688ca90b-8d7c-4baf-9a85-3647c8be1cd5", "name": "Every Monday 8AM", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "weeks", "triggerAtDay": [ 1 ], "triggerAtHour": 8 } ] } }, "position": [ 960, 480 ] }, { "id": "85d0dee7-7180-4ef4-a6ae-7b9f9c33e866", "name": "When clicking ‘Execute workflow’", "type": "manualTrigger", "params": {}, "position": [ 960, 640 ] }, { "id": "aeea1ae9-28f7-4e07-b4a3-eeab52888e96", "name": "1. Define Subreddits", "type": "code", "params": { "jsCode": "return [\n \"entrepreneur\",\n \"smallbusiness\",\n \"freelance\",\n \"SaaS\",\n \"startups\",\n \"productivity\",\n \"webdev\",\n \"marketing\",\n \"consulting\",\n \"Accounting\"\n].map(s => ({ json: { subreddit: s } }));" }, "position": [ 1200, 480 ] }, { "id": "59158f78-222c-4c3c-9d32-90ad90be2ac7", "name": "2. Fetch Reddit Posts", "type": "http", "params": { "url": "=https://www.reddit.com/r/{{ $json.subreddit }}/new.json", "options": {}, "sendQuery": true, "sendHeaders": true, "queryParameters": { "parameters": [ { "name": "limit", "value": "100" } ] }, "headerParameters": { "parameters": [ { "name": "User-Agent", "value": "n8n-pain-miner/1.0 (automated research tool)" } ] } }, "position": [ 1424, 480 ] }, { "id": "8a3f8345-f5a3-44bd-b5f7-400c8bf046f3", "name": "3. Filter Pain Points", "type": "code", "params": { "jsCode": "const posts = ($json.data?.children || []).map(p => p.data);\n\nconst keywords = [\n \"i hate\",\n \"why doesn't\",\n \"why isn't\",\n \"there's no tool\",\n \"there is no tool\",\n \"wish there was\",\n \"no app for\",\n \"why is there no\",\n \"someone should build\",\n \"why can't\",\n \"so frustrated\",\n \"sick of manually\",\n \"tired of doing\",\n \"doesn't exist\",\n \"pain point\",\n \"annoying that\",\n \"is it just me\",\n \"can't find anything\",\n \"i need a way to\",\n \"such a waste of time\",\n \"why do i have to\",\n \"manual process\",\n \"no solution\",\n \"nobody has built\",\n \"looking for a tool\",\n \"does anyone know of a\",\n \"is there a way to automate\",\n \"still no way to\"\n];\n\nconst filtered = posts.filter(p => {\n const text = `${p.title} ${p.selftext || ''}`.toLowerCase();\n return keywords.some(kw => text.includes(kw));\n});\n\nif (filtered.length === 0) return [];\n\nreturn filtered.map(p => ({\n json: {\n subreddit: `r/${p.subreddit}`,\n title: p.title,\n text: (p.selftext || '').slice(0, 400),\n url: `https://reddit.com${p.permalink}`,\n score: p.score,\n comments: p.num_comments\n }\n}));" }, "position": [ 1648, 480 ] }, { "id": "2d4e662b-f03e-406d-b337-8a33ab80aa1a", "name": "4. Aggregate All Posts", "type": "passthrough", "params": { "mode": "aggregate", "options": {}, "aggregate": "aggregateAllItemData", "destinationFieldName": "posts" }, "position": [ 1856, 480 ] }, { "id": "b8ee7fdb-5084-4014-906a-d1f5e24cb3e0", "name": "5. Build AI Prompt", "type": "code", "params": { "jsCode": "const posts = $json.posts || [];\n\nif (posts.length === 0) {\n return [{ json: { requestBody: { model: 'gpt-4o', max_tokens: 500, messages: [{ role: 'user', content: 'Say: No pain points were found this week across the monitored subreddits.' }] }, postCount: 0 } }];\n}\n\nconst postsText = posts\n .map((p, i) => `${i + 1}. [${p.subreddit}] \"${p.title}\"\\n${p.text}\\nScore: ${p.score} | Comments: ${p.comments} | ${p.url}`)\n .join('\\n\\n---\\n\\n');\n\nconst systemPrompt = `You are a sharp, no-fluff startup opportunity analyst. \nYou analyze Reddit posts to find genuine unmet needs and viable business opportunities. \nBe specific. Avoid generic advice. Think like a product builder, not a consultant.`;\n\nconst userPrompt = `Analyze these ${posts.length} Reddit posts collected this week. People are expressing real frustration, wishing tools existed, or describing manual processes they hate.\n\nProduce a clean, structured report with exactly these sections:\n\n🔥 TOP PAIN POINT CLUSTERS\nGroup similar complaints together. For each cluster:\n- Cluster name\n- The core unmet need in one sentence\n- Number of posts mentioning it\n- Which subreddits it appears in\n\n💡 BEST OPPORTUNITIES\nFor each top cluster, describe:\n- What product/tool/service solves it\n- Who exactly would pay for this\n- How to validate it in 1 week (be specific)\n\n🎯 UNDERSERVED NICHES\nCall out 2-3 very specific pain points that seem overlooked — small but real markets with little competition\n\n⚡ QUICK WINS\n2-3 ideas that could be built as an MVP or validated in under 2 weeks. Be concrete.\n\nHere are the posts (${posts.length} total):\n\n${postsText}`;\n\nreturn [{\n json: {\n requestBody: {\n model: \"gpt-4o\",\n max_tokens: 2500,\n messages: [\n { role: \"system\", content: systemPrompt },\n { role: \"user\", content: userPrompt }\n ]\n },\n postCount: posts.length\n }\n}];" }, "position": [ 2080, 480 ] }, { "id": "60d086ed-d2d1-4789-9727-8ccc3984550c", "name": "6. HTTP Request @Groq", "type": "http", "params": { "url": "https://api.groq.com/openai/v1/chat/completions", "method": "POST", "options": {}, "jsonBody": "={\n \"model\": \"llama-3.3-70b-versatile\",\n \"max_tokens\": 2500,\n \"messages\": {{ JSON.stringify($('5. Build AI Prompt').first().json.requestBody.messages) }}\n}", "sendBody": true, "specifyBody": "json", "authentication": "predefinedCredentialType" }, "position": [ 2272, 480 ] }, { "id": "854eb94c-dfb8-4619-9751-c7f107157606", "name": "7. Format Email", "type": "code", "params": { "jsCode": "//const aiContent = $json.text || $json.output || $input.first().json.text || 'AI analysis failed.';\nconst aiContent = $json.choices?.[0]?.message?.content || 'AI analysis failed.';\nconst postCount = $('5. Build AI Prompt').first().json.postCount;\nconst today = new Date().toLocaleDateString('en-US', {\n weekday: 'long', year: 'numeric', month: 'long', day: 'numeric'\n});\n\nconst htmlBody = `\n

🔍 Reddit Pain Mining Report

${today}

${postCount} pain-point posts analyzed across 10 subreddits this week.

${aiContent}

\n Generated by n8n Pain Mining Workflow · Subreddits: entrepreneur, smallbusiness, freelance, SaaS, startups, productivity, webdev, marketing, consulting, Accounting\n

\n`;\n\nreturn [{\n json: {\n subject: `🔍 Reddit Pain Mining — ${postCount} Opportunities Found (${today})`,\n htmlBody\n }\n}];" }, "position": [ 2464, 480 ] }, { "id": "289a652b-ba27-4d5e-963d-a1bca7fb4380", "name": "8. Gmail. Send Email Report", "type": "integration", "params": { "sendTo": "your@email.com", "message": "={{ $json.htmlBody }}", "options": {}, "service": "gmail", "subject": "={{ $json.subject }}", "operation": "read" }, "position": [ 2672, 480 ] } ] }

Generate weekly Reddit startup opportunity reports with Groq AI