Newsletter summarization & briefing with Gmail, AI, Google Sheets & Email
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: LangChain Code (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Gemini Chat Model, Gmail and Google Sheets.
How it runs
Trigger: On a schedule (every day at 09:00).
- Google Spreadsheet (Google Sheets): work with spreadsheet
- Gmail: get many
- Parse HTML-Code (Code): runs custom JavaScript code
- Split in Chunks (Code): runs custom JavaScript code
- Set Table Fields (Edit Fields (Set)): sets 4 fields: Absenderadresse, Absendername, Betreff…
- Append Row (Google Sheets): append
- Public Affairs Consultant (LangChain Code): uses LangChain Code, with model: Google Gemini Chat Model; memory: Memory
- Structure HTML-Mail (Code): runs custom JavaScript code
- Send Email: sends an email over SMTP
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- LangChain Code (legacy) in Public Affairs Consultant: no direct replacement.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| LangChain Code (legacy) Public Affairs Consultant | No direct replacement |
Nodes used (9)
- Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Send Email
n8n-nodes-base.emailSend - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - LangChain Code
@n8n/n8n-nodes-langchain.code
From the author
Your inbox is overflowing with daily newsletters: Public Affairs, ESG, Legal, Finance, you name it. You want to stay informed, but reading 10 emails every morning? Impossible. What if you could get one single digest summarizing everything that matters,…