Turn new rows in a sheet into Trello cards

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

SHEET_ID = "your-spreadsheet-id"
LIST_ID = "your-trello-list-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    last = state.get("last_row") or 1
    rows = sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range=f"Leads!A{last + 1}:D").execute().get("values", [])
    report_fetched(len(rows))
    if not rows:
        return {"new": 0}
    auth = {"key": credentials.secret("TRELLO_KEY"), "token": credentials.secret("TRELLO_TOKEN")}
    for i, row in enumerate(rows, start=last + 1):
        name, company, email, notes = (row + ["", "", "", ""])[:4]
        card = http.post("https://api.trello.com/1/cards", params={**auth, "idList": LIST_ID, "name": f"{name} ({company})",
                         "desc": f"Email: {email}\n\n{notes}"}).json()
        sheets.spreadsheets().values().update(spreadsheetId=SHEET_ID, range=f"Leads!E{i}", valueInputOption="RAW",
                                              body={"values": [[card["shortUrl"]]]}).execute()
    state.set("last_row", last + len(rows))
    return {"new": len(rows)}