Publish posts from a content calendar sheet

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

PAGE_ID, IG_ID, SHEET_ID = "1234567890", "17841400000000000", "your-spreadsheet-id"
GRAPH = "https://graph.facebook.com/v21.0"

@on_trigger
def run(event):
    values = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    rows = values.get(spreadsheetId=SHEET_ID, range="Calendar!A2:E").execute().get("values", [])
    token, posted = credentials.connection("facebook", "work"), 0
    for i, r in enumerate(rows):
        when, topic, text, image, status = (r + [""] * 5)[:5]
        if status or not when or datetime.fromisoformat(when) > datetime.now():
            continue
        text = text or ai.generate(f"Short social caption about: {topic}", max_output_tokens=120).text
        http.post(f"{GRAPH}/{PAGE_ID}/photos", data={"url": image, "caption": text, "access_token": token})
        container = http.post(f"{GRAPH}/{IG_ID}/media", data={"image_url": image, "caption": text, "access_token": token}).json()
        http.post(f"{GRAPH}/{IG_ID}/media_publish", data={"creation_id": container["id"], "access_token": token})
        values.update(spreadsheetId=SHEET_ID, range=f"Calendar!E{i + 2}", valueInputOption="RAW", body={"values": [["posted"]]}).execute()
        posted += 1
    return {"posted": posted}