Create personalized email outreach with AI, Telegram bot & website scraping
Needs changesWhat this workflow does
This AI workflow has 50 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Telegram, OpenAI, OpenAI Chat Model and Postgres Chat Memory and 3 more.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Get row(s) (Data table): get
- If: checks a condition and branches into true / false
- Delete row(s) (Data table): delete rows
- Check how many email created by id (Data table): get
- Edit Fields (Edit Fields (Set)): sets 2 fields: chatInput, sessionId
- calculate how many session (Aggregate): combines items into one
- RAG AI Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 4 tools (List Documents, Get File Contents, Query Document Rows, Postgres PGVector Store); memory: Postgres Chat Memory
- set maximum email per id (Switch): routes items into 2 branches
- answer query (Telegram): uses Telegram
- apologize message (Telegram): uses Telegram
…plus 31 more steps. See the full node list below.
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:
- AI Agent v1 (old agent modes) in RAG AI Agent (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) RAG AI Agent (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (22)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Markdown
n8n-nodes-base.markdown - OpenAI
@n8n/n8n-nodes-langchain.openAi - Split Out
n8n-nodes-base.splitOut - Aggregate
n8n-nodes-base.aggregate - Send Email
n8n-nodes-base.emailSend - Data table
n8n-nodes-base.dataTable - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Postgres Chat Memory
@n8n/n8n-nodes-langchain.memoryPostgresChat - AI Agent
@n8n/n8n-nodes-langchain.agent - Postgres Tool
n8n-nodes-base.postgresTool - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Postgres PGVector Store
@n8n/n8n-nodes-langchain.vectorStorePGVector - XML
n8n-nodes-base.xml - Telegram
n8n-nodes-base.telegram - Switch
n8n-nodes-base.switch - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge
From the author
Demo Personalized Email This n8n workflow is built for AI and automation agencies to promote their workflows through an interactive demo that prospects can try themselves. The featured system is a deep personalized email demo. --- 🔄 How It Works 1. Prospect…