Get your monthly report deck by email with the latest numbers

import base64
from datetime import date, timedelta
from email.message import EmailMessage
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, ai

TEMPLATE_ID, GA_PROPERTY, ME = "report-template-id", "123456789", "me@northwind.com"

@on_trigger
def run(event):
    end = date.today().replace(day=1) - timedelta(days=1)
    names = ["totalUsers", "sessions", "conversions", "totalRevenue"]
    ga = http.post(f"https://analyticsdata.googleapis.com/v1beta/properties/{GA_PROPERTY}:runReport", headers={"Authorization": "Bearer " + credentials.connection("google", "work")},
                   json={"dateRanges": [{"startDate": str(end.replace(day=1)), "endDate": str(end)}], "metrics": [{"name": n} for n in names]}).json()
    v = dict(zip(["users", "sessions", "conversions", "revenue"], (m["value"] for m in ga["rows"][0]["metricValues"])))
    try:
        v["comment"] = ai.generate(f"One sentence on these monthly website figures: {v}", max_output_tokens=60).text
    except ai.AIError:
        v["comment"] = ""
    drive, slides = build("drive", "v3", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False), build("slides", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).presentations()
    deck = drive.files().copy(fileId=TEMPLATE_ID, body={"name": f"Report {end:%B %Y}"}).execute()["id"]
    slides.batchUpdate(presentationId=deck, body={"requests": [{"replaceAllText": {"containsText": {"text": "{{" + k + "}}"}, "replaceText": str(x)}}
                       for k, x in {**v, "month": f"{end:%B %Y}"}.items()]}).execute()
    msg = EmailMessage()
    msg["To"], msg["Subject"] = ME, f"Monthly report – {end:%B %Y}"
    msg.set_content(f"Deck: https://docs.google.com/presentation/d/{deck}\n{v['comment']}")
    msg.add_attachment(drive.files().export(fileId=deck, mimeType="application/pdf").execute(), maintype="application", subtype="pdf", filename=f"Report {end:%B %Y}.pdf")
    build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()
    return v