')\n \n // Einzelne Zeilenumbrüche =
\n .replace(/\n/g, '
')\n \n // Wrap Listen in

\n .replace(/(
• .*?
)/gs, '
$1
')\n \n // Wrap Text in Paragraphen (nur wenn noch nicht wrapped)\n .replace(/^(?!<[pu])/gm, '

')\n .replace(/(?)$/gm, '

');\n}\n\nconst json = $input.item.json;\n\n// HTML Template mit Markdown-Konvertierung\nconst html = `\n\n\n \n\n\n

Newsletter Briefing

\n \n
\n 📊 Analysierte Newsletter: ${json.newslettersAnalyzed}
\n 📅 Datum: ${json.date}\n
\n\n

Executive Summary

\n
${markdownToHtml(json.executiveSummary)}
\n\n

Hauptthemen

\n ${json.majorThemes ? json.majorThemes.map(t => `\n
\n
${t.theme}
\n ${markdownToHtml(t.description)}\n
Erwähnt in: ${t.mentionedIn ? t.mentionedIn.join(', ') : 'N/A'}
\n
Strategische Bedeutung: ${markdownToHtml(t.strategicImportance)}
\n
\n `).join('') : '

Keine Themen verfügbar

'}\n\n

Stakeholder-Analyse

\n
${markdownToHtml(json.stakeholderAnalysis)}
\n\n

Übergreifende Erkenntnisse

\n
${markdownToHtml(json.crossCuttingInsights)}
\n\n

Strategische Implikationen

\n
${markdownToHtml(json.strategicImplications)}
\n\n

Empfohlene Aktionen

\n ${json.recommendedActions ? json.recommendedActions.map((a, i) => `\n
${i+1}. ${a}
\n `).join('') : '

Keine Aktionen

'}\n\n

Offene Fragen

\n ${json.gapsAndQuestions ? json.gapsAndQuestions.map((q, i) => `\n
${i+1}. ${q}
\n `).join('') : '

Keine offenen Fragen

'}\n\n
\n Automatisch generiert durch KI-Analyse | ${json.newslettersAnalyzed} Quellen\n
\n\n`;\n\nreturn [{ json: { ...json, html } }];"},"typeVersion":2},{"id":"82ec1fd7-354c-4115-b27e-0efe0c108b81","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[-880,-176],"parameters":{"width":400,"height":320,"content":"## Overview\n\n**Step 1:** Collect: Fetch ~10 newsletters from Gmail and strip HTML noise.\n**Step 2:** Organize: Chunk long texts (token-safe), log chunks + metadata to Google Sheets.\n**Step 3:** Summarize & Send: An LLM creates a concise daily digest (key topics, implications, actions), builds an HTML email, and sends it to stakeholders.\n\n**Note:** This template is not limited to Public Affairs. Swap the prompt and filters to use it for Legal, ESG, Finance, Marketing, Competitive Intel, etc."},"typeVersion":1},{"id":"68c78878-0678-4500-85cf-40e842090ff9","name":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[-304,-240],"parameters":{"width":432,"height":464,"content":"## Group A – Timing & Destination\n\n**When & where**\n• Runs daily at the set time.\n• Creates/updates a Google Sheet to store raw text + metadata.\n\nCustomize: Interval/time; sheet name/tab."},"typeVersion":1},{"id":"aa154741-1d13-4eba-ab88-0df4a5bc8ade","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[160,-304],"parameters":{"width":1088,"height":528,"content":"## Inbox, Pre-Clean & Chunking \n\n**Collect & sanitize**\n• Pulls the 10 target newsletters via Gmail query.\n• Removes HTML clutter, trackers, inline styles → clean plain text.\n\n**Customize:** Gmail query (e.g., label:PA-News newer_than:1d), sender/subject filters.\n\n**Token-safe structuring**\n• Splits long bodies into manageable chunks.\n• Maps fields (date, source, subject, chunk id, text).\n\n**Customize:** Chunk size, field names, destination sheet/tab."},"typeVersion":1},{"id":"4a01fa46-b13f-4fe8-be15-2220af449f28","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[1312,-304],"parameters":{"width":528,"height":688,"content":"## LLM Policy Digest\n\n**Create the daily brief**\n• Merges chunks into one digest with: Top topics, EU/DE relevance, risks/opportunities, action items.\n• Memory saves content when you want to analyze the newsletters over a longer period of time.\n\nCustomize: System prompt (tone, depth, output format), temperature/tokens, memory scope.\n\nReuse beyond PA: Change the prompt to Legal, ESG, Finance, Competitive Intel, Marketing, etc."},"typeVersion":1},{"id":"739d7e59-6b61-4436-a46f-2f88d2530a91","name":"Sticky Note4","type":"n8n-nodes-base.stickyNote","position":[1888,-208],"parameters":{"width":496,"height":416,"content":"Build & Send Email \n\n**Deliver the digest**\n• Generates a clean HTML email (headline, TL;DR, bullets, sources).\n• Sends to the PA Director/team (add CC/BCC as needed).\nCustomize: Recipients, subject , branding.)"},"typeVersion":1}],"active":false,"pinData":{},"settings":{"executionOrder":"v1"},"connections":{"Gmail":{"main":[[{"node":"Parse HTML-Code","type":"main","index":0}]]},"Memory3":{"ai_memory":[[{"node":"Public Affairs Consultant","type":"ai_memory","index":0}]]},"Append Row":{"main":[[{"node":"Public Affairs Consultant","type":"main","index":0}]]},"Parse HTML-Code":{"main":[[{"node":"Split in Chunks","type":"main","index":0}]]},"Split in Chunks":{"main":[[{"node":"Set Table Fields","type":"main","index":0}]]},"Schedule Trigger":{"main":[[{"node":"Google Spreadsheet","type":"main","index":0}]]},"Set Table Fields":{"main":[[{"node":"Append Row","type":"main","index":0}]]},"Google Spreadsheet":{"main":[[{"node":"Gmail","type":"main","index":0}]]},"Structure HTML-Mail":{"main":[[{"node":"Send email","type":"main","index":0}]]},"Google Gemini Chat Model":{"ai_languageModel":[[{"node":"Public Affairs Consultant","type":"ai_languageModel","index":0}]]},"Public Affairs Consultant":{"main":[[{"node":"Structure HTML-Mail","type":"main","index":0}]]}}}