Write social captions for images you drop in Drive

from clickruntime import on_trigger, credentials, http, state, ai, report_fetched

FOLDER, SHEET = "your-posts-folder-id", "your-spreadsheet-id"
VOICE = "Warm, short, one emoji at most, for a neighbourhood bakery. End with 5 hashtags including #northwindbakery."

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    since = state.get("since") or "2026-01-01T00:00:00Z"
    files = http.get("https://www.googleapis.com/drive/v3/files", headers=h, params={
        "q": f"'{FOLDER}' in parents and mimeType contains 'image/' and createdTime > '{since}' and trashed = false",
        "orderBy": "createdTime", "fields": "files(id,name,description,createdTime,webViewLink)"}).json()["files"]
    report_fetched(len(files))
    if not files:
        return {"new": 0}
    rows = []
    for f in files:
        cap = ai.generate(f"{VOICE}\nWrite an Instagram caption for a photo named '{f['name']}'. Notes: {f.get('description', '')}",
                          max_output_tokens=200).text.strip()
        rows.append([f["webViewLink"], cap, "Ready"])
    http.post(f"https://sheets.googleapis.com/v4/spreadsheets/{SHEET}/values/Content!A:C:append", headers=h,
              params={"valueInputOption": "RAW"}, json={"values": rows})
    state.set("since", files[-1]["createdTime"])
    return {"captioned": len(rows)}