Collect local business leads from Google Maps into a sheet

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, state, notify

SHEET_ID = "your-spreadsheet-id"
SEARCH = "dentists in Austin, TX"

@on_trigger
def run(event):
    seen = set(state.get("place_ids") or [])
    rows = []
    for start in range(0, 100, 20):
        res = http.get("https://serpapi.com/search", params={"engine": "google_maps", "q": SEARCH, "start": start,
                                                             "api_key": credentials.secret("SERPAPI_API_KEY")}).json()
        for p in res.get("local_results", []):
            if p["place_id"] not in seen:
                seen.add(p["place_id"])
                rows.append([p["title"], p.get("address", ""), p.get("phone", ""), p.get("website", ""), p.get("rating", "")])
        if "next" not in res.get("serpapi_pagination", {}):
            break
    if rows:
        sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
        sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Leads!A:E", valueInputOption="RAW", body={"values": rows}).execute()
    state.set("place_ids", list(seen))
    notify.email_me(f"{len(rows)} new leads: {SEARCH}", "\n".join(r[0] for r in rows) or "No new businesses this week.")
    return {"added": len(rows)}