Get a monthly CSV of your Trustpilot reviews

import csv, io
from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, notify

BUSINESS_UNIT_ID = "your-business-unit-id"

@on_trigger
def run(event):
    end = date.today().replace(day=1)
    start = (end - timedelta(days=1)).replace(day=1)
    buf = io.StringIO()
    w = csv.writer(buf)
    w.writerow(["date", "stars", "title", "text", "reviewer"])
    page, count = 1, 0
    while True:
        reviews = http.get(f"https://api.trustpilot.com/v1/business-units/{BUSINESS_UNIT_ID}/reviews",
                           params={"apikey": credentials.secret("TRUSTPILOT_API_KEY"), "perPage": 100, "page": page,
                                   "orderBy": "createdat.desc"}).json()["reviews"]
        for r in reviews:
            if start.isoformat() <= r["createdAt"][:10] < end.isoformat():
                w.writerow([r["createdAt"][:10], r["stars"], r["title"], r["text"], r["consumer"]["displayName"]])
                count += 1
        if not reviews or reviews[-1]["createdAt"][:10] < start.isoformat():
            break
        page += 1
    notify.email_me(f"Trustpilot reviews {start:%B %Y} ({count})", buf.getvalue())
    return {"reviews": count}