Turn your weekly sales sheet into Asana tasks

from datetime import date, timedelta
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, notify, ai

SHEET_ID = "your-spreadsheet-id"
PROJECT_ID = "your-asana-project-id"
SCHEMA = {"type": "object", "properties": {"summary": {"type": "string"}, "actions": {"type": "array", "items": {"type": "object",
          "properties": {"title": {"type": "string"}, "why": {"type": "string"}}, "required": ["title", "why"]}}}, "required": ["summary", "actions"]}

@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="Sales!A1:H").execute().get("values", [])
    table = "\n".join(",".join(r) for r in rows[:1] + rows[-400:])
    plan = ai.generate(["From these sales and stock figures, give a two-sentence summary and the 5 most valuable actions for this week, each with the figures behind it.",
                        table], json_schema=SCHEMA, max_output_tokens=900).json
    due = (date.today() + timedelta(days=4)).isoformat()
    for a in plan["actions"][:5]:
        http.post("https://app.asana.com/api/1.0/tasks", headers={"Authorization": f"Bearer {credentials.secret('ASANA_TOKEN')}"},
                  json={"data": {"name": a["title"], "notes": a["why"], "assignee": "me", "due_on": due, "projects": [PROJECT_ID]}})
    notify.email_me("This week's top 5 actions", plan["summary"] + "\n\n" + "\n".join(f"- {a['title']}" for a in plan["actions"][:5]))
    return {"tasks": len(plan["actions"][:5])}