✨ $500 AI Visibility Audit — live at Spurlock Studios. Book the audit

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

Related automations

Back to the Automation Library