Generate and send AI newsletters with OpenAI, Tavily, Google Sheets and Gmail
Ready for 3.0What this workflow does
This AI workflow has 25 nodes and runs when someone submits an n8n form (“Newsletter”). Along the way it connects Google Sheets, Gmail and OpenAI Chat Model. It also calls api.tavily.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Newsletter”).
- HTTP Request: calls api.tavily.com (POST)
- HTTP Request: calls an HTTP API
- HTTP Request: calls an HTTP API
- Generate Draft Topics (AI) (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Information Extractor: extracts structured fields from text with AI, with model: OpenAI Chat Model
- Split Topics (Split Out): splits a list into separate items
- Merge: merges the data from its input branches
- Tavily (HTTP Request): calls api.tavily.com (POST)
- Aggregate: combines items into one
…plus 7 more steps. See the full node list below.
Services it uses
HTTP calls to: api.tavily.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent
@n8n/n8n-nodes-langchain.agent - Split Out
n8n-nodes-base.splitOut - Aggregate
n8n-nodes-base.aggregate - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - HTTP Request
n8n-nodes-base.httpRequest - n8n Form Trigger
n8n-nodes-base.formTrigger - Merge
n8n-nodes-base.merge - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor
From the author
📨 AI Newsletter Automation Workflow 🚀 Brief Overview (How It Works) This workflow automates the complete process of generating and sending AI-powered newsletters. It starts with a form submission where the user provides a brand name, website, and topic…