Sales & Estimation
CRM Lead Research w Tavily
This n8n workflow automates CRM lead research and personalized outreach. It pulls lead data from Google Sheets, uses an OpenAI (GPT-4.1) AI Agent with Tavily for company research (overview, tech stack), and a Google Sheet (Product List) for solution identification. A second…
Built · ~4.5 hours saved per week
CRM Lead Research & Outreach Automation
This workflow automates the entire sales preparation process for new leads or meetings. It operates in two distinct AI-driven stages: first, it researches and enriches lead data, and second, it uses that enriched data to draft hyper-personalized outreach communications (email and SMS). The entire process is designed to transform a basic lead entry into a fully prepared, actionable sales opportunity, logging all results back into a Google Sheet which acts as a lightweight CRM.
Technologies Used
- Google Sheets: Functions as the primary database (CRM) for storing lead information, product lists, and customer testimonials. - OpenAI: The GPT-4.1 model provides the intelligence for the two AI agents that power the workflow. - Tavily AI: A specialized search API used by the first AI agent to perform real-time, in-depth web research on companies. - n8n AI Agents: The core of the workflow, coordinating the models and tools to perform complex, multi-step tasks.
Automation Overview
This workflow provides immense value by automating the time-consuming and manual tasks of pre-call research and initial outreach. Instead of a sales representative spending hours gathering information and drafting emails for each new lead, this system does it automatically.
1. Lead Enrichment: It takes a new lead (e.g., from a booking form) and automatically researches the company, their technology, and recent news, providing instant context. 2. Solution Matching: It intelligently cross-references the lead's needs with an internal product list to suggest relevant solutions. 3. Personalized Outreach: It crafts human-like, personalized emails and SMS messages that incorporate the research findings and relevant customer testimonials, dramatically increasing the quality and relevance of the first touchpoint. 4. Centralized Data: All generated insights and communications are automatically logged back into the Google Sheet, creating a single source of truth for the sales team.
Tags: CRM, Web Scraping, Clients/Customers/Leads, Perplexity, AI Automation, Multi-Agent Chain
Integrations: AI Agent, OpenAI, HTTP, Google Sheets