${SITE_NAME} Weekly Digest — ${newsletterData.newsletter

{ "edges": [ { "to": "b3ef1468-3c0a-4894-929a-a3fc7e76c25d", "from": "14ae5a50-eab2-4b63-a356-5e1bd2d49a9f", "toPort": "0", "fromPort": "0" }, { "to": "14ae5a50-eab2-4b63-a356-5e1bd2d49a9f", "from": "cb73ccc2-b98d-4b34-bb2b-9233e7423743", "toPort": "0", "fromPort": "0" }, { "to": "b3ef1468-3c0a-4894-929a-a3fc7e76c25d", "from": "e96b1eb2-a24f-44e9-af9b-7e6ef88ab8c8", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "7c645b92-1b67-4f42-ad62-3a8f394caf63", "from": "b40318c1-13f7-4684-984b-06ec9be18d7e", "toPort": "0", "fromPort": "0" }, { "to": "cb73ccc2-b98d-4b34-bb2b-9233e7423743", "from": "ec44e757-629b-4195-b1e2-9b6715132d4b", "toPort": "0", "fromPort": "0" }, { "to": "b40318c1-13f7-4684-984b-06ec9be18d7e", "from": "f6df18c8-c9fa-4555-b4b4-a653b5a92cc3", "toPort": "0", "fromPort": "0" }, { "to": "f6df18c8-c9fa-4555-b4b4-a653b5a92cc3", "from": "b3ef1468-3c0a-4894-929a-a3fc7e76c25d", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "ec44e757-629b-4195-b1e2-9b6715132d4b", "name": "Weekly Schedule", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "weeks", "triggerAtDay": [ 1 ], "triggerAtHour": 10 } ] } }, "position": [ 16, -288 ] }, { "id": "cb73ccc2-b98d-4b34-bb2b-9233e7423743", "name": "Fetch WP Posts", "type": "http", "params": { "url": "https://YOUR-WORDPRESS-SITE.com/wp-json/wp/v2/posts", "options": {}, "sendQuery": true, "queryParameters": { "parameters": [ { "name": "_embed", "value": "wp:featuredmedia" }, { "name": "after", "value": "={{ $now.minus({ days: 7 }).toISO() }}" }, { "name": "per_page", "value": "20" }, { "name": "orderby", "value": "date" }, { "name": "order", "value": "desc" } ] } }, "position": [ 192, -288 ] }, { "id": "14ae5a50-eab2-4b63-a356-5e1bd2d49a9f", "name": "Process Posts", "type": "code", "params": { "jsCode": "// Process WordPress posts with embedded featured media\n// Mode: Run Once for All Items — aggregates all posts into single output\n// Returns structured articles with imageUrl for newsletter thumbnails\n\nconst inputItems = $input.all();\nlet posts = [];\n\nfor (const item of inputItems) {\n const data = item.json;\n if (Array.isArray(data)) {\n posts.push(...data);\n } else if (data && typeof data === 'object') {\n posts.push(data);\n }\n}\n\nlet articles = [];\n\nconst toISO = (ts) => {\n if (!ts) return new Date().toISOString();\n try {\n if (typeof ts === 'number') return new Date(ts < 1e12 ? ts * 1000 : ts).toISOString();\n return new Date(ts).toISOString();\n } catch { return new Date().toISOString(); }\n};\n\nconst stripTags = (html) => {\n if (!html) return '';\n return String(html)\n .replace(//gi, '')\n .replace(//gi, '')\n .replace(/<[^>]+>/g, '')\n .replace(/\\s+/g, ' ')\n .trim();\n};\n\nconst decodeHTMLEntities = (text) => {\n if (!text) return '';\n const map = { '&':'&','<':'<','>':'>','"':'\"',''':\"'\",' ':' ' };\n return text\n .replace(/(&|<|>|"|'| )/g, m => map[m])\n .replace(/(\\d+);/g, (_, n) => String.fromCharCode(parseInt(n,10)))\n .replace(/([0-9a-fA-F]+);/g, (_, n) => String.fromCharCode(parseInt(n,16)));\n};\n\nconst clean = (s) => decodeHTMLEntities(stripTags(s || ''));\n\nconst getImageUrl = (post) => {\n try {\n const embedded = post._embedded?.['wp:featuredmedia'];\n if (embedded && embedded[0]) {\n const sizes = embedded[0].media_details?.sizes;\n if (sizes) {\n return sizes.medium_large?.source_url || sizes.medium?.source_url || sizes.thumbnail?.source_url || embedded[0].source_url || '';\n }\n return embedded[0].source_url || '';\n }\n if (post.jetpack_featured_media_url) return post.jetpack_featured_media_url;\n if (post.featured_media_src_url) return post.featured_media_src_url;\n if (post.yoast_head_json?.og_image?.[0]?.url) return post.yoast_head_json.og_image[0].url;\n return '';\n } catch { return ''; }\n};\n\nconst getCategories = (post) => {\n const categories = [];\n try {\n if (post._embedded?.['wp:term']) {\n post._embedded['wp:term'].flat().forEach(t => {\n if (t.taxonomy === 'category' && t.name) categories.push(decodeHTMLEntities(t.name));\n });\n }\n } catch {}\n return categories.length ? categories : ['Technology'];\n};\n\nfor (const p of posts) {\n const titleRaw = p?.title?.rendered ?? p?.title ?? '';\n const url = p?.link ?? p?.guid?.rendered ?? p?.guid ?? '';\n if (!titleRaw || !url) continue;\n\n const excerptRaw = p?.excerpt?.rendered ?? '';\n const contentRaw = p?.content?.rendered ?? '';\n const publishedAt = toISO(p?.date_gmt ?? p?.date);\n const imageUrl = getImageUrl(p);\n const categories = getCategories(p);\n\n articles.push({\n title: clean(titleRaw),\n description: clean(excerptRaw || contentRaw || titleRaw).slice(0, 500),\n url,\n imageUrl,\n source: 'WordPress',\n publishedAt,\n categories,\n score: 0,\n });\n}\n\nconst seen = new Set();\narticles = articles.filter(a => {\n const key = a.url || 't:' + a.title;\n if (seen.has(key)) return false;\n seen.add(key);\n return true;\n});\n\narticles.sort((a, b) => new Date(b.publishedAt).getTime() - new Date(a.publishedAt).getTime());\narticles = articles.slice(0, 12);\n\nreturn [{ json: { articles, totalResults: articles.length, sources: ['WordPress'] } }];" }, "position": [ 352, -288 ] }, { "id": "e96b1eb2-a24f-44e9-af9b-7e6ef88ab8c8", "name": "LLM — GPT-4o", "type": "llm", "params": { "model": "gpt-4o", "options": { "maxTokens": 4000, "temperature": 0.7 }, "provider": "openai", "maxTokens": 4000, "temperature": 0.7 }, "position": [ 512, -96 ] }, { "id": "b3ef1468-3c0a-4894-929a-a3fc7e76c25d", "name": "AI — Generate Summaries", "type": "llm", "params": { "text": "=Based on the following recent blog articles, create concise summaries of each article:\n\nNews Data: {{ JSON.stringify($json.articles?.slice(0, 12)) }}\n\nRequirements:\n- Write 3–5 sentence professional summaries for each article\n- Clearly explain the main topic and practical relevance for readers\n- Use plain, engaging language that is easy to scan\n- Include the article's title as the headline\n- IMPORTANT: Copy the exact 'url' and 'imageUrl' fields from the input data — do not modify these URLs\n- Include the category from the input data\n\nReturn as JSON with this exact structure:\n{\n \"articles\": [\n {\n \"headline\": \"Article Title Here\",\n \"summary\": \"3-5 sentence summary...\",\n \"url\": \"https://example.com/post-slug\",\n \"imageUrl\": \"https://example.com/image.jpg\",\n \"category\": \"Category Name\",\n \"date\": \"2025-01-01\",\n \"word_count\": 150\n }\n ],\n \"newsletter_date\": \"{{ $now.format('MMMM d, yyyy') }}\",\n \"overview\": \"Brief overview of this week's key themes (2-3 sentences)\"\n}\n\nIMPORTANT: The imageUrl must be copied exactly as provided in the input — these are required for newsletter thumbnails.", "prompt": "=Based on the following recent blog articles, create concise summaries of each article:\n\nNews Data: {{ JSON.stringify($json.articles?.slice(0, 12)) }}\n\nRequirements:\n- Write 3–5 sentence professional summaries for each article\n- Clearly explain the main topic and practical relevance for readers\n- Use plain, engaging language that is easy to scan\n- Include the article's title as the headline\n- IMPORTANT: Copy the exact 'url' and 'imageUrl' fields from the input data — do not modify these URLs\n- Include the category from the input data\n\nReturn as JSON with this exact structure:\n{\n \"articles\": [\n {\n \"headline\": \"Article Title Here\",\n \"summary\": \"3-5 sentence summary...\",\n \"url\": \"https://example.com/post-slug\",\n \"imageUrl\": \"https://example.com/image.jpg\",\n \"category\": \"Category Name\",\n \"date\": \"2025-01-01\",\n \"word_count\": 150\n }\n ],\n \"newsletter_date\": \"{{ $now.format('MMMM d, yyyy') }}\",\n \"overview\": \"Brief overview of this week's key themes (2-3 sentences)\"\n}\n\nIMPORTANT: The imageUrl must be copied exactly as provided in the input — these are required for newsletter thumbnails.", "options": { "systemMessage": "You are an expert technology journalist. Your role is to transform WordPress blog posts into short, professional summaries that readers can quickly scan and understand. Write in a clear, engaging, and concise style that highlights the key message and practical relevance of each article.\n\nCRITICAL: Always preserve the exact 'url' and 'imageUrl' values from the input data — never modify, summarise, or omit these fields. They are essential for the newsletter layout." }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "You are an expert technology journalist. Your role is to transform WordPress blog posts into short, professional summaries that readers can quickly scan and understand. Write in a clear, engaging, and concise style that highlights the key message and practical relevance of each article.\n\nCRITICAL: Always preserve the exact 'url' and 'imageUrl' values from the input data — never modify, summarise, or omit these fields. They are essential for the newsletter layout." }, "position": [ 512, -288 ] }, { "id": "f6df18c8-c9fa-4555-b4b4-a653b5a92cc3", "name": "Format HTML Email", "type": "code", "params": { "mode": "runOnceForEachItem", "jsCode": "// ─────────────────────────────────────────────\n// FORMAT NEWSLETTER HTML\n// Renders AI summaries into a branded HTML email\n// ─────────────────────────────────────────────\n// CUSTOMISE: Update SITE_NAME, SITE_URL, LOGO_URL,\n// BRAND_NAVY, BRAND_ORANGE, CTA_URL, and CTA_TEXT below.\n\nconst SITE_NAME = 'YOUR COMPANY NAME'; // ← customise\nconst SITE_URL = 'https://YOUR-SITE.com'; // ← customise\nconst LOGO_URL = 'https://YOUR-SITE.com/wp-content/uploads/logo.png'; // ← customise\nconst BRAND_NAVY = '#002657';\nconst BRAND_ORANGE = '#FA4616';\nconst CTA_URL = 'https://YOUR-SITE.com/contact'; // ← customise\nconst CTA_TEXT = 'Schedule a Consultation'; // ← customise\n\n// ─── Parse AI output ───\nconst aiResponse = $json.output || $json.data || '';\nlet newsletterData;\n\nfunction safeJSONStringParse(s) {\n if (!s) return null;\n try {\n const match = s.match(/\\{[\\s\\S]*\\}/);\n return match ? JSON.parse(match[0]) : null;\n } catch { return null; }\n}\n\nnewsletterData = safeJSONStringParse(aiResponse);\n\nif (!newsletterData || !Array.isArray(newsletterData.articles)) {\n newsletterData = {\n articles: [{\n headline: 'This Week on Our Blog',\n summary: (aiResponse || 'No AI summary available.').toString().slice(0, 600) + '…',\n url: '',\n imageUrl: '',\n category: 'Technology',\n date: '',\n word_count: 0,\n }],\n newsletter_date: new Date().toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' }),\n overview: 'Highlights from our latest blog posts.',\n };\n}\n\n// ─── Helpers ───\nfunction formatDateHuman(input) {\n if (!input) return '';\n const d = new Date(input);\n if (isNaN(d.getTime())) return String(input);\n return d.toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' });\n}\n\nfunction renderArticleCard(a, index) {\n const hasImage = a.imageUrl && a.imageUrl.trim() !== '';\n const cat = a.category || 'Technology';\n const dateTxt = formatDateHuman(a.date || a.publishedAt || a.published_at || '');\n const metaParts = [cat, dateTxt].filter(Boolean).join(' • ');\n const imageUrl = hasImage ? a.imageUrl : LOGO_URL;\n const summary = (a.summary || '').toString().replace(/\\n+/g, ' ').trim();\n\n return `\n \n \n \n \n \n \n \n \n \n

\n \n

\n $\"${(a.headline||'Article').replace(/\"/g,'"')}\"$ \n

\n \n

${metaParts}

\n \n

${a.headline||'Untitled Article'}

\n \n

${summary}

\n ${a.url ? `Read full article →` : ''}\n

\n \n `;\n}\n\n// ─── Build HTML ───\nconst newsletterHtml = `\n\n\n\n \n \n \n ${SITE_NAME} Weekly Digest — ${newsletterData.newsletter_date}\n \n\n\n \n \n \n

\n \n\n \n \n \n \n\n \n \n \n \n\n \n \n \n \n\n \n \n \n \n\n \n \n \n \n\n

\n $\"${SITE_NAME}$ \n

Weekly Digest

Your weekly roundup of the latest articles

${newsletterData.newsletter_date}

\n \n \n

📋 This Week's Overview

${newsletterData.overview||'Explore our latest articles.'}

\n \n ${newsletterData.articles.map((a,i) => renderArticleCard(a,i)).join('')}\n

\n \n \n \n \n

\n ${CTA_TEXT}\n

${SITE_NAME}

Keeping you informed every week

\n Website\n •\n Unsubscribe\n

\n \n\n`;\n\nreturn {\n newsletter_html: newsletterHtml,\n newsletter_date: newsletterData.newsletter_date,\n article_count: Array.isArray(newsletterData.articles) ? newsletterData.articles.length : 0,\n overview: newsletterData.overview || '',\n articles: newsletterData.articles,\n};" }, "position": [ 784, -288 ] }, { "id": "7c645b92-1b67-4f42-ad62-3a8f394caf63", "name": "Send Newsletter", "type": "integration", "params": { "sendTo": "={{ $json.Email }}", "message": "={{ $('Format HTML Email').first().json.newsletter_html }}", "options": { "senderName": "YOUR COMPANY Newsletter", "appendAttribution": false }, "service": "gmail", "subject": "=Weekly Digest — {{ $('Format HTML Email').first().json.newsletter_date }}", "operation": "read" }, "position": [ 1184, -288 ] }, { "id": "b40318c1-13f7-4684-984b-06ec9be18d7e", "name": "Get Subscribers", "type": "integration", "params": { "options": {}, "service": "googleSheets", "filtersUI": { "values": [ { "lookupValue": "Yes", "lookupColumn": "Active" } ] }, "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/18tsSavciwUeXpLIiSk71Csv8C_i3ydZIeIckvYQlUPc/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "18tsSavciwUeXpLIiSk71Csv8C_i3ydZIeIckvYQlUPc", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/18tsSavciwUeXpLIiSk71Csv8C_i3ydZIeIckvYQlUPc/edit?usp=drivesdk", "cachedResultName": "DEMO CRM" } }, "position": [ 992, -288 ] } ] }

Send a weekly AI‑written WordPress blog digest via Gmail using GPT-4o