Create personalized B2B outreach emails with Tavily Research & OpenRouter LLM
n8n12 modulesv1.0About 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 emails for prospects. --- ⚙️ How it works 1. Get rows from Google Sheets — Retrieves companies marked as “ready” for outreach. 2. Loop Over Items — Processes each company individually. 3. Company Research (LangChain Agen
At a glance
Create personalized B2B outreach emails with Tavily Research & OpenRouter LLM is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets
- Modules
- 12
- Price
- Free
- Version
- v1.0
About this workflow
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 emails for prospects. --- ⚙️ How it works 1. Get rows from Google Sheets — Retrieves companies marked as “ready” for outreach. 2. Loop Over Items — Processes each company individually. 3. Company Research (LangChain Agent) — Uses the Tavily search tool to collect key company insights such as overview, offerings, and recent news. 4. Generate Outreach Message (LLM Chain) — Drafts a professional, concise, and fully personalized email body in English using the AI training context from YOURCOMPANYNAME. This example uses an AI training and automation service context, but you can easily modify the prompt to fit your own company’s products, services, or industry. 5. Add to Google Sheets — Writes the generated messages back into the sheet. 6. (Optional) Add to Instantly.ai — Sends the finalized lead data to your Instantly campaign for cold email distribution. --- 👥Use Cases 💼Sales & CRM:Automatically build and update your client database from received business cards 🏢Back Office & Admin: Digitize incoming cards for unified company records 📧Marketing Teams: Collect and manage leads efficiently 📚 AI / OCR Research: Build structured datasets for training AI models or internal automation --- 🧩 Troubleshooting If the workflow does not generate emails or data fails to appear in Google Sheets, please check the following: 1. Google Sheets credentials — Ensure that the connected account has edit permissions and the document ID and sheet name are correctly set. 2. API keys — Verify that your OpenRouter and Tavily API credentials are valid and not expired. 3. Rate limits — Tavily and OpenRouter may throttle requests when processing multiple records. Try lowering the batch size in the “Limit” node. 4. Empty company background — If the “Company Research” node returns no output, make sure the input company name is correct and includes sufficient context (e.g., full company name, not abbreviation). 5. LLM output format — Ensure the “Generate Outreach Message” node is set to return plain text, not JSON or markdown. 6. Instantly.ai integration (optional) — If leads are not added, confirm that your API key and campaign ID are valid, and that the node is not disabled. If the issue persists, enable “Always Output Data” in key nodes (such as Company Research and Generate Outreach Message) to debug intermediate results. You can also use the Execution Log to inspect where the flow stops or returns an empty output. --- ⚠️ Disclaimer This workflow uses AI language models and third-party APIs (OpenRouter, Tavily). Ensure that you add your own API credentials securely and verify all AI-generated content before sending emails.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
AI automate UX feedback: Sentiment & emotion analysis in Google Sheets + OpenAI
Save a Gmail email containing a specific phrase to Google Sheets as a new row
Send custom email notifications to ChatGPT and log results in Google Sheets
Score and auto-reply to new leads with OpenAI and Gmail
AI-powered Instagram content repurposing with OpenAI GPT-4O & Perplexity Research
Organize Feedly articles by local/national with ChatGPT and add to Google Sheets 1/2
Automate Morning Brew–style Reddit Digests and Publish to DEV using AI
Automated SEO keyword & SERP analysis with DataForSEO for high-converting content
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you