Post your content calendar to Facebook and X on schedule

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

PAGE_ID, SHEET_ID = "1234567890", "your-spreadsheet-id"

@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:C").execute().get("values", [])
    posted = 0
    for i, r in enumerate(rows):
        when, text, status = (r + [""] * 3)[:3]
        if status or not when or datetime.fromisoformat(when) > datetime.now():
            continue
        http.post(f"https://graph.facebook.com/v21.0/{PAGE_ID}/feed",
                  data={"message": text, "access_token": credentials.connection("facebook", "work")})
        short = text if len(text) <= 280 else text[:277] + "..."
        http.post("https://api.twitter.com/2/tweets", json={"text": short},
                  headers={"Authorization": f"Bearer {credentials.connection('x', 'work')}"})
        values.update(spreadsheetId=SHEET_ID, range=f"Calendar!C{i + 2}", valueInputOption="RAW",
                      body={"values": [["posted"]]}).execute()
        posted += 1
    return {"posted": posted}