Log voice agent call transcripts in Sheets and Notion

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

SHEET_ID, DB_ID = "your-spreadsheet-id", "your-notion-database-id"

@on_event
def handle(event):
    call = (event.json or {}).get("call") or {}
    if not call.get("transcript"):
        return {"skipped": True}
    text = call["transcript"]
    blocks = [{"object": "block", "type": "paragraph", "paragraph": {"rich_text": [{"text": {"content": text[i:i + 2000]}}]}}
              for i in range(0, len(text), 2000)][:100]
    page = http.post("https://api.notion.com/v1/pages", headers={"Authorization": f"Bearer {credentials.connection('notion', 'work')}",
        "Notion-Version": "2022-06-28"}, json={"parent": {"database_id": DB_ID}, "children": blocks, "properties": {
        "Name": {"title": [{"text": {"content": f"Call {call.get('from_number', '')} {call.get('call_id', '')}"}}]}}}).json()
    duration = round((call.get("end_timestamp", 0) - call.get("start_timestamp", 0)) / 1000)
    build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="Calls!A:E", valueInputOption="USER_ENTERED",
        body={"values": [[event.received_at, call.get("from_number", ""), duration, call.get("disconnection_reason", ""), page.get("url", "")]]}).execute()
    return {"logged": call.get("call_id")}