Skip to main content
document_reader.py
"""
Drive Document Reader
=====================
Reads and summarizes large documents from Google Drive.

Uses max_read_size to control the maximum file size loaded into memory
and returns structured summaries with key sections.

Key concepts:
- read_file: Exports Google Docs as text, Sheets as CSV, Slides as text
- add_datetime_to_context: Agent knows today's date for time-relative queries

Setup:
1. Create OAuth credentials at https://console.cloud.google.com (enable Google Drive API)
2. Export GOOGLE_CLIENT_ID, GOOGLE_CLIENT_SECRET, GOOGLE_PROJECT_ID env vars
3. pip install openai google-api-python-client google-auth-httplib2 google-auth-oauthlib
4. First run opens browser for OAuth consent, saves token.json for reuse
"""

from agno.agent import Agent
from agno.models.openai import OpenAIResponses
from agno.tools.google.drive import GoogleDriveTools

# 50 MB — allow reading larger non-Workspace files (default is 10 MB)
MAX_READ_SIZE = 50 * 1024 * 1024

agent = Agent(
    name="Document Reader",
    model=OpenAIResponses(id="gpt-5.5"),
    tools=[GoogleDriveTools(max_read_size=MAX_READ_SIZE)],
    instructions=[
        "When reading documents, provide a structured summary with sections and key points.",
        "For spreadsheets (returned as CSV), describe the columns and highlight notable data.",
        "If the content is truncated, tell the user and summarize what was available.",
    ],
    add_datetime_to_context=True,
    markdown=True,
)

# ---------------------------------------------------------------------------
# Run Demo
# ---------------------------------------------------------------------------

if __name__ == "__main__":
    # Search and read a document
    agent.print_response(
        "Find the most recent Google Doc in my Drive and summarize it",
        stream=True,
    )

    # Read a specific file by ID
    # agent.print_response(
    #     "Read the file with ID <FILE_ID> and give me a detailed summary",
    #     stream=True,
    # )

    # Read a spreadsheet
    # agent.print_response(
    #     "Find a spreadsheet named 'Budget' and describe what data it contains",
    #     stream=True,
    # )

Run the Example

1

Set up your virtual environment

uv venv --python 3.12
source .venv/bin/activate
uv venv --python 3.12
.venv\Scripts\activate
2

Install dependencies

uv pip install -U agno google-api-python-client google-auth google-auth-httplib2 google-auth-oauthlib openai openpyxl python-docx python-pptx
3

Export your API keys

export GOOGLE_CLOUD_QUOTA_PROJECT_ID="your_google_cloud_quota_project_id_here"
export OPENAI_API_KEY="your_openai_api_key_here"
$Env:GOOGLE_CLOUD_QUOTA_PROJECT_ID="your_google_cloud_quota_project_id_here"
$Env:OPENAI_API_KEY="your_openai_api_key_here"
4

Run the example

Save the code above as document_reader.py, then run:
python document_reader.py
Full source: cookbook/91_tools/google/drive/document_reader.py