Publish blog posts from a topic sheet to your GitHub site

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

def gh(method, path, **kw):
    resp = http.request(method, f"https://api.github.com{path}", headers={
        "Authorization": f"Bearer {credentials.connection('github', 'work')}", "Accept": "application/vnd.github+json"}, **kw)
    return resp.raise_for_status() or (resp.json() if resp.content else None)

REPO, FOLDER, SHEET_ID = "acme/website", "src/content/blog", "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="Blog!A2:C").execute().get("values", [])
    nxt = next(((i, r) for i, r in enumerate(rows, start=2) if len(r) > 1 and r[1] == "Ready"), None)
    if not nxt:
        return {"published": None}
    i, (topic, _, *notes) = nxt
    md = ai.generate(f"Topic: {topic}\nNotes: {notes[0] if notes else ''}", max_output_tokens=2000,
                     system="Write a 700-word blog post in Markdown. Start with YAML front matter: title, description, pubDate, tags.").text
    slug = re.sub(r"[^a-z0-9]+", "-", topic.lower()).strip("-")[:60]
    path = f"{FOLDER}/{date.today()}-{slug}.md"
    gh("PUT", f"/repos/{REPO}/contents/{path}", json={"message": f"Add post: {topic}", "content": base64.b64encode(md.encode()).decode()})
    values.update(spreadsheetId=SHEET_ID, range=f"Blog!B{i}", valueInputOption="RAW", body={"values": [[f"Published {path}"]]}).execute()
    return {"published": path}