Share new articles on LinkedIn, tracked 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, report_fetched

AUTHOR, SHEET_ID = "urn:li:organization:12345", "your-spreadsheet-id"
FEEDS = ["https://blog.northwind-talent.example/feed", "https://news.example.org/hr.rss"]

@on_trigger
def run(event):
    values = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    shared = {r[0] for r in values.get(spreadsheetId=SHEET_ID, range="Shared!B2:B").execute().get("values", []) if r}
    new = [e for f in FEEDS for e in feedparser.parse(f).entries if e.link not in shared][:3]
    report_fetched(len(new))
    if not new:
        return {"summary": "Nothing new"}
    for e in new:
        intro = ai.generate(f"Two-sentence LinkedIn intro for a recruitment firm sharing: {e.title}", max_output_tokens=120).text.strip()
        http.post("https://api.linkedin.com/rest/posts",
                  headers={"Authorization": f"Bearer {credentials.connection('linkedin', 'work')}", "LinkedIn-Version": "202409"},
                  json={"author": AUTHOR, "commentary": intro, "visibility": "PUBLIC", "lifecycleState": "PUBLISHED",
                        "distribution": {"feedDistribution": "MAIN_FEED"}, "content": {"article": {"source": e.link, "title": e.title}}})
        values.append(spreadsheetId=SHEET_ID, range="Shared!A:C", valueInputOption="USER_ENTERED",
                      body={"values": [[date.today().isoformat(), e.link, e.title]]}).execute()
    return {"shared": len(new)}