Publish your sheet content plan to X

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

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Plan!A2:C").execute().get("values", [])
    x = {"Authorization": "Bearer " + credentials.connection("x", "main")}
    posted = 0
    for n, row in enumerate(rows, start=2):
        if len(row) < 2 or row[0] != date.today().isoformat() or (len(row) > 2 and row[2]):
            continue
        text = ai.generate(f"Brief: {row[1]}", system="Write one X post under 260 characters, at most one hashtag.",
                           max_output_tokens=120).text.strip()[:280]
        resp = http.post("https://api.x.com/2/tweets", headers=x, json={"text": text})
        resp.raise_for_status()
        link = f"https://x.com/i/status/{resp.json()['data']['id']}"
        sheets.values().update(spreadsheetId=SHEET_ID, range=f"Plan!C{n}", valueInputOption="RAW",
                               body={"values": [[f"Posted {link}"]]}).execute()
        posted += 1
    return {"posted": posted}