Competitor Intelligence Briefing

{ "edges": [ { "to": "02210b2e-bc4d-43ef-8f08-76fac45f4323", "from": "a49040e9-cf7e-4a6f-8268-bd821345361d", "toPort": "0", "fromPort": "0" }, { "to": "42d55918-3ca8-4a54-953a-9fc43cbd2a4d", "from": "2a35d57b-5111-4370-8fc6-19c97c3d6efd", "toPort": "0", "fromPort": "0" }, { "to": "9ee87063-688f-438f-b7a4-05c77f977e2b", "from": "2a35d57b-5111-4370-8fc6-19c97c3d6efd", "toPort": "0", "fromPort": "0" }, { "to": "cd2d24f5-9c19-418e-bd8a-e0fe60c49237", "from": "24a049b2-0809-4482-9cdc-43e44c508959", "toPort": "0", "fromPort": "0" }, { "to": "24a049b2-0809-4482-9cdc-43e44c508959", "from": "4a3497e1-cbfd-451b-a0f8-fcb2ca200ca9", "toPort": "0", "fromPort": "0" }, { "to": "85a8da5a-e050-488b-9922-a51805577e54", "from": "53a7fd51-f7d0-43fe-b24a-156201b521ec", "toPort": "0", "fromPort": "0" }, { "to": "2a35d57b-5111-4370-8fc6-19c97c3d6efd", "from": "c3333ac2-8f69-403c-804e-317dc844a155", "toPort": "0", "fromPort": "0" }, { "to": "4a3497e1-cbfd-451b-a0f8-fcb2ca200ca9", "from": "85a8da5a-e050-488b-9922-a51805577e54", "toPort": "0", "fromPort": "0" }, { "to": "53a7fd51-f7d0-43fe-b24a-156201b521ec", "from": "02210b2e-bc4d-43ef-8f08-76fac45f4323", "toPort": "0", "fromPort": "0" }, { "to": "c3333ac2-8f69-403c-804e-317dc844a155", "from": "cd2d24f5-9c19-418e-bd8a-e0fe60c49237", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "a49040e9-cf7e-4a6f-8268-bd821345361d", "name": "Daily 8AM Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "hours", "hoursInterval": 24 } ] } }, "position": [ 1424, 0 ] }, { "id": "02210b2e-bc4d-43ef-8f08-76fac45f4323", "name": "Configure Competitors and Settings", "type": "code", "params": { "jsCode": "/* ==================================================\n ️ CONFIGURE THIS NODE — All your settings here\n ================================================== */\n\n// 1. Who receives the daily briefing?\nconst REPORT_EMAIL = 'user@example.com';\n\n// 2. Your company name (used in AI prompts)\nconst YOUR_COMPANY = 'Acme Corp';\n\n// 3. Your market/product category (for relevant insights)\nconst YOUR_FOCUS = 'B2B SaaS project management tools';\n\n// 4. Add your competitors below.\n// url: the page to visit (homepage or pricing page works best)\n// watch_for: tells the AI which signals matter for each competitor\nconst COMPETITORS = [\n {\n name: 'Competitor Alpha',\n url: 'https://www.competitor-alpha.com',\n watch_for: 'pricing tiers, new feature announcements, customer testimonials, messaging changes'\n },\n {\n name: 'Competitor Beta',\n url: 'https://www.competitor-beta.com',\n watch_for: 'integrations, enterprise moves, product roadmap hints, partnerships'\n },\n {\n name: 'Competitor Gamma',\n url: 'https://www.competitor-gamma.com',\n watch_for: 'go-to-market strategy, pricing model, positioning, new use cases'\n }\n];\n\n/* ===================================\n DO NOT EDIT BELOW THIS LINE\n =================================== */\n\nconst today = new Date().toISOString().split('T')[0];\n\nreturn COMPETITORS.map(c => ({\n json: {\n competitor_name: c.name,\n competitor_url: c.url,\n watch_for: c.watch_for,\n report_email: REPORT_EMAIL,\n your_company: YOUR_COMPANY,\n your_focus: YOUR_FOCUS,\n run_date: today\n }\n}));" }, "position": [ 1664, 0 ] }, { "id": "53a7fd51-f7d0-43fe-b24a-156201b521ec", "name": "Fetch Competitor Page", "type": "http", "params": { "url": "={{ $json.competitor_url }}", "options": { "timeout": 20000, "redirect": { "redirect": { "maxRedirects": 5 } }, "response": { "response": {} } } }, "position": [ 1888, 0 ] }, { "id": "85a8da5a-e050-488b-9922-a51805577e54", "name": "Extract Text and Build AI Prompt", "type": "code", "params": { "jsCode": "// Clean raw HTML and build the per-competitor OpenAI request\nconst htmlData = $input.item.json;\nconst cfg = $('Configure Competitors and Settings').item.json;\n\nlet rawHtml = '';\nif (typeof htmlData === 'string') {\n rawHtml = htmlData;\n} else if (htmlData && typeof htmlData.data === 'string') {\n rawHtml = htmlData.data;\n} else {\n rawHtml = JSON.stringify(htmlData);\n}\n\n// Strip scripts, styles, nav, SVGs and all remaining HTML tags\nconst pageText = rawHtml\n .replace(//gi, '')\n .replace(//gi, '')\n .replace(//gi, '')\n .replace(//gi, '')\n .replace(//gi, '')\n .replace(//gi, '')\n .replace(/<[^>]+>/g, ' ')\n .replace(/&/g, '&')\n .replace(/</g, '<')\n .replace(/>/g, '>')\n .replace(/ /g, ' ')\n .replace(/&#[0-9]+;/g, ' ')\n .replace(/\\s+/g, ' ')\n .trim()\n .slice(0, 4500);\n\nconst systemMsg = 'You are a senior competitive intelligence analyst working for ' + cfg.your_company + ', competing in the ' + cfg.your_focus + ' market. Extract concise, actionable intelligence from competitor website content. Be specific. Skip filler.';\n\nconst userMsg = 'Analyze this content from ' + cfg.competitor_name + ' website (' + cfg.competitor_url + ').\\n\\nWatch specifically for: ' + cfg.watch_for + '\\n\\n--- SCRAPED CONTENT ---\\n' + (pageText || 'ERROR: Page could not be loaded.') + '\\n--- END ---\\n\\nRespond with EXACTLY this structure (no extra text):\\n\\nCOMPETITOR: ' + cfg.competitor_name + '\\n\\nKEY SIGNALS (max 4 bullet points):\\n- [signal]\\n- [signal]\\n\\nTHREAT LEVEL: [High / Medium / Low]\\nReason: [one sentence]\\n\\nRECOMMENDED ACTION for ' + cfg.your_company + ': [1-2 sentences]\\n\\nIf the content is an error page, CAPTCHA wall, or too thin to analyze, state that clearly.';\n\nconst openaiBody = {\n model: 'gpt-4o-mini',\n max_tokens: 500,\n temperature: 0.3,\n messages: [\n { role: 'system', content: systemMsg },\n { role: 'user', content: userMsg }\n ]\n};\n\nreturn [{\n json: {\n competitor_name: cfg.competitor_name,\n competitor_url: cfg.competitor_url,\n watch_for: cfg.watch_for,\n report_email: cfg.report_email,\n your_company: cfg.your_company,\n your_focus: cfg.your_focus,\n run_date: cfg.run_date,\n openai_body: JSON.stringify(openaiBody)\n }\n}];" }, "position": [ 2112, 0 ] }, { "id": "4a3497e1-cbfd-451b-a0f8-fcb2ca200ca9", "name": "AI Analyze Competitor", "type": "http", "params": { "url": "https://api.openai.com/v1/chat/completions", "method": "POST", "options": { "timeout": 45000 }, "jsonBody": "={{ $json.openai_body }}", "sendBody": true, "specifyBody": "json", "authentication": "predefinedCredentialType", "nodeCredentialType": "openAiApi" }, "position": [ 2320, 0 ] }, { "id": "24a049b2-0809-4482-9cdc-43e44c508959", "name": "Parse AI Response", "type": "code", "params": { "jsCode": "// Extract the AI analysis text and carry forward all metadata\nconst res = $input.item.json;\nconst ctx = $('Extract Text and Build AI Prompt').item.json;\n\nconst analysis = res.choices?.[0]?.message?.content\n || '**Analysis unavailable** — check your OpenAI credential or the target URL.';\n\nreturn [{\n json: {\n competitor_name: ctx.competitor_name,\n competitor_url: ctx.competitor_url,\n analysis: analysis,\n report_email: ctx.report_email,\n your_company: ctx.your_company,\n your_focus: ctx.your_focus,\n run_date: ctx.run_date\n }\n}];" }, "position": [ 2544, 0 ] }, { "id": "cd2d24f5-9c19-418e-bd8a-e0fe60c49237", "name": "Aggregate and Build Briefing Prompt", "type": "code", "params": { "jsCode": "// Aggregate all per-competitor analyses and build the final briefing request\nconst all = $input.all();\n\nif (!all || all.length === 0) {\n throw new Error('No competitor analyses received -- check the upstream nodes.');\n}\n\nconst first = all[0].json;\nconst today = first.run_date || new Date().toISOString().split('T')[0];\n\n// Build individual competitor sections for the final prompt\nconst analysisBlocks = all.map(function(item) {\n return '=== ' + item.json.competitor_name + ' (' + item.json.competitor_url + ') ===\\n' + item.json.analysis + '\\n';\n}).join('\\n');\n\nconst systemMsg = 'You are the VP of Competitive Intelligence at ' + first.your_company + ', operating in the ' + first.your_focus + ' market. You write sharp, executive-ready intelligence briefings in HTML for email. Every word earns its place. Leadership reads this before their 9AM standup.';\n\nconst userMsg = 'Today is ' + today + '. Our automated monitoring has analyzed ' + all.length + ' competitor(s).\\n\\nIndividual competitor reports:\\n\\n' + analysisBlocks + '\\n---\\nWrite a Daily Competitor Intelligence Briefing in clean HTML (email-safe). Use this exact structure:\\n\\n

Executive summary

\\n2-3 sentences covering the single most important competitive development and overall landscape.\\n\\n

Competitor snapshots

\\nFor each competitor: their name as a subheading, and 2-3 key insight bullets.\\n\\n

Priority actions for ' + first.your_company + '

\\nTop 3 actions, ranked by urgency. Bold action name, one-sentence rationale each.\\n\\n

Watch list

\\n2 things to monitor this week based on today signals.\\n\\nRules: Clean HTML only. Use strong, ul, li, p, h2, h3 tags. No inline CSS. No markdown. Scannable. No fluff.';\n\nconst openaiBody = {\n model: 'gpt-4o',\n max_tokens: 1800,\n temperature: 0.4,\n messages: [\n { role: 'system', content: systemMsg },\n { role: 'user', content: userMsg }\n ]\n};\n\nreturn [{\n json: {\n report_email: first.report_email,\n your_company: first.your_company,\n your_focus: first.your_focus,\n run_date: today,\n competitor_count: all.length,\n openai_body: JSON.stringify(openaiBody)\n }\n}];" }, "position": [ 2768, 0 ] }, { "id": "c3333ac2-8f69-403c-804e-317dc844a155", "name": "AI Generate Final Briefing", "type": "http", "params": { "url": "https://api.openai.com/v1/chat/completions", "method": "POST", "options": { "timeout": 90000 }, "jsonBody": "={{ $json.openai_body }}", "sendBody": true, "specifyBody": "json", "authentication": "predefinedCredentialType", "nodeCredentialType": "openAiApi" }, "position": [ 2992, 0 ] }, { "id": "2a35d57b-5111-4370-8fc6-19c97c3d6efd", "name": "Format HTML Email", "type": "code", "params": { "jsCode": "// Wrap the AI-generated HTML in a styled email template\nconst res = $input.item.json;\nconst meta = $('Aggregate and Build Briefing Prompt').item.json;\n\nconst bodyHtml = res.choices && res.choices[0] && res.choices[0].message && res.choices[0].message.content\n ? res.choices[0].message.content\n : '

Error: Briefing generation failed. Check your OpenAI credentials.

';\n\nconst emailHtml = [\n '',\n '',\n '',\n 'Competitor Intelligence Briefing',\n '',\n '

',\n '',\n '

' + bodyHtml + '

',\n '',\n '

'\n].join('');\n\nconst plainText = bodyHtml.replace(/<[^>]+>/g, ' ').replace(/\\s+/g, ' ').trim();\n\nreturn [{\n json: {\n email_html: emailHtml,\n email_plain: plainText,\n report_email: meta.report_email,\n your_company: meta.your_company,\n run_date: meta.run_date,\n competitor_count: meta.competitor_count\n }\n}];" }, "position": [ 3200, 0 ] }, { "id": "42d55918-3ca8-4a54-953a-9fc43cbd2a4d", "name": "Send Email Briefing", "type": "integration", "params": { "sendTo": "={{ $json.report_email }}", "message": "={{ $json.email_html }}", "options": {}, "service": "gmail", "subject": "={{ 'Competitor Briefing - ' + $json.run_date + ' (' + $json.competitor_count + ' competitors)' }}", "operation": "read" }, "position": [ 3424, -128 ] }, { "id": "9ee87063-688f-438f-b7a4-05c77f977e2b", "name": "Log to Google Sheets", "type": "integration", "params": { "columns": { "value": { "Date": "={{ $json.run_date }}", "Company": "={{ $json.your_company }}", "Briefing Summary": "={{ $json.email_plain }}", "Competitors Analyzed": "={{ $json.competitor_count }}" }, "schema": [], "mappingMode": "defineBelow", "matchingColumns": [] }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "name", "value": "Intelligence Log" }, "documentId": { "__rl": true, "mode": "id", "value": "PASTE_YOUR_GOOGLE_SHEET_ID_HERE" } }, "position": [ 3424, 128 ] } ] }

Generate a daily competitor intelligence briefing with OpenAI and Gmail