Turn repeated support questions into FAQ drafts

from datetime import date
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, ai

DOC_ID = "your-faq-doc-id"

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    gmail = build("gmail", "v1", credentials=creds, cache_discovery=False).users().messages()
    ids = [m["id"] for m in gmail.list(userId="me", q="to:support@yourdomain.com newer_than:7d", maxResults=150).execute().get("messages", [])]
    snippets = [gmail.get(userId="me", id=i, format="metadata").execute()["snippet"] for i in ids]
    if not snippets:
        return {"questions": 0}
    lines = "\n".join(f"{n}. {s[:300]}" for n, s in enumerate(snippets, 1))
    drafts = ai.generate(f"These are customer support emails. List questions asked more than once, each with a short draft FAQ answer. Leave out names and order numbers.\n{lines}",
                         max_output_tokens=1500).text
    docs = build("docs", "v1", credentials=creds, cache_discovery=False).documents()
    end = docs.get(documentId=DOC_ID).execute()["body"]["content"][-1]["endIndex"] - 1
    docs.batchUpdate(documentId=DOC_ID, body={"requests": [{"insertText": {"location": {"index": end},
        "text": f"\n\nDrafts for week of {date.today().isoformat()}\n{drafts}"}}]}).execute()
    return {"emails": len(snippets)}