Post about trending topics on Facebook and log each post

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

PAGE_ID, SHEET_ID = "1234567890", "your-spreadsheet-id"

@on_trigger
def run(event):
    posted = state.get("posted") or []
    items = [e for e in feedparser.parse("https://www.reddit.com/r/fitness/top/.rss?t=day").entries if e.link not in posted]
    if not items:
        return {"posted": 0}
    item = items[0]
    text = ai.generate(f"Write a friendly 3-sentence Facebook post for a fitness studio about: {item.title}",
                       max_output_tokens=200).text
    post = http.post(f"https://graph.facebook.com/v21.0/{PAGE_ID}/feed",
                     data={"message": text, "access_token": credentials.connection("facebook", "work")}).json()
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Posts!A:D", valueInputOption="USER_ENTERED",
                                          body={"values": [[date.today().isoformat(), item.title, text, post["id"]]]}).execute()
    state.set("posted", (posted + [item.link])[-200:])
    return {"post": post["id"]}