Log Facebook Page post stats to Google Sheets

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

PAGE_ID = "1234567890"
SHEET_ID = "your-spreadsheet-id"
FIELDS = "message,created_time,permalink_url,shares,reactions.summary(total_count).limit(0),comments.summary(total_count).limit(0)"

def page_token():
    r = http.get(f"https://graph.facebook.com/v21.0/{PAGE_ID}", params={"fields": "access_token",
                 "access_token": credentials.connection("facebook", "work")})
    r.raise_for_status()
    return r.json()["access_token"]

@on_trigger
def run(event):
    url, params = f"https://graph.facebook.com/v21.0/{PAGE_ID}/published_posts", {
        "fields": FIELDS, "since": (date.today() - timedelta(days=30)).isoformat(), "limit": 100, "access_token": page_token()}
    posts = []
    while url:
        page = http.get(url, params=params).json()
        posts += page.get("data", [])
        url, params = (page.get("paging") or {}).get("next"), None
    report_fetched(len(posts))
    rows = []
    for p in posts:
        reactions = p.get("reactions", {}).get("summary", {}).get("total_count", 0)
        comments = p.get("comments", {}).get("summary", {}).get("total_count", 0)
        shares = p.get("shares", {}).get("count", 0)
        text = (p.get("message") or "").split("\n")[0][:120]
        rows.append([p["created_time"][:10], text, reactions, comments, shares, reactions + comments + shares, p["permalink_url"]])
    rows.sort(key=lambda r: -r[5])
    tab = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    tab.clear(spreadsheetId=SHEET_ID, range="Posts!A:G").execute()
    tab.update(spreadsheetId=SHEET_ID, range="Posts!A1", valueInputOption="RAW", body={"values": [
        ["Date", "Post", "Reactions", "Comments", "Shares", "Total", "Link"]] + rows}).execute()
    return {"posts": len(rows)}