{ "edges": [ { "to": "c335b635-893a-4e1d-aeeb-ecc4c4947bbd", "from": "f9fc4b70-f2dd-44f8-8ba1-245bf9f6a116", "toPort": "0", "fromPort": "0" }, { "to": "6a4ebcda-4997-4dc8-ab60-3370c0bf373e", "from": "c335b635-893a-4e1d-aeeb-ecc4c4947bbd", "toPort": "0", "fromPort": "0" }, { "to": "f9fc4b70-f2dd-44f8-8ba1-245bf9f6a116", "from": "d5ec0af7-cb90-4cd6-91dc-69857fe7bca9", "toPort": "0", "fromPort": "0" }, { "to": "4c463d5e-23a6-4662-b6c9-f1b818e81cd0", "from": "42bceff8-69d9-4d21-9d94-f3f7c2dd82ed", "toPort": "0", "fromPort": "0" }, { "to": "b9a2b5f0-0b83-439a-9acd-04031d27ed27", "from": "4c463d5e-23a6-4662-b6c9-f1b818e81cd0", "toPort": "0", "fromPort": "0" }, { "to": "42bceff8-69d9-4d21-9d94-f3f7c2dd82ed", "from": "6a4ebcda-4997-4dc8-ab60-3370c0bf373e", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "d5ec0af7-cb90-4cd6-91dc-69857fe7bca9", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "daysInterval": 7, "triggerAtHour": 7 } ] } }, "position": [ 144, 256 ] }, { "id": "f9fc4b70-f2dd-44f8-8ba1-245bf9f6a116", "name": "Google Ads Demo", "type": "code", "params": { "jsCode": "// Reproducible dummy metrics for last 7 days, by channel & campaign.\n// No external API needed. Good for demos.\n\n// --- helpers ---\nfunction seededRandom(seed) {\n // simple LCG\n let s = seed % 2147483647;\n if (s <= 0) s += 2147483646;\n return () => (s = s * 16807 % 2147483647) / 2147483647;\n}\nconst seed = 20250601; // fix for reproducible demo\nconst rand = seededRandom(seed);\n\nfunction round(n, d=0) {\n const p = Math.pow(10,d);\n return Math.round(n*p)/p;\n}\n\nfunction dateISO(d) {\n return d.toISOString().slice(0,10);\n}\n\n// --- period (last 7 days) ---\nconst end = new Date(); // today\nconst start = new Date(end);\nstart.setDate(end.getDate() - 6); // inclusive 7 days\n\n// --- channels & base volumes ---\nconst channels = [\n { key: 'google_ads', name: 'Google Ads', baseImp: 140000, baseCpc: 0.6, baseConvRate: 0.018 },\n { key: 'meta_ads', name: 'Meta Ads', baseImp: 120000, baseCpc: 0.45, baseConvRate: 0.015 },\n { key: 'tiktok_ads', name: 'TikTok Ads', baseImp: 90000, baseCpc: 0.35, baseConvRate: 0.012 },\n { key: 'youtube_ads', name: 'YouTube Ads', baseImp: 110000, baseCpc: 0.40, baseConvRate: 0.010 },\n];\n\nconst campaignsByChannel = {\n google_ads: ['Brand Search', 'Competitor Search', 'Non-Brand Generic'],\n meta_ads: ['Prospecting Video', 'Retargeting Carousel', 'Broad Static'],\n tiktok_ads: ['Spark Ads UGC', 'Creator Whitelist', 'TopView Test'],\n youtube_ads: ['In-Stream Skippable', 'In-Feed Shorts', 'Remarketing']\n};\n\n// --- generate data ---\nlet totals = { impressions: 0, clicks: 0, conversions: 0, spend: 0, revenue: 0 };\nconst byChannel = [];\n\nfor (const ch of channels) {\n const chImpressions = Math.floor(ch.baseImp * (0.9 + rand()*0.3)); // ±15%\n const chClicks = Math.floor(chImpressions * (0.01 + rand()*0.02)); // 1%–3%\n const chCpc = round(ch.baseCpc * (0.85 + rand()*0.3), 2);\n const chSpend = round(chClicks * chCpc, 2);\n const chConvRate = ch.baseConvRate * (0.8 + rand()*0.4); // ±20%\n const chConversions = Math.floor(chClicks * chConvRate);\n const aov = 38 + rand()*22; // average order value 38–60\n const chRevenue = round(chConversions * aov, 2);\n const chRoas = chSpend > 0 ? round(chRevenue / chSpend, 2) : null;\n\n // campaigns\n const campNames = campaignsByChannel[ch.key];\n const campaigns = [];\n let remImp = chImpressions, remClicks = chClicks, remConv = chConversions, remSpend = chSpend, remRev = chRevenue;\n\n for (let i=0;i0 ? round(rev/sp,2) : null,\n cpc: clk>0 ? round(sp/clk,2) : null,\n ctr: imp>0 ? round((clk/imp)*100,2) : null,\n convRate: clk>0 ? round((conv/clk)*100,2) : null,\n });\n remImp -= imp; remClicks -= clk; remConv -= conv; remSpend = round(remSpend - sp,2); remRev = round(remRev - rev,2);\n }\n\n totals.impressions += chImpressions;\n totals.clicks += chClicks;\n totals.conversions += chConversions;\n totals.spend = round(totals.spend + chSpend, 2);\n totals.revenue = round(totals.revenue + chRevenue, 2);\n\n byChannel.push({\n key: ch.key,\n name: ch.name,\n impressions: chImpressions,\n clicks: chClicks,\n conversions: chConversions,\n spend: chSpend,\n revenue: chRevenue,\n roas: chRoas,\n cpc: chCpc,\n ctr: chImpressions>0 ? round((chClicks/chImpressions)*100,2) : null,\n convRate: chClicks>0 ? round((chConversions/chClicks)*100,2) : null,\n campaigns\n });\n}\n\nconst period = { start: dateISO(start), end: dateISO(end) };\nconst summary = {\n impressions: totals.impressions,\n clicks: totals.clicks,\n conversions: totals.conversions,\n spend: totals.spend,\n revenue: totals.revenue,\n roas: totals.spend>0 ? round(totals.revenue/totals.spend,2) : null,\n ctr: totals.impressions>0 ? round((totals.clicks/totals.impressions)*100,2) : null,\n convRate: totals.clicks>0 ? round((totals.conversions/totals.clicks)*100,2) : null,\n};\n\nreturn {\n period,\n summary,\n byChannel\n};" }, "position": [ 368, 256 ] }, { "id": "c335b635-893a-4e1d-aeeb-ecc4c4947bbd", "name": "Message a model", "type": "llm", "params": { "modelId": { "__rl": true, "mode": "list", "value": "gpt-4o-mini", "cachedResultName": "GPT-4O-MINI" }, "options": {}, "messages": { "values": [ { "content": "=Create a short executive summary (120–180 words) for a weekly ad performance report.\nUse the provided JSON metrics. Include: key wins, issues, and 1-2 high-impact recommendations.\n\nPeriod: {{ $json.period.start }} → {{ $json.period.end }}\nTotals: {{ $json.summary }}\nChannels: {{ $json.byChannel[0] }}" }, { "role": "system", "content": "You are a senior performance marketer. Write concise, actionable summaries." } ] }, "provider": "openai" }, "position": [ 592, 256 ] }, { "id": "6a4ebcda-4997-4dc8-ab60-3370c0bf373e", "name": "Code in JavaScript", "type": "code", "params": { "jsCode": "/**\n * Build a weekly report in Markdown from fake metrics + LLM executive summary.\n * IMPORTANT: Set these to your exact node names in the left sidebar.\n */\nconst METRICS_NODE = \"Google Ads Demo\"; // <— dein Metrics-Code-Node\nconst SUMMARY_NODE = \"Message a model\"; // <— dein LLM-Node\n\n// ---- pull data from the referenced nodes ----\nconst metrics = $node[METRICS_NODE]?.json;\nif (!metrics) {\n throw new Error(`Metrics node \"${METRICS_NODE}\" not found or has no JSON output.`);\n}\nconst period = metrics.period || {};\nconst S = metrics.summary || {};\nconst channels = metrics.byChannel || [];\n\nconst exec = $node[SUMMARY_NODE]?.json?.message?.content\n || \"No executive summary available.\";\n\n// ---- helpers ----\nfunction fmt(n, d=0) {\n if (n === null || n === undefined) return \"-\";\n return Number(n).toLocaleString(undefined, { maximumFractionDigits: d });\n}\n\nfunction mdChannelTable(rows) {\n const header = `| Channel | Impr. | Clicks | Conv. | Spend | Revenue | ROAS | CTR | CVR |\n|---|---:|---:|---:|---:|---:|---:|---:|---:|`;\n const lines = rows.map(r =>\n `| ${r.name} | ${fmt(r.impressions)} | ${fmt(r.clicks)} | ${fmt(r.conversions)} | $${fmt(r.spend,2)} | $${fmt(r.revenue,2)} | ${fmt(r.roas,2)} | ${fmt(r.ctr,2)}% | ${fmt(r.convRate,2)}% |`\n );\n return [header, ...lines].join('\\n');\n}\n\nfunction mdTopCampaigns(rows) {\n const all = [];\n for (const ch of rows) {\n for (const c of (ch.campaigns || [])) all.push({ channel: ch.name, ...c });\n }\n all.sort((a,b) => (b.roas ?? 0) - (a.roas ?? 0));\n const top = all.slice(0,3);\n const header = `| Campaign | Channel | ROAS | Spend | Revenue | CTR | CVR |\n|---|---|---:|---:|---:|---:|---:|`;\n const lines = top.map(t =>\n `| ${t.name} | ${t.channel} | ${fmt(t.roas,2)} | $${fmt(t.spend,2)} | $${fmt(t.revenue,2)} | ${fmt(t.ctr,2)}% | ${fmt(t.convRate,2)}% |`\n );\n return [header, ...lines].join('\\n');\n}\n\n// ---- assemble markdown ----\nconst md = [\n `# Weekly Performance Report`,\n `**Period:** ${period.start ?? \"-\"} → ${period.end ?? \"-\"}`,\n ``,\n `## Executive Summary`,\n exec,\n ``,\n `## Totals`,\n `- Impressions: ${fmt(S.impressions)}`,\n `- Clicks: ${fmt(S.clicks)}`,\n `- Conversions: ${fmt(S.conversions)}`,\n `- Spend: $${fmt(S.spend,2)}`,\n `- Revenue: $${fmt(S.revenue,2)}`,\n `- ROAS: ${fmt(S.roas,2)}`,\n `- CTR: ${fmt(S.ctr,2)}%`,\n `- Conversion Rate: ${fmt(S.convRate,2)}%`,\n ``,\n `## Performance by Channel`,\n channels.length ? mdChannelTable(channels) : \"_No channel data._\",\n ``,\n `## Top Campaigns (by ROAS)`,\n channels.length ? mdTopCampaigns(channels) : \"_No campaigns available._\",\n ``,\n `*Generated automatically by n8n.*`\n].join('\\n');\n\nreturn {\n report: md,\n period,\n summary: S,\n byChannel: channels\n};" }, "position": [ 960, 256 ] }, { "id": "42bceff8-69d9-4d21-9d94-f3f7c2dd82ed", "name": "Create a document", "type": "integration", "params": { "title": "=Weekly Performance Report – {{ $json.period.start }} to {{ $json.period.end }}", "service": "googleDocs", "folderId": "11ih8BSx4EacEniL01PhPSHzRbvaWj83n", "operation": "read" }, "position": [ 1248, 256 ] }, { "id": "4c463d5e-23a6-4662-b6c9-f1b818e81cd0", "name": "Update a document", "type": "integration", "params": { "service": "googleDocs", "actionsUi": { "actionFields": [ { "text": "={{ $('Code in JavaScript').item.json.report }}", "action": "insert" } ] }, "operation": "update", "documentURL": "={{ $json.id }}" }, "position": [ 1520, 256 ] }, { "id": "b9a2b5f0-0b83-439a-9acd-04031d27ed27", "name": "Send a message", "type": "integration", "params": { "text": "=:bar_chart: Weekly report is ready\nPeriod: {{ $('Code in JavaScript').item.json.period.start }} → {{ $('Code in JavaScript').item.json.period.end }}\nTopline: ROAS {{ $('Code in JavaScript').item.json.summary.roas }} | Spend ${{ $('Code in JavaScript').item.json.summary.spend }}\n\nOpen Doc: https://docs.google.com/document/d/{{ $json.documentId }}/edit", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "C09HKQVAKB7", "cachedResultName": "demo" }, "operation": "read", "otherOptions": {}, "authentication": "oAuth2" }, "position": [ 1808, 256 ] } ] }

Generate weekly marketing performance reports with GPT-4o & Google Docs to Slack