Generate personalized cold email openers with website scraping using Claude & GPT-4
Needs changesWhat this workflow does
This AI workflow has 21 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive, HTTP Request, Anthropic Chat Model and OpenAI and 2 more. It also calls r.jina.ai over HTTP.
How it runs
Trigger: On Google Drive events (file created).
- Google Drive: download
- Google Sheet Parse (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- End of Loops (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: Anthropic Chat Model; 2 tools (Think, Fetch Markdown via Jina AI)
- Lead Enrichment is ready (Telegram): uses Telegram
- OpenAI: uses OpenAI, with 1 tool (Think)
- If: checks a condition and branches into true / false
- AI Agent: runs an AI agent, with model: Anthropic Chat Model; 1 tool (Think)
- AI Agent: runs an AI agent, with model: Anthropic Chat Model; 1 tool (Think)
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: r.jina.ai
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.8), AI Agent_Personalization_NO website (v1.8), AI Agent_Personalization_with website (v1.8): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
- HTTP Request Tool (legacy) in Fetch Markdown via Jina AI1: replace with HTTP Request node connected to the AI Agent's Tool input.
- Also check Spreadsheet File: Convert to File / Extract from File.
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) AI Agent (v1.8), AI Agent_Personalization_NO website (v1.8), AI Agent_Personalization_with website (v1.8) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
| HTTP Request Tool (legacy) Fetch Markdown via Jina AI1 | HTTP Request node connected to the AI Agent's Tool input |
Nodes used (14)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Spreadsheet File
n8n-nodes-base.spreadsheetFile - AI Agent
@n8n/n8n-nodes-langchain.agent - HTTP Request Tool
@n8n/n8n-nodes-langchain.toolHttpRequest - Think Tool
@n8n/n8n-nodes-langchain.toolThink - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - Telegram
n8n-nodes-base.telegram - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
This template enriches a lead list by analyzing each contact’s company website and auto-generating a single personalized cold-email opener. Drop a spreadsheet into a Google Drive folder → the workflow parses rows, fetches website content via Jina AI, uses…