Post a daily themed update on X

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

SHEET_ID = "your-spreadsheet-id"
LAT, LON = 51.45, -2.59  # your city

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    today = date.today().isoformat()
    cal = {r[0]: r[1] for r in sheets.values().get(spreadsheetId=SHEET_ID, range="Calendar!A2:B").execute().get("values", []) if len(r) > 1}
    if cal.get(today, "").lower() == "skip":
        return {"posted": False}
    w = http.get("https://api.open-meteo.com/v1/forecast", params={"latitude": LAT, "longitude": LON, "daily": "temperature_2m_max,precipitation_sum", "timezone": "auto", "forecast_days": 1}).json()["daily"]
    recent = state.get("recent") or []
    text = ai.generate(f"Occasion: {cal.get(today, 'none')}. High {w['temperature_2m_max'][0]}C, rain {w['precipitation_sum'][0]}mm. "
                       f"Avoid repeating: {recent}", system="Write a warm X post for a neighbourhood café, under 240 characters.",
                       max_output_tokens=100).text.strip()[:280]
    http.post("https://api.x.com/2/tweets", headers={"Authorization": "Bearer " + credentials.connection("x", "main")},
              json={"text": text}).raise_for_status()
    sheets.values().append(spreadsheetId=SHEET_ID, range="Log!A:B", valueInputOption="RAW", body={"values": [[today, text]]}).execute()
    state.set("recent", (recent + [text])[-7:])
    return {"posted": True}