Monthly Business Profile search keywords in 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

LOCATION_ID = "9876543210"
SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    last = date.today().replace(day=1) - timedelta(days=1)
    params = {"monthlyRange.startMonth.year": last.year, "monthlyRange.startMonth.month": last.month,
              "monthlyRange.endMonth.year": last.year, "monthlyRange.endMonth.month": last.month, "pageSize": 100}
    url = f"https://businessprofileperformance.googleapis.com/v1/locations/{LOCATION_ID}/searchkeywords/impressions/monthly"
    auth = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    found = []
    while True:
        data = http.get(url, params=params, headers=auth).json()
        for k in data.get("searchKeywordsCounts", []):
            v = k["insightsValue"]
            found.append((k["searchKeyword"], int(v["value"]) if "value" in v else None, v.get("threshold")))
        if not data.get("nextPageToken"):
            break
        params["pageToken"] = data["nextPageToken"]
    found.sort(key=lambda k: k[1] or 0, reverse=True)
    month = f"{last:%Y-%m}"
    rows = [[month, kw, n if n is not None else f"under {t}"] for kw, n, t in found]
    if rows:
        build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False) \
            .spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Keywords!A:C", valueInputOption="RAW",
                                            body={"values": rows}).execute()
    return {"month": month, "keywords": len(rows)}