{ "edges": [ { "to": "0454934a-3f2b-427c-b889-d2ce0fc4531f", "from": "d8261e5c-934a-4761-ac33-52cb6df0ee46", "toPort": "1", "fromPort": "0" }, { "to": "d3645c22-520c-4200-8b7f-97cb7412772c", "from": "75fdb746-6543-4289-8c4b-c63b8d770f51", "toPort": "0", "fromPort": "0" }, { "to": "ecd61a8b-c77f-4cc1-b31a-c5fc92656b91", "from": "75fdb746-6543-4289-8c4b-c63b8d770f51", "toPort": "0", "fromPort": "0" }, { "to": "d8261e5c-934a-4761-ac33-52cb6df0ee46", "from": "75fdb746-6543-4289-8c4b-c63b8d770f51", "toPort": "0", "fromPort": "0" }, { "to": "0454934a-3f2b-427c-b889-d2ce0fc4531f", "from": "2caeebbd-37fa-492f-9fcb-09c871782899", "toPort": "0", "fromPort": "0" }, { "to": "2caeebbd-37fa-492f-9fcb-09c871782899", "from": "ecd61a8b-c77f-4cc1-b31a-c5fc92656b91", "toPort": "1", "fromPort": "0" }, { "to": "75fdb746-6543-4289-8c4b-c63b8d770f51", "from": "0222e36c-a40a-4f64-b370-242ee629a445", "toPort": "0", "fromPort": "0" }, { "to": "05b5400f-9a6b-4dc1-984c-0b66afd31fea", "from": "ab264826-54f3-42c9-9cd9-a95d2f31756e", "toPort": "0", "fromPort": "0" }, { "to": "58ea49ce-4ebc-43c3-a959-42b6a060c906", "from": "ab264826-54f3-42c9-9cd9-a95d2f31756e", "toPort": "0", "fromPort": "1" }, { "to": "44a305b6-b7a4-445d-bf48-5e452942e15f", "from": "0454934a-3f2b-427c-b889-d2ce0fc4531f", "toPort": "0", "fromPort": "0" }, { "to": "2caeebbd-37fa-492f-9fcb-09c871782899", "from": "d3645c22-520c-4200-8b7f-97cb7412772c", "toPort": "0", "fromPort": "0" }, { "to": "05b5400f-9a6b-4dc1-984c-0b66afd31fea", "from": "e39147ed-6397-42f3-a815-7dba43dc7ef1", "toPort": "1", "fromPort": "0" }, { "to": "ab264826-54f3-42c9-9cd9-a95d2f31756e", "from": "01fbedd7-b27d-457a-937f-b8d9d392bb7d", "toPort": "0", "fromPort": "0" }, { "to": "0faf1bf2-e313-436c-b5a1-fb5709b88242", "from": "05b5400f-9a6b-4dc1-984c-0b66afd31fea", "toPort": "0", "fromPort": "0" }, { "to": "01fbedd7-b27d-457a-937f-b8d9d392bb7d", "from": "58ea49ce-4ebc-43c3-a959-42b6a060c906", "toPort": "0", "fromPort": "0" }, { "to": "dcda36dd-3c67-4350-97f5-f4da2ae5d2dd", "from": "0faf1bf2-e313-436c-b5a1-fb5709b88242", "toPort": "0", "fromPort": "0" }, { "to": "e39147ed-6397-42f3-a815-7dba43dc7ef1", "from": "59b495a0-ba79-4232-b76f-f82d31423f32", "toPort": "0", "fromPort": "0" }, { "to": "ab264826-54f3-42c9-9cd9-a95d2f31756e", "from": "44a305b6-b7a4-445d-bf48-5e452942e15f", "toPort": "0", "fromPort": "0" }, { "to": "59b495a0-ba79-4232-b76f-f82d31423f32", "from": "44a305b6-b7a4-445d-bf48-5e452942e15f", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "0222e36c-a40a-4f64-b370-242ee629a445", "name": "Every Monday 9 AM", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "weeks", "triggerAtDay": 1, "triggerAtHour": 9 } ] } }, "position": [ 3984, 2864 ] }, { "id": "75fdb746-6543-4289-8c4b-c63b8d770f51", "name": "WES Config", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "w1", "name": "weight_like", "type": "number", "value": 1 }, { "id": "w2", "name": "weight_comment", "type": "number", "value": 3 }, { "id": "w3", "name": "weight_share", "type": "number", "value": 5 }, { "id": "w4", "name": "weight_save", "type": "number", "value": 4 } ] } }, "position": [ 4208, 2864 ] }, { "id": "d3645c22-520c-4200-8b7f-97cb7412772c", "name": "Get LinkedIn Posts", "type": "http", "params": { "url": "=https://api.linkedin.com/v2/ugcPosts?q=authors&authors=List({{$env.LINKEDIN_OWNER_URN}})&count=100", "options": {}, "sendHeaders": true, "authentication": "predefinedCredentialType", "headerParameters": { "parameters": [ { "name": "LinkedIn-Version", "value": "202304" } ] }, "nodeCredentialType": "linkedInOAuth2Api" }, "position": [ 4528, 2608 ] }, { "id": "ecd61a8b-c77f-4cc1-b31a-c5fc92656b91", "name": "Search Tweets", "type": "integration", "params": { "limit": 100, "service": "twitter", "operation": "search", "searchText": "={{$env.TWITTER_SEARCH_QUERY}}", "__originalType": "n8n-nodes-base.twitter", "additionalFields": { "startTime": "={{$now.minus({days: 7}).toISO()}}" } }, "position": [ 4528, 2848 ] }, { "id": "d8261e5c-934a-4761-ac33-52cb6df0ee46", "name": "Get media", "type": "integration", "params": { "limit": 100, "service": "instagram", "resource": "igUser", "operation": "getMedia", "__originalType": "@mookielianhd/n8n-nodes-instagram.instagram", "graphApiVersion": "v24.0" }, "position": [ 4528, 3040 ] }, { "id": "2caeebbd-37fa-492f-9fcb-09c871782899", "name": "Merge LI & TW", "type": "merge", "params": {}, "position": [ 4800, 2720 ] }, { "id": "0454934a-3f2b-427c-b889-d2ce0fc4531f", "name": "Merge All Streams", "type": "merge", "params": {}, "position": [ 5024, 2848 ] }, { "id": "44a305b6-b7a4-445d-bf48-5e452942e15f", "name": "Normalize & Validate Posts", "type": "code", "params": { "jsCode": "// Weights from WES Config node\nconst weights = $('WES Config').first().json;\nconst wLike = weights.weight_like ?? 1;\nconst wComment = weights.weight_comment ?? 3;\nconst wShare = weights.weight_share ?? 5;\nconst wSave = weights.weight_save ?? 4;\n\n// Use native JS Date.now() — safe in all n8n hosting environments\nconst weekAgo = Date.now() - (7 * 24 * 60 * 60 * 1000);\n\nreturn $input.all().reduce((acc, item) => {\n const d = item.json;\n if (!d || Object.keys(d).length === 0) return acc;\n\n // Platform detection\n const isLinkedIn = d.firstPublishedAt !== undefined || d.specificContent !== undefined;\n const isInstagram = d.permalink !== undefined && d.timestamp !== undefined;\n const isTwitter = d.public_metrics !== undefined;\n\n // Direct timestamp extraction — no intermediate ISO string conversion\n let ts = null;\n if (d.firstPublishedAt) ts = new Date(d.firstPublishedAt).getTime();\n else if (d.publishedDate || d.created_at || d.timestamp) ts = new Date(d.publishedDate || d.created_at || d.timestamp).getTime();\n\n if (!ts || isNaN(ts) || ts < weekAgo) return acc;\n\n const platform = d.platform\n || (isLinkedIn ? 'linkedin'\n : isInstagram ? 'instagram'\n : isTwitter ? 'twitter'\n : 'unknown');\n\n const pm = d.public_metrics || {};\n const likes = pm.like_count || d.like_count || d.likes || d.likeCount || 0;\n const comments = pm.reply_count || d.comments_count || d.comments || d.reply_count || 0;\n const shares = pm.retweet_count || d.shares || d.retweet_count || d.shareCount || 0;\n const saves = pm.bookmark_count || d.saves || d.bookmark_count || 0;\n const impressions = pm.impression_count\n || d.impressions || d.view_count || d.reach\n || d.statistics?.totalShareStatistics?.impressionCount\n || null;\n\n const liText = d.specificContent?.['com.linkedin.ugc.ShareContent']?.shareCommentary?.text || '';\n const rawText = liText || d.text || d.caption || '';\n\n const twitterUrl = isTwitter && d.id\n ? 'https://twitter.com/i/web/status/' + d.id\n : null;\n const url = d.url || d.permalink || twitterUrl || '#';\n\n acc.push({\n json: {\n _platform: platform,\n _date: new Date(ts).toISOString(),\n _likes: likes,\n _comments: comments,\n _shares: shares,\n _saves: saves,\n _impressions: impressions,\n _text: rawText.trim(),\n _url: url,\n _wLike: wLike,\n _wComment: wComment,\n _wShare: wShare,\n _wSave: wSave\n }\n });\n\n return acc;\n}, []);" }, "position": [ 5328, 2752 ] }, { "id": "ab264826-54f3-42c9-9cd9-a95d2f31756e", "name": "Loop Over Batches", "type": "passthrough", "params": { "mode": "noOp", "options": {}, "batchSize": 50 }, "position": [ 5680, 2560 ] }, { "id": "58ea49ce-4ebc-43c3-a959-42b6a060c906", "name": "Log Raw Posts to Sheets", "type": "integration", "params": { "columns": { "value": { "URL": "={{$json._url}}", "Date": "={{$json._date}}", "Content": "={{$json._text.slice(0, 100)}}", "Platform": "={{$json._platform}}", "Engagement": "={{$json._likes + $json._comments + $json._shares + $json._saves}}", "Impressions": "={{$json._impressions ?? 'unknown'}}" }, "mappingMode": "defineBelow" }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "name", "value": "Sheet1" }, "documentId": { "__rl": true, "mode": "id", "value": "={{$env.ANALYTICS_SPREADSHEET_ID}}" } }, "position": [ 5856, 2704 ] }, { "id": "01fbedd7-b27d-457a-937f-b8d9d392bb7d", "name": "Capture Sheet Errors", "type": "code", "params": { "jsCode": "const errors = $input.all()\n .filter(i => i.json.error)\n .map(i => i.json.error?.message || 'Unknown error writing to Sheets');\n\nreturn [{ json: { sheetErrors: errors, sheetErrorCount: errors.length } }];" }, "position": [ 6192, 2720 ] }, { "id": "59b495a0-ba79-4232-b76f-f82d31423f32", "name": "Calculate Analytics (WES)", "type": "code", "params": { "jsCode": "// Use native JS Date.now() — safe in all n8n hosting environments\nconst items = $input.all();\nlet totalImpressions = 0;\nlet totalWesSum = 0;\nlet postsWithImpressions = 0;\nlet postsWithoutImpressions = 0;\nlet bestPost = null;\nlet worstPost = null;\nconst platformStats = {};\n\nitems.forEach(item => {\n const d = item.json;\n if (!d || Object.keys(d).length === 0) return;\n\n const wLike = d._wLike ?? 1;\n const wComment = d._wComment ?? 3;\n const wShare = d._wShare ?? 5;\n const wSave = d._wSave ?? 4;\n\n const platform = d._platform;\n const likes = d._likes || 0;\n const comments = d._comments || 0;\n const shares = d._shares || 0;\n const saves = d._saves || 0;\n const impressions = d._impressions;\n const wes = (wLike * likes) + (wComment * comments) + (wShare * shares) + (wSave * saves);\n\n if (!platformStats[platform]) {\n platformStats[platform] = { posts: 0, impressions: 0, wesSum: 0, postsWithImpressions: 0 };\n }\n platformStats[platform].posts++;\n\n if (impressions !== null && impressions > 0) {\n const rate = (wes / impressions) * 100;\n platformStats[platform].impressions += impressions;\n platformStats[platform].wesSum += wes;\n platformStats[platform].postsWithImpressions++;\n totalImpressions += impressions;\n totalWesSum += wes;\n postsWithImpressions++;\n\n const postPayload = { platform, text: d._text || 'Media post', rate, url: d._url };\n if (!bestPost || rate > bestPost.rate) bestPost = postPayload;\n if (!worstPost || rate < worstPost.rate) worstPost = postPayload;\n } else {\n postsWithoutImpressions++;\n }\n});\n\nconst platformRankings = Object.entries(platformStats)\n .map(([name, s]) => ({\n name,\n avgEngagementRate: s.postsWithImpressions > 0\n ? ((s.wesSum / s.impressions) * 100).toFixed(2)\n : 'N/A',\n totalPosts: s.posts,\n totalImpressions: s.impressions\n }))\n .sort((a, b) => parseFloat(b.avgEngagementRate) - parseFloat(a.avgEngagementRate));\n\n// Native JS date math — no Luxon dependency\nconst now = new Date();\nconst weekAgo = new Date(now.getTime() - (7 * 24 * 60 * 60 * 1000));\nconst toISODate = d => d.toISOString().slice(0, 10);\n\nreturn [{\n json: {\n weekStart: toISODate(weekAgo),\n weekEnd: toISODate(now),\n totalPosts: items.length,\n postsWithImpressions,\n postsWithoutImpressions,\n totalImpressions,\n avgEngagementRate: postsWithImpressions > 0\n ? ((totalWesSum / totalImpressions) * 100).toFixed(2)\n : 'N/A',\n platformRankings,\n bestPost,\n worstPost\n }\n}];" }, "position": [ 5664, 3104 ] }, { "id": "e39147ed-6397-42f3-a815-7dba43dc7ef1", "name": "AI Strategy Insights", "type": "llm", "params": { "modelId": { "__rl": true, "mode": "list", "value": "gpt-4o" }, "options": { "temperature": 0.7 }, "messages": { "values": [ { "content": "=Based on this week's content performance data, provide 3 actionable recommendations for improving our social media strategy.\n\n**Overall Stats:**\n- Total Posts: {{$json.totalPosts}} ({{$json.postsWithImpressions}} with impression data, {{$json.postsWithoutImpressions}} without)\n- Avg Engagement Rate (WES): {{$json.avgEngagementRate}}%\n\n**Platform Rankings:**\n{{$json.platformRankings.map(p => `${p.name}: ${p.avgEngagementRate}% (${p.totalPosts} posts, ${p.totalImpressions} impressions)`).join('\\n')}}\n\n**Best Performing Post ({{$json.bestPost ? $json.bestPost.rate.toFixed(2) : 'N/A'}}%):**\n{{$json.bestPost ? $json.bestPost.text : 'No posts with impression data this week'}}\n\n**Worst Performing Post ({{$json.worstPost ? $json.worstPost.rate.toFixed(2) : 'N/A'}}%):**\n{{$json.worstPost ? $json.worstPost.text : 'No posts with impression data this week'}}\n\nCRITICAL OUTPUT FORMATTING:\nReturn your complete response in clean, semantic HTML format.\nUse ONLY

for section titles,
for body text, for emphasis, and
/
for action items.\nDo NOT wrap the response in markdown code blocks. Begin output directly with the first HTML tag." } ] }, "provider": "openai", "temperature": 0.7 }, "position": [ 6000, 3104 ] }, { "id": "05b5400f-9a6b-4dc1-984c-0b66afd31fea", "name": "Wait for All Branches", "type": "merge", "params": { "mode": "combine", "options": {}, "combinationMode": "mergeByPosition" }, "position": [ 6464, 2656 ] }, { "id": "0faf1bf2-e313-436c-b5a1-fb5709b88242", "name": "Combine Data & AI Output", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "1", "name": "weekStart", "type": "string", "value": "={{ $('Calculate Analytics (WES)').first().json.weekStart }}" }, { "id": "2", "name": "weekEnd", "type": "string", "value": "={{ $('Calculate Analytics (WES)').first().json.weekEnd }}" }, { "id": "3", "name": "totalPosts", "type": "number", "value": "={{ $('Calculate Analytics (WES)').first().json.totalPosts }}" }, { "id": "4", "name": "postsWithImpressions", "type": "number", "value": "={{ $('Calculate Analytics (WES)').first().json.postsWithImpressions }}" }, { "id": "5", "name": "postsWithoutImpressions", "type": "number", "value": "={{ $('Calculate Analytics (WES)').first().json.postsWithoutImpressions }}" }, { "id": "6", "name": "totalImpressions", "type": "number", "value": "={{ $('Calculate Analytics (WES)').first().json.totalImpressions }}" }, { "id": "7", "name": "avgEngagementRate", "type": "string", "value": "={{ $('Calculate Analytics (WES)').first().json.avgEngagementRate }}" }, { "id": "8", "name": "sheetErrorCount", "type": "number", "value": "={{ $('Capture Sheet Errors').all(0, 0).reduce((total, item) => total + (item.json.sheetErrorCount || 0), 0) }}" }, { "id": "9", "name": "sheetErrors", "type": "array", "value": "={{ $('Capture Sheet Errors').all(0, 0).flatMap(item => item.json.sheetErrors || []) }}" }, { "id": "10", "name": "aiInsights", "type": "string", "value": "={{ $('AI Strategy Insights').first().json.error ? '
AI insights unavailable this week: ' + $('AI Strategy Insights').first().json.error.message + '
' : ($('AI Strategy Insights').first().json.message.content || '').replace(/```html|```/g, '') }}" } ] } }, "position": [ 6720, 2656 ] }, { "id": "dcda36dd-3c67-4350-97f5-f4da2ae5d2dd", "name": "Email Weekly Report", "type": "integration", "params": { "html": "=\n\n
📊 Weekly Content Performance Report
\n
Period: {{$json.weekStart}} to {{$json.weekEnd}}
\n ={{ $json.sheetErrorCount > 0 ? '
⚠️ Warning: ' + $json.sheetErrorCount + ' post(s) failed to log to Google Sheets.
Errors: ' + ($json.sheetErrors || []).join(', ') + '
' : '' }}\n
Key Metrics
\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
Total Posts {{$json.totalPosts}}
Posts with impression data {{$json.postsWithImpressions}} / {{$json.totalPosts}}
Total Impressions {{Number($json.totalImpressions).toLocaleString()}}
Avg Engagement Rate (WES) {{$json.avgEngagementRate}}%
\n
💡 AI Strategy Recommendations
\n
\n {{$json.aiInsights}}\n
\n\n", "options": {}, "service": "smtp", "subject": "=Weekly Content Performance Report ({{$json.weekStart}} - {{$json.weekEnd}}){{$json.sheetErrorCount > 0 ? ' ⚠️ Sheet errors' : ''}}", "toEmail": "user@example.com", "fromEmail": "user@example.com", "operation": "read" }, "position": [ 6928, 2656 ] } ] }

Total Posts	{{$json.totalPosts}}
Posts with impression data	{{$json.postsWithImpressions}} / {{$json.totalPosts}}
Total Impressions	{{Number($json.totalImpressions).toLocaleString()}}
Avg Engagement Rate (WES)	{{$json.avgEngagementRate}}%

Send weekly social analytics reports with LinkedIn, X, Instagram, Google Sheets and GPT-4o