How to build a lead list of every roofer in a city, past the Google Maps cap
Description and use
A Python script leverages SpecStream’s API to bypass Google Maps’ 120‑result limit and produce a CSV of small roofers in Columbus, Ohio, meeting specified rating and review thresholds.
Problem
Google Maps limits visible roofers to about 120 results, blocking access to smaller, potentially more responsive businesses.
Outcome
The script retrieves a list of qualifying roofers in CSV format, overcoming Google Maps’ result cap.
Workflow
- Read the query sentence via SpecStream /v1/parse
- Get a price quote via /v1/capacity/quotes
- Approve the quote if within budget
- Execute the find via /v1/capacity/executions
- Poll /v1/finds/{find_id}/rows until status is finished
- Iterate pages of rows to collect all results
- Write results to CSV
Evidence
Search Google Maps for "roofers in Columbus, Ohio" and scroll. The list stops after roughly 120 places
So here's the list I wanted: Roofers in Columbus, Ohio, rated 4.5 or better with fewer than 20 Google reviews, with their phone number and website
You need an API key from specstream.ai (under Agents & API). New accounts get $10 of work free, no card.
- Record date: 2026-10-16T05:55:59.345Z