Export Meta Ads results to Google Sheets every day

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, notify

AD_ACCOUNT, SHEET_ID = "act_1234567890", "your-spreadsheet-id"

@on_trigger
def run(event):
    data = http.get(f"https://graph.facebook.com/v21.0/{AD_ACCOUNT}/insights",
                    params={"level": "campaign", "date_preset": "yesterday", "access_token": credentials.connection("facebook", "work"),
                            "fields": "date_start,campaign_name,spend,impressions,clicks,actions"}).json()["data"]
    rows = []
    for d in data:
        conv = sum(int(a["value"]) for a in d.get("actions", []) if a["action_type"] == "purchase")
        rows.append([d["date_start"], d["campaign_name"], float(d["spend"]), int(d["impressions"]), int(d["clicks"]), conv])
    if rows:
        sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
        sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Ads!A:F", valueInputOption="USER_ENTERED",
                                              body={"values": rows}).execute()
    spend, clicks, conv = (sum(r[i] for r in rows) for i in (2, 4, 5))
    notify.email_me("Yesterday's Meta Ads", f"Spend {spend:.2f}, clicks {clicks}, conversions {conv} across {len(rows)} campaigns.")
    return {"campaigns": len(rows)}