Track your Business Profile numbers in a sheet every week

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

LOCATION_ID = "9876543210"
SHEET_ID = "your-spreadsheet-id"
METRICS = ["BUSINESS_IMPRESSIONS_MOBILE_SEARCH", "BUSINESS_IMPRESSIONS_MOBILE_MAPS", "CALL_CLICKS", "WEBSITE_CLICKS",
           "BUSINESS_DIRECTION_REQUESTS"]

@on_trigger
def run(event):
    token = credentials.connection("google", "work")
    end = date.today() - timedelta(days=1)
    start = end - timedelta(days=6)
    params = [("dailyMetrics", m) for m in METRICS] + [(f"dailyRange.{k}Date.{p}", getattr(d, p)) for k, d in
              (("start", start), ("end", end)) for p in ("year", "month", "day")]
    data = http.get(f"https://businessprofileperformance.googleapis.com/v1/locations/{LOCATION_ID}:fetchMultiDailyMetricsTimeSeries",
                    params=params, headers={"Authorization": f"Bearer {token}"}).json()
    totals = {s["dailyMetric"]: sum(int(v.get("value", 0)) for v in s["timeSeries"].get("datedValues", []))
              for s in data["multiDailyMetricTimeSeries"][0]["dailyMetricTimeSeries"]}
    row = [start.isoformat()] + [totals.get(m, 0) for m in METRICS]
    sheets = build("sheets", "v4", credentials=Credentials(token), cache_discovery=False).spreadsheets().values()
    history = sheets.get(spreadsheetId=SHEET_ID, range="Profile stats!A2:F").execute().get("values", [])[-8:]
    sheets.append(spreadsheetId=SHEET_ID, range="Profile stats!A:F", valueInputOption="RAW", body={"values": [row]}).execute()
    note = ai.generate(f"Columns: week, {', '.join(METRICS)}.\nPrevious weeks: {history}\nThis week: {row}\n"
                       "In three short sentences, say what changed and what might explain it.", max_output_tokens=200).text
    notify.email_me(f"Profile week of {start}: {totals.get('CALL_CLICKS', 0)} calls", note)
    return {"week": row}