Free Google Maps Leads Into a Spreadsheet: I Had Claude Build the Scraper

Description and use

Claude-generated program automatically scrapes plumber leads in Italy from Google Places and stores them in a Google Sheet, including names, websites, emails, and site issue notes.

Problem

Need business leads without paying for a lead database.

Outcome

Program automatically pulls plumber leads in Italy, populating a Google Sheet with names, websites, emails, and site issue notes; no outreach performed in this run.

Workflow

• 1. Define niche and location in a brief.
• 2. Set up Google Cloud project with OAuth for Sheets, Drive, Docs, Gmail, YouTube Data API v3, and Places API (New).
• 3. Provide OAuth client JSON to Claude and Google Sheet link.
• 4. Prompt Claude to build program based on brief.
• 5. Run program to scrape Google Places API for specified niche and location.
• 6. Output results to Google Sheet.
• 7. If emails missing, prompt Claude again to add emails and site notes.
• 8. (Optional) Spot‑check leads and send cold emails via Gmail.

Evidence

I wanted business leads without paying for a lead database.

Source

Claude built it from my brief and asked follow-up questions

Source

The first pass returned company names and websites but no emails.

Source

The second pass found emails and added notes on site problems (placeholder carousel text, missing contact forms)

Source

Google asks for a credit card when you enable it.

Source