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.

来源