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

Sales & Estimation

Business Background Chatbot | Perplexity + Google Maps Scraper

Chatbot scrapes business contact info from Google Maps, de-duplicates, stores to Google Sheets, then enriches with emails & company backgrounds using Perplexity AI for lead generation.

Built · ~9 hours saved per week

AI-Powered Business Lead Generation and Enrichment Chatbot Automation Overview This workflow automates the entire process of lead generation and data enrichment. It starts with a simple chat conversation where a user can request to find businesses (e.g., "find gyms in Chicago"). The workflow then scrapes Google Maps for relevant businesses, intelligently checks for duplicates against an existing database in Google Sheets, adds the new unique leads, and finally enriches each new lead by automatically researching their email address and company background. This provides immense value by transforming a manual, time-consuming research task into a fully automated, conversational process, ensuring a clean, enriched, and up-to-date lead database. Technologies Used - n8n: The core automation platform coordinating all services. - LangChain: Used to build the AI Agent, which provides reasoning and tool-using capabilities. - OpenAI (gpt-4o-mini): The language model that powers the AI Agent's decision-making. - Perplexity AI: Used as a specialized research tool to find specific details like email and company background. - Google Maps (via Serper API): The data source for scraping initial business information. - Google Sheets: Acts as the database to store and manage the collected lead information. AI Integration This workflow uses AI in two distinct stages: 1. Orchestration and Initial Scraping: An AI Agent (powered by OpenAI's gpt-4o-mini and built with LangChain) acts as the central brain. When a user sends a chat message, the agent interprets the request, decides which tool to use (e.g., the Google Maps Scraper), executes it to gather data, and then uses another tool (Store to Google Sheets) to send the structured data for processing. The agent is strictly prompted to return data in a clean JSON format, ensuring data reliability for the subsequent steps. 1. Data Enrichment: After a new business is saved to Google Sheets, a secondary process uses the Perplexity AI API.

Tags: Chatbot, CRM Automations, Web Scraping, Clients/Customers/Leads, Perplexity, Admin

Integrations: AI Agent, OpenAI, Code, Google Sheets, HTTP

Related automations

Back to the Automation Library