Create personalized B2B outreach emails with Tavily Research & OpenRouter LLM
Needs changesWhat this workflow does
This AI workflow has 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, OpenRouter Chat Model and Tavily (community). It also calls api.instantly.ai over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Business card data extraction (Google Sheets): uses Google Sheets
- Limit: keeps the first few items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Company Research (AI Agent): runs an AI agent, with model: OpenRouter Chat Model; 1 tool (Tavily); output parser: Structured Output Parser
- Generate Outreach Message (Basic LLM Chain): sends a prompt to an LLM, with model: OpenRouter Chat Model
- Add Company Info to Google Sheet (Google Sheets): append or update
- Add Lead to Instantly AI (HTTP Request): calls api.instantly.ai (POST)
Services it uses
HTTP calls to: api.instantly.ai
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 Company Research (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Company Research (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - AI Agent
@n8n/n8n-nodes-langchain.agent - Tavily Tool
@tavily/n8n-nodes-tavily.tavilyTool - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Manual Trigger
n8n-nodes-base.manualTrigger - Limit
n8n-nodes-base.limit
From the author
🧠 About this workflow This workflow automatically generates personalized B2B outreach email messages by combining AI-based company research and text generation. It’s designed to help sales and marketing professionals automate the creation of tailored cold…