Copy new Google reviews to Google Sheets

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

ACCOUNT = "accounts/1234567890"
LOCATIONS = {"locations/111": "Riverside", "locations/222": "Old Town", "locations/333": "Station"}
SHEET_ID = "your-spreadsheet-id"
STARS = {"ONE": 1, "TWO": 2, "THREE": 3, "FOUR": 4, "FIVE": 5}

@on_trigger
def run(event):
    auth = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    rows = []
    for loc, name in LOCATIONS.items():
        last = state.get(f"last:{loc}") or ""
        reviews = http.get(f"https://mybusiness.googleapis.com/v4/{ACCOUNT}/{loc}/reviews",
                           params={"pageSize": 50, "orderBy": "updateTime desc"}, headers=auth).json().get("reviews", [])
        new = [r for r in reviews if r["createTime"] > last]
        for r in sorted(new, key=lambda r: r["createTime"]):
            rows.append([r["createTime"][:10], name, STARS.get(r["starRating"], ""), r["reviewer"].get("displayName", ""),
                         r.get("comment", ""), "replied" if "reviewReply" in r else "no reply yet"])
        if new:
            state.set(f"last:{loc}", max(r["createTime"] for r in new))
    report_fetched(len(rows))
    if rows:
        build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False) \
            .spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Reviews!A:F", valueInputOption="RAW",
                                            body={"values": rows}).execute()
    return {"new": len(rows)}