Turn the top items in your task sheet into today's Google Tasks

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

SHEET_ID = "your-spreadsheet-id"
PICK = 5

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    sheets = build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Backlog!A2:E").execute().get("values", [])
    open_rows = [(i + 2, (r + [""] * 5)[:5]) for i, r in enumerate(rows) if r and (r + [""] * 5)[4] == ""]
    if not open_rows:
        return {"added": 0}
    listing = "\n".join(f"{n}. {r[0]} | due {r[1] or '-'} | priority {r[2] or '-'} | {r[3][:200]}" for n, r in open_rows)
    picked = ai.generate(f"Today is {date.today()}. Rank these tasks by urgency and impact and return the {PICK} most "
                         f"important row numbers.\n{listing}", max_output_tokens=60,
                         json_schema={"type": "object", "properties": {"rows": {"type": "array", "items": {"type": "integer"}}}}).json["rows"]
    tasks = build("tasks", "v1", credentials=creds, cache_discovery=False).tasks()
    chosen = [(n, r) for n, r in open_rows if n in picked][:PICK]
    for n, r in chosen:
        tasks.insert(tasklist="@default", body={"title": r[0], "notes": r[3],
                                                "due": f"{date.today()}T00:00:00.000Z"}).execute()
        sheets.values().update(spreadsheetId=SHEET_ID, range=f"Backlog!E{n}", valueInputOption="RAW",
                               body={"values": [[f"Added {date.today()}"]]}).execute()
    return {"added": len(chosen)}