Automate B2B Lead Enrichment with Tavily & Google Sheets

Automate B2B Lead Enrichment with Tavily & Google Sheets

Supercharge your B2B sales strategy with our automated workflow that transforms company names into comprehensive lead enrichment profiles, seamlessly appending them to Google Sheets for easy access and analysis. Harnessing the power of Tavily's extensive web searches and Groq's advanced AI synthesis, this workflow ensures that your sales team is equipped with the most up-to-date and actionable business insights.

What this workflow does

• Receives a POST webhook request that includes a company name and an optional domain.
• Utilizes the Tavily Search API to gather detailed company information, recent news, and insights on key people and executives.
• Employs Groq (Llama 3.3 70B) to synthesize these search results into a structured JSON-based lead enrichment profile, featuring company details, products, signals, news, pain points, and potential outreach strategies.
• Parses the structured data, flattening it into a single row-friendly format suitable for spreadsheets.
• Efficiently appends the enriched lead information to a predefined Google Sheets document, provided parsing is successful.
• Handles parsing errors by returning an HTTP 422 error response for troubleshooting with the raw AI output.

Use cases

• Boost your sales prospecting efficiency with detailed, up-to-date company profiles before initial outreach.
• Enhance your CRM with automatically enriched data fed directly into Google Sheets for dynamic lead tracking and management.
• Streamline competitive analysis by maintaining a comprehensive database of potential business partnerships or competitors.

Technical details

• Integrates with Tavily for detailed web searches and lead enrichment.
• Utilizes Groq (LLM agent) for AI-driven synthesis of structured lead profiles in JSON format.
• Optional integration with Google Sheets for data storage and management.
• Incorporates essential n8n nodes such as webhook, HTTP request, and code nodes for seamless automation.

Discover the power of this n8n automation workflow to streamline lead enrichment tasks and empower your sales team with the insights needed to make informed, strategic decisions.