Log every lead in a sheet and create it in Salesforce

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from datetime import datetime, timezone
from clickruntime import on_event, credentials, http, ai

SHEET_ID = "your-spreadsheet-id"
INSTANCE = "https://yourcompany.my.salesforce.com"
API = f"{INSTANCE}/services/data/v61.0"

@on_event
def handle(event):
    lead = event.json or {}
    score = ai.generate(f"Score this lead 1-10 for fit and intent. Reply with the number only.\n"
                        f"Company: {lead.get('company')}\nMessage: {str(lead.get('message', ''))[:1500]}",
                        max_output_tokens=5).text.strip()
    headers = {"Authorization": f"Bearer {credentials.connection('salesforce', 'work')}"}
    lead_id = http.post(f"{API}/sobjects/Lead", headers=headers, json={
        "FirstName": lead.get("first_name"), "LastName": lead.get("last_name") or lead["email"],
        "Email": lead["email"], "Company": lead.get("company") or "Unknown", "Phone": lead.get("phone"),
        "LeadSource": lead.get("source") or "Web", "Description": f"{lead.get('message', '')}\n\nAI score: {score}/10"}).json()["id"]
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")),
                   cache_discovery=False).spreadsheets()
    sheets.values().append(spreadsheetId=SHEET_ID, range="Leads!A1", valueInputOption="RAW", body={"values": [[
        datetime.now(timezone.utc).strftime("%Y-%m-%d %H:%M"), lead.get("first_name", ""), lead.get("last_name", ""),
        lead["email"], lead.get("company", ""), score, f"{INSTANCE}/{lead_id}"]]}).execute()
    return {"lead": lead_id, "score": score}