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

Описание и применение

Программа, созданная Claude, автоматически собирает данные о сантехниках в Италии из Google Places и сохраняет их в Google Sheet, включая имена, сайты, электронные адреса и заметки о проблемах сайтов.

Задача

Need business leads without paying for a lead database.

Результат

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.

Рабочий процесс

• 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.

Доказательства

I wanted business leads without paying for a lead database.

Источник

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

Источник

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

Источник

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

Источник

Google asks for a credit card when you enable it.

Источник