Draft a LinkedIn post from your content sheet every weekday

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
import base64
from email.mime.text import MIMEText
from clickruntime import on_trigger, credentials, ai

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

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    sheets = build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Content!A2:C").execute().get("values", [])
    i = next((n for n, r in enumerate(rows) if len(r) > 2 and r[2] == "Pending"), None)
    if i is None:
        return {"drafted": 0}
    topic, notes = rows[i][0], rows[i][1]
    draft = ai.generate(f"Write a LinkedIn post (under 200 words, no hashtags spam) about: {topic}\nNotes: {notes}",
                        max_output_tokens=500).text
    msg = MIMEText(draft)
    msg["to"], msg["subject"] = ME, f"LinkedIn draft: {topic}"
    build("gmail", "v1", credentials=creds, cache_discovery=False).users().messages().send(
        userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()
    sheets.values().update(spreadsheetId=SHEET_ID, range=f"Content!C{i + 2}:D{i + 2}", valueInputOption="RAW",
                           body={"values": [["Drafted", draft]]}).execute()
    return {"drafted": topic}