Share each new blog post on Facebook and log it

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, report_fetched

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

@on_trigger
def run(event):
    shared = state.get("shared") or []
    new = [e for e in feedparser.parse("https://blog.northwind.example/feed").entries if e.link not in shared]
    report_fetched(len(new))
    if not new:
        return {"summary": "No new articles"}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    for e in new:
        caption = ai.generate(f"Two-sentence Facebook caption inviting people to read: {e.title}. {e.get('summary', '')[:500]}",
                              max_output_tokens=120).text
        post = http.post(f"https://graph.facebook.com/v21.0/{PAGE_ID}/feed",
                         data={"message": caption, "link": e.link, "access_token": credentials.connection("facebook", "work")}).json()
        sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Promotion!A:D", valueInputOption="USER_ENTERED",
                                              body={"values": [[date.today().isoformat(), e.title, caption, post["id"]]]}).execute()
        shared.append(e.link)
    state.set("shared", shared[-300:])
    return {"shared": len(new)}