Post trending topics to LinkedIn and log them in a sheet

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

AUTHOR, SHEET_ID = "urn:li:person:abc123", "your-spreadsheet-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    done = {r[1] for r in sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Posts!A2:B").execute().get("values", []) if len(r) > 1}
    story = next((e for e in feedparser.parse("https://feeds.example.org/security.rss").entries if e.title not in done), None)
    if not story:
        return {"posted": False}
    text = ai.generate(f"LinkedIn post with a clear point of view for a security consultant on: {story.title}. Include the link {story.link}.",
                       max_output_tokens=400).text.strip()
    r = http.post("https://api.linkedin.com/rest/posts",
                  headers={"Authorization": f"Bearer {credentials.connection('linkedin', 'work')}", "LinkedIn-Version": "202409"},
                  json={"author": AUTHOR, "commentary": text, "visibility": "PUBLIC", "lifecycleState": "PUBLISHED",
                        "distribution": {"feedDistribution": "MAIN_FEED"}})
    url = f"https://www.linkedin.com/feed/update/{r.headers.get('x-restli-id')}"
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Posts!A:C", valueInputOption="USER_ENTERED",
                                          body={"values": [[date.today().isoformat(), story.title, url]]}).execute()
    notify.email_me(f"Posted on LinkedIn: {story.title}", url)
    return {"posted": url}