Copy Hunter leads to Google Sheets

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

LIST_ID = 123456
SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    key, copied, leads, offset = credentials.secret("HUNTER_API_KEY"), set(state.get("copied") or []), [], 0
    while True:
        data = http.get("https://api.hunter.io/v2/leads", params={"leads_list_id": LIST_ID, "limit": 100,
                        "offset": offset, "api_key": key}).json()["data"]["leads"]
        leads += data
        if len(data) < 100:
            break
        offset += 100
    new = [l for l in leads if l["id"] not in copied]
    report_fetched(len(new))
    if not new:
        return {"new": 0}
    rows = [[l.get("first_name") or "", l.get("last_name") or "", l["email"], l.get("company") or "", l.get("position") or "",
             l.get("linkedin_url") or "", (l.get("verification") or {}).get("status") or ""] for l in new]
    build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False) \
        .spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Leads!A:G", valueInputOption="RAW",
                                        body={"values": rows}).execute()
    state.set("copied", list(copied | {l["id"] for l in new})[-5000:])
    return {"new": len(new)}