Create a research brief on a client or property in Google Docs

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, credentials, http, ai, notify

FOLDER_ID = "your-drive-folder-id"

def new_doc(title, text):
    creds = Credentials(credentials.connection("google", "work"))
    docs = build("docs", "v1", credentials=creds, cache_discovery=False)
    doc_id = docs.documents().create(body={"title": title}).execute()["documentId"]
    docs.documents().batchUpdate(documentId=doc_id, body={"requests": [{"insertText": {"location": {"index": 1}, "text": text}}]}).execute()
    build("drive", "v3", credentials=creds, cache_discovery=False).files().update(fileId=doc_id, addParents=FOLDER_ID, fields="id").execute()
    return f"https://docs.google.com/document/d/{doc_id}/edit"

@on_event
def handle(event):
    name = ((event.json or {}).get("name") or "").strip()
    if not name:
        return {"error": "no name"}
    key = credentials.secret("SERPAPI_API_KEY")
    web = http.get("https://serpapi.com/search", params={"engine": "google", "q": name, "api_key": key}).json().get("organic_results", [])[:6]
    news = http.get("https://serpapi.com/search", params={"engine": "google", "q": name, "tbm": "nws", "api_key": key}).json().get("news_results", [])[:6]
    lines = "\n".join(f"- {r['title']}: {r.get('snippet', '')} ({r['link']})" for r in web + news)
    brief = ai.generate(f"Subject: {name}\n{lines}", system="Write a brief with sections: Background, Recent news (with dates), Notable facts, Talking points, Sources.", max_output_tokens=1200).text
    url = new_doc(f"Brief: {name}", brief)
    notify.email_me(f"Brief ready: {name}", url)
    return {"doc": url}