Turn keywords in a sheet into article drafts in Google Docs

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, ai, report_fetched, log

SHEET_ID = "your-spreadsheet-id"

@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", [])
    ready = [(i + 2, r[0]) for i, r in enumerate(rows) if len(r) > 1 and r[1] == "Ready"]
    report_fetched(len(ready))
    if not ready:
        return {"drafted": 0}
    docs = build("docs", "v1", credentials=creds, cache_discovery=False).documents()
    for row, keyword in ready[:10]:
        try:
            outline = ai.generate(f"Write an SEO article outline with H2/H3 headings and bullet points for: {keyword}", max_output_tokens=900).text
        except ai.AIError as e:
            log.warning("AI unavailable", {"code": e.code})
            break
        doc = docs.create(body={"title": keyword}).execute()
        docs.batchUpdate(documentId=doc["documentId"], body={"requests": [{"insertText": {"location": {"index": 1}, "text": outline}}]}).execute()
        sheets.values().update(spreadsheetId=SHEET_ID, range=f"Content!B{row}:C{row}", valueInputOption="USER_ENTERED",
            body={"values": [["Drafted", f"https://docs.google.com/document/d/{doc['documentId']}"]]}).execute()
    return {"drafted": len(ready[:10])}