Turn a sheet of topics into article drafts in Drive

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from googleapiclient.http import MediaInMemoryUpload
from clickruntime import on_trigger, credentials, ai

SHEET_ID, FOLDER_ID = "your-spreadsheet-id", "your-articles-folder-id"

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    sheet = build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values()
    rows = sheet.get(spreadsheetId=SHEET_ID, range="Content!A2:D").execute().get("values", [])
    i = next((n for n, r in enumerate(rows, start=2) if r and (len(r) < 4 or not r[3])), None)
    if i is None:
        return {"written": 0}
    r = rows[i - 2] + ["", "", ""]
    article = ai.generate(f"Write a 1,000-word blog article in clear headings.\nTopic: {r[0]}\nKeyword: {r[1]}\nNotes: {r[2]}",
                          max_output_tokens=2048).text
    doc = build("drive", "v3", credentials=creds, cache_discovery=False).files().create(
        body={"name": r[0], "parents": [FOLDER_ID], "mimeType": "application/vnd.google-apps.document"},
        media_body=MediaInMemoryUpload(article.encode(), "text/plain"), fields="webViewLink").execute()
    sheet.update(spreadsheetId=SHEET_ID, range=f"Content!D{i}", valueInputOption="RAW",
                 body={"values": [[doc["webViewLink"]]]}).execute()
    return {"written": r[0]}