Description
Turn location-based Google Maps searches into structured, actionable lead lists—automatically. This n8n workflow leverages Dumpling AI to extract business details and push them directly to Google Sheets, saving hours of manual effort.
Ideal for marketers, agencies, sales teams, and VAs looking to generate local business leads at scale.
🧠 How It Works:
✅ Enter a location-based search query (e.g., “cafes in Mumbai”) in the HTTP Request node ✅ Dumpling AI returns structured business listings (name, phone, website, rating, etc.) ✅ Parsed results are added to Google Sheets row-by-row ✅ Customize to run manually, on a schedule, or from a webhook
🔍 It Automates:
✅ Local business lead generation ✅ Competitor research across regions ✅ Contact list creation for outreach campaigns ✅ Conversion of unstructured Google Maps data into clean tabular format
💡 Why Choose This Workflow:
✅ Fully customizable search input ✅ Outputs clean, usable, structured leads ✅ Saves hours of repetitive copy-paste work ✅ Can be extended with filters, scoring, or GPT summarization ✅ Works out-of-the-box with Google Sheets or can be adapted to CRMs
👤 Who Is This For:
✅ Digital marketers ✅ Sales development teams ✅ Local SEO and outreach agencies ✅ Freelancers and virtual assistants ✅ Anyone targeting physical businesses by geography
🔗 Integrations:
✅ Dumpling AI (Google Maps scraper) ✅ Google Sheets (lead storage) ✅ Optional: OpenAI for summarizing leads ✅ Optional: Airtable, HubSpot, Notion, or any CRM via API
🚀 Ready to Build a Smarter Lead Engine? Set up your API key at dumplingai.com, connect your Google Sheet, and start extracting local leads in minutes.
Link : [https://lovable.dev/projects/84c021c4-61e5-485f-874e-65e4f55d6822]
