Post ideas from your content list to LinkedIn

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

SHEET_ID, ME = "your-spreadsheet-id", "me@example.com"

@on_trigger
def run(event):
    google = Credentials(credentials.connection("google", "work"))
    sheets = build("sheets", "v4", credentials=google, cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Ideas!A2:C").execute().get("values", [])
    n = next((i for i, r in enumerate(rows) if len(r) > 1 and r[1] == "Ready"), None)
    if n is None:
        return {"posted": False}
    idea = rows[n][0] + (f"\nNotes: {rows[n][2]}" if len(rows[n]) > 2 else "")
    text = ai.generate(f"Turn this idea into a 150-word LinkedIn post:\n{idea}", max_output_tokens=400).text.strip()
    headers = {"Authorization": "Bearer " + credentials.connection("linkedin", "main"), "LinkedIn-Version": "202405"}
    me = http.get("https://api.linkedin.com/v2/userinfo", headers=headers).json()["sub"]
    resp = http.post("https://api.linkedin.com/rest/posts", headers=headers, json={
        "author": f"urn:li:person:{me}", "commentary": text, "visibility": "PUBLIC", "lifecycleState": "PUBLISHED",
        "distribution": {"feedDistribution": "MAIN_FEED", "targetEntities": [], "thirdPartyDistributionChannels": []}})
    resp.raise_for_status()
    sheets.values().update(spreadsheetId=SHEET_ID, range=f"Ideas!B{n + 2}", valueInputOption="RAW",
                           body={"values": [[f"Posted {date.today()}"]]}).execute()
    msg = EmailMessage()
    msg["To"], msg["Subject"] = ME, f"Live on LinkedIn: {rows[n][0]}"
    msg.set_content(f"{text}\n\nhttps://www.linkedin.com/feed/update/{resp.headers['x-restli-id']}")
    build("gmail", "v1", credentials=google, cache_discovery=False).users().messages().send(
        userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()
    return {"posted": True}