Log Facebook Page insights to Google Sheets daily

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

PAGE_ID = "1234567890"
SHEET_ID = "your-spreadsheet-id"
METRICS = ["page_views_total", "page_post_engagements", "page_daily_follows_unique", "page_daily_unfollows_unique", "page_media_view"]

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):
    day = date.today() - timedelta(days=1)
    data = http.get(f"https://graph.facebook.com/v21.0/{PAGE_ID}/insights", params={
        "metric": ",".join(METRICS), "period": "day", "since": day.isoformat(), "until": date.today().isoformat(),
        "access_token": page_token()}).json().get("data", [])
    values = {m["name"]: (m["values"][-1].get("value", 0) if m.get("values") else 0) for m in data}
    row = [day.isoformat()] + [values.get(m, 0) for m in METRICS]
    build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False) \
        .spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Page stats!A:F", valueInputOption="RAW",
                                        body={"values": [row]}).execute()
    return {"date": day.isoformat(), **values}