Google Maps Lead Extraction to Google Sheets (n8n)

Automatically extract Google Maps leads and log them into Google Sheets with n8n

This n8n workflow takes a Google Maps search query, pulls structured business listings via Dumpling AI, and writes each result into a row in Google Sheets—so you can build location-based lead lists without copying data manually.

What this workflow does

• Accepts a Google Maps search query (example: “best restaurants in New York”).
• Sends the query to Dumpling AI using an HTTP Request node and your API key.
• Receives a list of places returned by Dumpling AI, including business information such as:
  • Name
  • Address
  • Website
  • Phone number
  • Rating
  • Price Level, Type, Booking Link, and Position
• Splits each result into a row and appends it to your Google Sheet for clean, usable lead data.

Use cases

• Lead list building for local services (gyms, restaurants, providers) in specific cities/regions.
• Competitor tracking by repeatedly extracting listings for the same categories and locations.
• Location-specific outreach campaigns for marketers, sales teams, agencies, and virtual assistants.
• Faster research workflows when you need a spreadsheet populated from Google Maps-style searches.

Technical details

• n8n nodes/tools used: Manual Trigger, HTTP Request, Google Sheets, Split Out, Sticky Note.
• Dumpling AI integration: Sign up on Dumpling AI, create an API key, and set Header Auth in the HTTP Request node.
• Google Sheets setup: Create a tab named Leads and add headers in row 1: Name, Address, Phone number, Website, Rating, Price Level, Type, Booking Link, Position.

Get more done with a reliable Google Maps lead extraction to Google Sheets automation built for n8n.