Generate Personalized B2B Outreach Emails using AI Research - n8n Workflow

Sales and Marketing professionals needing to scale personalized B2B cold outreach.
Business Development teams looking to automate lead research and content creation.
Growth hackers who use platforms like Instantly.ai and require highly customized content.
Users who want to learn how to build advanced AI agents using an n8n workflow environment.

Scaling truly personalized cold outreach is challenging and time-consuming. This n8n workflow solves that problem by integrating real-time company research and advanced LLM drafting capabilities.

It takes raw lead data, uses the Tavily search n8n node via an AI agent to extract recent news and key offerings, and then passes this highly specific context to a language model (OpenRouter) to generate a unique, hyper-personalized email body. This approach ensures every prospect receives a message tailored specifically to their company's current status or focus, dramatically improving response rates compared to generic emails. It is a robust n8n templates solution for modern sales automation.

This comprehensive n8n workflow follows a five-stage logical process:

1. Trigger & Data Retrieval: The n8n workflow starts with the manual execution n8n trigger. The Get Business card data extraction Google Sheets n8n node retrieves leads marked 'ready' from a specified spreadsheet.


2. Iteration: The Loop Over Items n8n node ensures that subsequent steps, including AI research and drafting, are executed individually for every single lead item.


3. AI-Powered Company Research: The Company Research (LangChain Agent) n8n node takes the company name and website URL. It utilizes the Tavily tool and an LLM (OpenRouter) to search for specific data, such as company overview, recent website news, and key offerings, enforcing a structured JSON output via the Structured Output Parser1 n8n node.


4. Personalized Message Generation: The Generate Outreach Message (LangChain ChainLlm) n8n node receives the prospect's name and the synthesized company summary. Guided by a detailed system prompt (acting as an 'Expert B2B Cold Outreach Email Drafter'), it drafts a concise, personalized email body that hooks into the company's background. The generated message is immediately logged back into Google Sheets using the Add Company Info to Google Sheet n8n node.


5. Lead Registration: Finally, the Add Lead to Instantly AI HTTP Request n8n node sends the complete lead information, including the newly generated personalized email body (mapped to a custom variable), directly to the Instantly.ai platform for deployment in an outreach campaign.

To use this powerful n8n templates solution, follow these steps:

1. Import the n8n workflow: Copy the provided JSON code and import it into your n8n instance using the 'New' > 'Import from JSON' function.


2. Google Sheets Setup: Configure the Google Sheets n8n node (Get Business card data extraction and Add Company Info to Google Sheet) with the correct credentials and map them to your lead spreadsheet.


3. Tavily Configuration: Set up credentials for the Tavily n8n node. You will need a Tavily API key.


4. OpenRouter Configuration: Set up credentials for both OpenRouter Chat Model n8n nodes. An OpenRouter API key is required.


5. Instantly.ai Configuration: Update the Add Lead to Instantly AI HTTP Request n8n node:

1. Prompt Customization: Modify the prompt within the Generate Outreach Message n8n node to accurately describe your company, your offerings, and the specific value proposition you want to convey.


2. Testing: Execute the n8n workflow manually. Remember to remove or disable the Limit(Test) n8n node for production runs.

This n8n workflow relies on a mix of core and specialized AI integration nodes:

When clicking ‘Execute workflow’ (Manual Trigger): Serves as the starting n8n trigger for manual execution and testing of the n8n workflow.
Get Business card data extraction (Google Sheets n8n node): Fetches initial B2B lead data, filtering for items where the 'status' column equals 'ready'.
Loop Over Items (Split In Batches n8n node): This crucial control n8n node iterates over the list of leads, ensuring personalized research is done for each one.
Company Research (LangChain Agent n8n node): The core AI research component. It uses the input company name and website URL to command the Tavily tool to find specific, structured information (overview, news, offerings).
Tavily (Tavily Tool n8n node): The specific tool used by the LangChain Agent to perform real-time web research, prioritized for recency and official sources.
Structured Output Parser1 (LangChain n8n node): Ensures the complex research results from the LLM are consistently formatted into a clean JSON structure, making downstream data manipulation reliable.
Generate Outreach Message (LangChain ChainLlm n8n node): The generative LLM n8n node that drafts the email body based on the synthesized company summary, adhering to strict personalization and word count rules.
Add Company Info to Google Sheet (Google Sheets n8n node): Logs the AI-generated content (summaries and the final outreach message) back into the source spreadsheet for record-keeping and review.

• Add Lead to Instantly AI (HTTP Request n8n node): The final action, pushing the lead and the custom generated content to Instantly.ai via its API for immediate campaign integration.