Scrape Google Maps business leads with Apify & GPT-4 email extraction

Automate Scrape Google Maps Business Leads (Email, Phone, Website) using Apify 🧠 AI-Powered Business Prospecting Workflow (Google Maps + Email Enrichment) Who is this for? This workflow is designed for entrepreneurs, sales teams, marketers, and agencies who want to automate lead discovery and build qualified business contact lists — without manual searching or copying data. It’s perfect for anyone seeking an AI-driven prospecting assistant that saves time, centralizes business data, and stays fully compliant with GDPR. --- What problem is this workflow solving? Manually searching for potential clients, copying their details, and qualifying them takes hours — and often leads to messy spreadsheets. This workflow automates the process by: - Gathering publicly available business information from Google Maps - Enriching that data with AI-powered summaries and contact insights - Compiling it into a clean, ready-to-use Google Sheet database This means you can focus on closing deals, not collecting data. --- What this workflow does This automation identifies, analyzes, and organizes business opportunities in just a few steps: 1. Telegram Trigger → Send a message specifying your business type, number of leads, and Google Maps URL. 2. Apify Integration → Fetches business information from Google Maps (public data). 3. Duplicate Removal → Ensures clean, non-redundant results. 4. AI Summarization (GPT-4) → Generates concise business summaries for better understanding. 5. Email Extraction (GPT-4) → Finds and extracts professional contact emails from company websites. 6. Google Sheets Integration → Automatically stores results (name, category, location, phone, email, etc.) in a structured sheet. 7. Telegram Notification → Confirms when all businesses are processed. All data is handled ethically and transparently — only from public sources and without any unsolicited contact. --- Setup 1. Telegram Setup - Create a Telegram bot via BotFather - Copy the API token and paste it into the Telegram Trigger node credentials. 2. Apify Setup - Create an account on Apify - Get your API token and connect it to the “Run Google Maps Scraper” node. 3. Google Sheets Setup - Connect your Google account under the “Google Maps Database” node. - Specify the target spreadsheet and worksheet name. 4. OpenAI Setup - Add your OpenAI API key to the AI nodes (“Company Summary Info” and “Extract Business Email”). 5. Test - Send a Telegram message like: restaurants, 5, --- How to customize this workflow to your needs - Change search region or business type by modifying the Telegram input message format. - Adjust the number of leads via the maxCrawledPlacesPerSearch parameter in Apify. - Add filters or enrichments (e.g., websites with social links, review counts, or opening hours). - Customize AI summaries by tweaking the prompt inside the “Company Summary Info” node. - Integrate CRM tools like HubSpot or Pipedrive by adding a connector after the Google Sheets node. --- ⚙️ Expected Outcome ✅ A clean, enriched, and ready-to-use Google Sheet of businesses with: - Name, category, address, and city - Phone number and website - AI-generated business summary - Extracted professional email (if available) ✅ Telegram confirmation once all businesses are processed ✅ Fully automated, scalable, and GDPR-compliant prospecting workflow --- 💡 This workflow provides a transparent, ethical way to streamline your B2B lead research while staying compliant with privacy and anti-spam regulations. 🎥 Watch This Tutorial --- 👋 Need help or want to customize this? 📩 Contact: LinkedIn 📺 YouTube: @DRFIRASS 🚀 Workshops: Mes Ateliers n8n --- 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube / 🚀 Mes Ateliers n8n