Reply to chosen senders with AI and log every exchange

import base64
from email.mime.text import MIMEText
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, ai, report_fetched
SENDERS = ["ops@northwind.example", "accounts@acme.example"]
SHEET_ID, LABEL_ID = "your-spreadsheet-id", "Label_AutoReplied"
GUIDE = "You are my assistant. Answer briefly and politely. If unsure, say I will follow up personally."
@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    gmail = build("gmail", "v1", credentials=creds, cache_discovery=False)
    q = "newer_than:1d -label:AutoReplied (" + " OR ".join(f"from:{s}" for s in SENDERS) + ")"
    msgs = gmail.users().messages().list(userId="me", q=q).execute().get("messages", [])
    report_fetched(len(msgs))
    if not msgs:
        return {"replied": 0}
    rows = []
    for m in msgs:
        msg = gmail.users().messages().get(userId="me", id=m["id"], format="full").execute()
        hdr = {h["name"]: h["value"] for h in msg["payload"]["headers"]}
        reply = ai.generate(f"Email from {hdr['From']}:\n{msg['snippet']}", system=GUIDE, max_output_tokens=400).text
        mime = MIMEText(reply); mime["To"] = hdr["From"]; mime["Subject"] = "Re: " + hdr.get("Subject", "")
        mime["In-Reply-To"] = hdr.get("Message-ID", "")
        gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(mime.as_bytes()).decode(),
                                                         "threadId": msg["threadId"]}).execute()
        gmail.users().messages().modify(userId="me", id=m["id"], body={"addLabelIds": [LABEL_ID]}).execute()
        rows.append([hdr.get("Date"), hdr["From"], hdr.get("Subject"), msg["snippet"], reply])
    build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="Log!A:E", valueInputOption="RAW", body={"values": rows}).execute()
    return {"replied": len(rows)}