Live Preview
Working Duration
Category
Client
This project is an intelligent automation that completely streamlines the process of finding and collecting local business leads. The primary goal was to create a tool that could take a simple, natural language request from a user on Telegram and turn it into a structured, actionable list of business contacts.
The user journey is incredibly simple: send a voice note or text message like “find me roofing companies in Miami, Florida.” The bot transcribes the voice if needed, uses an AI model to extract the key search terms, and then deploys a web scraper to gather data from Google Maps. The scraped information, including names, addresses, phone numbers, and emails, is automatically populated into a Google Sheet, and the user is notified with a link to the results. The entire workflow is orchestrated in n8n, integrating Telegram, OpenAI, Google Gemini, Apify, and Google Sheets.
150 Leads Per Query The Apify web scraping module is configured to find and crawl up to 150 unique businesses for every user request.
4 Key Data Points Captured The bot automatically scrapes and saves the most critical contact information for each lead: Business Name, Address, Phone Number, and Email.
Voice & Text Ready Command Interface Accepts user input via both typed messages and voice notes, which are transcribed into text using OpenAI’s Whisper model.
Automated Cloud Storage All collected leads are instantly and automatically saved to a dedicated Google Sheet, creating a permanent and easily accessible database.
This bot combines a simple interface with a powerful backend process, abstracting complex technical steps away from the end-user.
Conversational Command Interface: The workflow is initiated from a Telegram chat. It can seamlessly handle both standard text messages and audio-based commands by first running them through OpenAI’s transcription service.
Natural Language Query Processing: The transcribed text is sent to a Google Gemini-powered Information Extractor. This AI node intelligently parses the user’s sentence to identify the two critical variables needed for the search: the business niche (e.g., “Marketing Agency”) and the geographical location.
Automated Google Maps Scraping: The core of the workflow is an HTTP request to an Apify actor specializing in Google Places scraping. This is a robust, server-side process that executes the targeted search and extracts detailed contact information for each business listing it finds.
Automatic Google Sheets Integration: As the scraper collects leads, the workflow iterates through each one and appends the data as a new row in a pre-configured Google Sheet. This creates an organized, ready-to-use lead list without any manual data entry. The user is then sent a direct link to this sheet.
The primary problem this bot solves is the incredibly time-consuming and manual process of finding local business leads. Conventionally, this requires someone to search Google Maps, click on each business, and manually copy-paste their contact details into a spreadsheet. This is a multi-hour task prone to human error.
The solution is an end-to-end automation that abstracts this entire process behind a simple chat interface. Architecturally, the key was to chain several best-in-class APIs together: Telegram for the user interface, OpenAI for voice processing, Google Gemini for natural language understanding, Apify for the heavy-lifting of web scraping, and Google Sheets for persistent, user-friendly data storage. This modular approach allows each component to handle a specific task efficiently, creating a powerful and seamless workflow.
This tool transforms a tedious, multi-hour manual task into a simple command that takes less than a minute to issue. It empowers non-technical users—such as sales professionals, marketers, or small business owners—to quickly generate highly targeted local lead lists on demand.
By delivering the clean, structured data directly into a Google Sheet, the bot provides an immediately actionable asset. This list can be used for sales outreach campaigns, market research, or as the foundation for a more comprehensive CRM database. It’s a practical tool that provides clear, measurable value by saving time and accelerating the sales pipeline.
