Publish a Business Profile post each week from a topic sheet

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

LOCATION = "accounts/1234567890/locations/9876543210"
SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    token = credentials.connection("google", "work")
    sheets = build("sheets", "v4", credentials=Credentials(token), cache_discovery=False).spreadsheets().values()
    rows = sheets.get(spreadsheetId=SHEET_ID, range="Post ideas!A2:C").execute().get("values", [])
    nxt = next(((i + 2, r) for i, r in enumerate(rows) if r and len(r) < 3), None)
    if not nxt:
        return {"posted": False, "reason": "no topics left"}
    n, (topic, *notes) = nxt
    text = ai.generate(f"Write a Google Business Profile post for Northwind Coffee about: {topic}. Notes: {' '.join(notes)}. "
                       "Under 900 characters, friendly, no hashtags, end with a clear call to action.", max_output_tokens=300).text
    resp = http.post(f"https://mybusiness.googleapis.com/v4/{LOCATION}/localPosts",
                     headers={"Authorization": f"Bearer {token}"},
                     json={"languageCode": "en", "summary": text.strip()[:1500], "topicType": "STANDARD"})
    resp.raise_for_status()
    sheets.update(spreadsheetId=SHEET_ID, range=f"Post ideas!C{n}", valueInputOption="RAW",
                  body={"values": [[f"Posted {date.today()}"]]}).execute()
    return {"posted": topic}