Aggregate Google Drive Docs into Key-Value Dictionary

This workflow retrieves all Google Docs from a specified Google Drive folder, downloads their full content, and aggregates it into a single JSON object where keys are filenames and values are normalized document contents. Triggered via Execute Workflow node, it uses Google Drive to list files, Google Docs to fetch content, a Set node for mapping, and a Code node for dictionary aggregation. Output is a clean JSON like {"Doc1": "content...", "Doc2": "content..."}, ideal for dynamic data ingestion.

Benefits include time-saving automation for teams managing prompts or references in Docs, eliminating manual copying/exporting. It's perfect for RAG systems, AI prompt context, or knowledge bases, enabling seamless integration into larger automations without custom scripting.

Use cases: Populate vector stores for LLMs, centralize content for chatbots, or prepare datasets for ML training. Customize by changing folders, adding file type support (e.g., PDFs), or tweaking text normalization. Requires Google Drive/Docs OAuth credentials.