Get Asana tasks and an email for contracts renewing soon

from datetime import date, timedelta
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"
PROJECT_ID = "your-asana-project-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    rows = sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Contracts!A2:B").execute().get("values", [])
    done, new = state.get("done") or [], []
    limit = date.today() + timedelta(days=60)
    for client, renews in (r[:2] for r in rows if len(r) >= 2):
        key = f"{client}|{renews}"
        if key in done or not (date.today() <= date.fromisoformat(renews) <= limit):
            continue
        http.post("https://app.asana.com/api/1.0/tasks", headers={"Authorization": f"Bearer {credentials.secret('ASANA_TOKEN')}"},
                  json={"data": {"name": f"Renewal: {client}", "due_on": renews, "projects": [PROJECT_ID]}})
        done.append(key)
        new.append(f"{client} renews on {renews}")
    state.set("done", done[-1000:])
    if new:
        notify.email_me(f"{len(new)} contract renewals coming up", "\n".join(new))
    return {"new_tasks": len(new)}