Catalogue new Drive photos in a Notion gallery

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, state, ai, report_fetched

FOLDER_ID, GALLERY_DB = "your-folder-id", "your-notion-database-id"
SCHEMA = {"type": "object", "properties": {"title": {"type": "string"}, "description": {"type": "string"}, "tags": {"type": "array", "items": {"type": "string"}}}, "required": ["title", "tags"]}

@on_trigger
def run(event):
    drive = build("drive", "v3", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).files()
    seen = set(state.get("seen") or [])
    files = [f for f in drive.list(q=f"'{FOLDER_ID}' in parents and mimeType contains 'image/' and trashed=false", pageSize=100,
             fields="files(id,name,createdTime,webViewLink,imageMediaMetadata(time,cameraModel))").execute()["files"] if f["id"] not in seen]
    report_fetched(len(files))
    if not files:
        return {"summary": "Nothing new"}
    for f in files[:25]:
        meta = f.get("imageMediaMetadata", {})
        try:
            info = ai.generate(f"File: {f['name']}\nTaken: {meta.get('time', f['createdTime'])}\nCamera: {meta.get('cameraModel', '')}",
                               system="Write a portfolio title, one-sentence description and up to 5 lowercase tags.", json_schema=SCHEMA, max_output_tokens=150).json
        except ai.AIError:
            info = {"title": f["name"], "description": "", "tags": []}
        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": GALLERY_DB}, "properties": {
            "Name": {"title": [{"text": {"content": info["title"]}}]}, "Description": {"rich_text": [{"text": {"content": info.get("description", "")}}]},
            "Tags": {"multi_select": [{"name": t[:100]} for t in info["tags"]]}, "Photo": {"url": f["webViewLink"]}}}).raise_for_status()
        seen.add(f["id"])
    state.set("seen", list(seen)[-2000:])
    return {"added": min(len(files), 25)}