Check new form leads with Hunter and log them in a sheet

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

SHEET_ID = "your-spreadsheet-id"

@on_event
def handle(event):
    lead = event.json or {}
    email = str(lead.get("email", "")).strip()
    if not email:
        return {"skipped": "no email"}
    key = credentials.secret("HUNTER_API_KEY")
    check = http.get("https://api.hunter.io/v2/email-verifier", params={"email": email, "api_key": key}).json().get("data") or {}
    person = http.get("https://api.hunter.io/v2/people/find", params={"email": email, "api_key": key}).json().get("data") or {}
    name = (person.get("name") or {}).get("fullName") or lead.get("name", "")
    role = (person.get("employment") or {}).get("title") or ""
    company = (person.get("employment") or {}).get("name") or ""
    row = [event.received_at[:16], name, email, check.get("status", "unknown"), role, company, lead.get("message", "")]
    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": [row]}).execute()
    if check.get("status") == "valid":
        notify.email_me(f"New lead: {name or email} ({company or 'unknown company'})",
                        f"{name}\n{role} at {company}\n{email}\n\n{lead.get('message', '')}")
    return {"status": check.get("status")}