Post your content calendar to LinkedIn and X on time

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

AUTHOR, SHEET_ID = "urn:li:organization:12345", "your-spreadsheet-id"

@on_trigger
def run(event):
    values = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    rows, posted = values.get(spreadsheetId=SHEET_ID, range="Calendar!A2:E").execute().get("values", []), 0
    for i, r in enumerate(rows):
        when, li_text, x_text, li_url, x_url = (r + [""] * 5)[:5]
        if li_url or not when or datetime.fromisoformat(when) > datetime.now():
            continue
        li = http.post("https://api.linkedin.com/rest/posts", headers={"Authorization": f"Bearer {credentials.connection('linkedin', 'work')}", "LinkedIn-Version": "202409"},
                       json={"author": AUTHOR, "commentary": li_text, "visibility": "PUBLIC", "lifecycleState": "PUBLISHED", "distribution": {"feedDistribution": "MAIN_FEED"}})
        tw = http.post("https://api.twitter.com/2/tweets", json={"text": x_text or li_text[:277] + "..."},
                       headers={"Authorization": f"Bearer {credentials.connection('x', 'work')}"}).json()
        if "data" not in tw:
            notify.email_me("X post failed", f"Row {i + 2}: {tw}")
        links = [f"https://www.linkedin.com/feed/update/{li.headers.get('x-restli-id')}", f"https://x.com/i/status/{tw.get('data', {}).get('id', '')}"]
        values.update(spreadsheetId=SHEET_ID, range=f"Calendar!D{i + 2}:E{i + 2}", valueInputOption="RAW", body={"values": [links]}).execute()
        posted += 1
    return {"posted": posted}