MCP Google Sheets

https://github.com/xing5/mcp-google-sheets
Admin
MCP Google Sheets is a Python-based MCP server that enables AI assistants to interact with Google...
Tokens:26,801
Snippets:300
Trust Score:9.5
License:MIT
Update:2 months ago
Show doc for...
Tokens:
Raw
### Usage examples for list_folders

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-discovery.md

Examples showing how to list folders from the root or a specific parent ID.

```python
folders = list_folders()
# Returns: [
#     {'id': 'folder1', 'name': 'Archives', 'parent': 'root'},
#     {'id': 'folder2', 'name': 'Current Projects', 'parent': 'root'},
#     {'id': 'folder3', 'name': 'Reports', 'parent': 'root'}
# ]

# List folders within a specific folder
subfolders = list_folders(
    parent_folder_id="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
)
# Returns: [
#     {'id': 'subfolder1', 'name': 'Q1', 'parent': '1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa'},
#     {'id': 'subfolder2', 'name': 'Q2', 'parent': '1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa'}
# ]
```

--------------------------------

### Example URI Format

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/mcp-resources.md

A concrete example of a resource URI using a specific spreadsheet ID.

```text
spreadsheet://25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI/info
```

--------------------------------

### Execute add_columns example

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-sheet-management.md

Example usage of the add_columns function to insert 3 columns starting at index 2.

```python
result = add_columns(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Sheet1",
    count=3,
    start_column=2
)
# Returns: batchUpdate response
```

--------------------------------

### Initialize Batch Queries

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/types.md

Example list of query objects for batch processing.

```python
queries = [
    {'spreadsheet_id': 'abc123', 'sheet': 'Sheet1', 'range': 'A1:B5'},
    {'spreadsheet_id': 'xyz789', 'sheet': 'Data', 'range': 'C1:C10'}
]
```

--------------------------------

### Configure Environment Variables

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/authentication.md

Set the paths for your credentials and token files before starting the server.

```bash
export CREDENTIALS_PATH="/path/to/credentials.json"
export TOKEN_PATH="/path/to/token.json"  # Writable location for token caching
```

--------------------------------

### Install uv package manager

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Commands to install the uv package manager on various operating systems.

```bash
# macOS / Linux
curl -LsSf https://astral.sh/uv/install.sh | sh
# Windows
powershell -c "irm https://astral.sh/uv/install.ps1 | iex"
# Or using pip:
# pip install uv
```

--------------------------------

### Execute add_rows example

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-sheet-management.md

Example usage of the add_rows function to insert 5 rows starting at index 10.

```python
result = add_rows(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Data",
    count=5,
    start_row=10
)
# Returns: batchUpdate response
```

--------------------------------

### Initialize Recipient List

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/types.md

Example list of recipients with assigned roles for sharing.

```python
recipients = [
    {'email_address': 'analyst@example.com', 'role': 'writer'},
    {'email_address': 'viewer@example.com', 'role': 'reader'},
    {'email_address': 'reviewer@example.com', 'role': 'commenter'}
]
```

--------------------------------

### Usage examples for get_sheet_data

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-data-operations.md

Examples demonstrating how to read specific ranges or entire sheets with optional formatting.

```python
# Read values from a range
result = get_sheet_data(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Sheet1",
    range="A1:C10",
    include_grid_data=False
)
# Returns: {'spreadsheetId': '...', 'valueRanges': [{'range': 'Sheet1!A1:C10', 'values': [[...], ...]}]}

# Read entire sheet with formatting
result = get_sheet_data(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Data",
    include_grid_data=True
)
# Returns: Full metadata including cell colors, fonts, borders, etc.
```

--------------------------------

### Create charts with add_chart

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-visualization.md

Examples of creating different chart types including column, pie, and line charts with custom positioning.

```python
result = add_chart(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Sales",
    chart_type="COLUMN",
    data_range="A1:B13",
    title="Monthly Sales 2024",
    x_axis_label="Month",
    y_axis_label="Revenue ($)"
)
# Returns: {
#     'success': True,
#     'message': "Chart 'Monthly Sales 2024' added successfully",
#     'chartId': 123456789,
#     'result': {...}
# }
```

```python
result = add_chart(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Market",
    chart_type="PIE",
    data_range="A1:B5",
    title="Market Share by Product"
)
```

```python
result = add_chart(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Data",
    chart_type="LINE",
    data_range="A1:C25",
    title="Growth Trends",
    x_axis_label="Quarter",
    y_axis_label="Growth %",
    position_x=100,
    position_y=200,
    width=800,
    height=500
)
```

--------------------------------

### Example Client Request

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/mcp-resources.md

A natural language prompt used in an MCP client to retrieve spreadsheet structure.

```text
Please retrieve the structure of spreadsheet 25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI
```

--------------------------------

### Usage examples for find_in_spreadsheet

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-discovery.md

Examples demonstrating general searches and sheet-specific searches within a spreadsheet.

```python
results = find_in_spreadsheet(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    query="URGENT",
    case_sensitive=False,
    max_results=20
)
# Returns: [
#     {'sheet': 'Sheet1', 'cell': 'A5', 'value': 'URGENT: Review needed'},
#     {'sheet': 'Data', 'cell': 'B12', 'value': 'urgent action required'},
#     ...
# ]

# Search in a specific sheet only
results = find_in_spreadsheet(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    query="ERROR",
    sheet="Log",
    case_sensitive=True
)
# Returns: [
#     {'sheet': 'Log', 'cell': 'C3', 'value': 'ERROR: Connection failed'},
#     ...
# ]
```

--------------------------------

### Example Metadata Response

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/mcp-resources.md

A sample JSON response for a specific spreadsheet query.

```json
{
  "title": "Sales Data 2024",
  "sheets": [
    {
      "title": "January",
      "sheetId": 0,
      "gridProperties": {
        "rowCount": 1000,
        "columnCount": 26
      }
    },
    {
      "title": "February",
      "sheetId": 234567,
      "gridProperties": {
        "rowCount": 1000,
        "columnCount": 26
      }
    }
  ]
}
```

--------------------------------

### Set CREDENTIALS_CONFIG Environment Variable

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/authentication.md

Example of setting the environment variable using a Base64-encoded string.

```bash
export CREDENTIALS_CONFIG="ewogICJ0eXBlIjogInNlcnZpY2VfYWNjb3VudCIsCi..."
```

--------------------------------

### Chart data structure examples

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-visualization.md

Expected data formats for standard charts and pie charts.

```text
Month | Sales | Expenses | Profit
Jan   | 1000  | 700      | 300
Feb   | 1200  | 750      | 450
Mar   | 1100  | 800      | 300
```

```text
Product | Market Share
Widget  | 35
Gadget  | 45
Tool    | 20
```

--------------------------------

### Create a new Google Spreadsheet

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-spreadsheet-management.md

Defines the function signature for creating a spreadsheet and provides a usage example.

```python
def create_spreadsheet(
    title: str,
    folder_id: Optional[str] = None,
    ctx: Context = None
) -> Dict[str, Any]
```

```python
result = create_spreadsheet(
    title="Quarterly Report Q1 2024",
    folder_id="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
)
# Returns: {
#     'spreadsheetId': '25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI',
#     'title': 'Quarterly Report Q1 2024',
#     'folder': '1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa'
# }
```

--------------------------------

### List spreadsheets in a folder

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-spreadsheet-management.md

Defines the function signature for listing spreadsheets and provides a usage example.

```python
def list_spreadsheets(
    folder_id: Optional[str] = None,
    ctx: Context = None
) -> List[Dict[str, str]]
```

```python
spreadsheets = list_spreadsheets(
    folder_id="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
)
# Returns: [
#     {'id': 'abc123', 'title': 'Sales Report'},
#     {'id': 'xyz789', 'title': 'Budget Tracker'},
#     {'id': 'def456', 'title': 'Project Timeline'}
# ]
```

--------------------------------

### spreadsheet://{spreadsheet_id}/info

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Get basic metadata about a Google Spreadsheet.

```APIDOC
## GET spreadsheet://{spreadsheet_id}/info

### Description
Retrieves metadata for a specific spreadsheet.

### Parameters
- **spreadsheet_id** (path) - Required - The ID of the spreadsheet.
```

--------------------------------

### Batch Update Request Objects

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/types.md

Examples of dictionary structures for common Google Sheets batchUpdate operations.

```python
{
    "addSheet": {
        "properties": {
            "title": "New Sheet"
        }
    }
}
```

```python
{
    "insertDimension": {
        "range": {
            "sheetId": 0,
            "dimension": "ROWS",      # or "COLUMNS"
            "startIndex": 1,
            "endIndex": 3
        }
    }
}
```

```python
{
    "updateSheetProperties": {
        "properties": {
            "sheetId": 0,
            "title": "Renamed Sheet"
        },
        "fields": "title"
    }
}
```

--------------------------------

### Locate Google Cloud, Drive, and Sheets IDs

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Reference guide for identifying specific resource IDs from their respective Google service URLs.

```text
Google Cloud Project ID:
  https://console.cloud.google.com/apis/dashboard?project=sheets-mcp-server-123456
                                                          └───── Project ID ─────┘

Google Drive Folder ID:
  https://drive.google.com/drive/u/0/folders/1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa
                                             └────────── Folder ID ──────────┘

Google Sheets Spreadsheet ID:
  https://docs.google.com/spreadsheets/d/25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI/edit
                                         └───────────── Spreadsheet ID ─────────────┘
```

--------------------------------

### Get multiple spreadsheet summaries in Python

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-data-operations.md

Retrieves titles, sheet names, and preview rows for a list of spreadsheet IDs. Errors are returned within the response objects rather than raising exceptions.

```python
def get_multiple_spreadsheet_summary(
    spreadsheet_ids: List[str],
    rows_to_fetch: int = 5,
    ctx: Context = None
) -> List[Dict[str, Any]]
```

```python
summaries = get_multiple_spreadsheet_summary(
    spreadsheet_ids=["abc123", "xyz789"],
    rows_to_fetch=3
)
# Returns: [
#     {
#         'spreadsheet_id': 'abc123',
#         'title': 'Sales Report',
#         'sheets': [
#             {
#                 'title': 'Sheet1',
#                 'headers': ['Date', 'Amount', 'Category'],
#                 'first_rows': [['2024-01-01', 100, 'A'], ...]
#             }
#         ]
#     },
#     ...
# ]
```

--------------------------------

### Add columns to a sheet

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/usage-examples.md

Inserts a specified number of columns into a sheet starting at a given column index.

```python
result = add_columns(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Sheet1",
    count=3,
    start_column=2
)
```

--------------------------------

### Run server for development

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Execute the server from a local repository clone using uv.

```bash
uv run mcp-google-sheets
# Or via the script name if defined in pyproject.toml, e.g.:
# uv run start
```

--------------------------------

### Run mcp-google-sheets with Direct Credentials

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/authentication.md

Demonstrates encoding a credentials file and launching the server with the required environment variables.

```bash
# Encode credentials
BASE64_CREDS=$(base64 -w 0 /path/to/service-account.json)

# Run with encoded credentials
export CREDENTIALS_CONFIG="$BASE64_CREDS"
export DRIVE_FOLDER_ID="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
mcp-google-sheets
```

--------------------------------

### Configure Service Account with Folder

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/configuration.md

Sets up authentication using a service account JSON file and restricts access to a specific Google Drive folder.

```bash
export SERVICE_ACCOUNT_PATH="/home/user/service-account.json"
export DRIVE_FOLDER_ID="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
export LOG_LEVEL="INFO"
mcp-google-sheets
```

--------------------------------

### Run server with Docker

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Build and run the server in a container using SSE transport. Use CREDENTIALS_CONFIG for environment-based authentication.

```bash
# Build the image
docker build -t mcp-google-sheets .

# Run (SSE on port 8000)
# NOTE: Prefer CREDENTIALS_CONFIG (Base64 credentials content) in containers.
docker run --rm -p 8000:8000 ^
  -e HOST=0.0.0.0 ^
  -e PORT=8000 ^
  -e CREDENTIALS_CONFIG=YOUR_BASE64_CREDENTIALS ^
  -e DRIVE_FOLDER_ID=YOUR_DRIVE_FOLDER_ID ^
  mcp-google-sheets
```

--------------------------------

### Create and Populate a Report

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/usage-examples.md

Demonstrates the full workflow of creating a spreadsheet, adding sheets, writing data, inserting a chart, and sharing the document.

```python
# 1. Create a new spreadsheet
print("Creating spreadsheet...")
spreadsheet = create_spreadsheet(
    title="Monthly Report " + datetime.now().strftime("%B %Y"),
    folder_id="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
)
spreadsheet_id = spreadsheet['spreadsheetId']

# 2. Create sheets for different sections
print("Creating sheets...")
create_sheet(spreadsheet_id=spreadsheet_id, title="Summary")
create_sheet(spreadsheet_id=spreadsheet_id, title="Details")

# 3. Add headers and data
print("Writing data...")
summary_data = [
    ["KPI", "Value", "Target", "Status"],
    ["Revenue", 50000, 45000, "✓"],
    ["Costs", 30000, 32000, "✓"],
    ["Profit", 20000, 13000, "✓"]
]
update_cells(
    spreadsheet_id=spreadsheet_id,
    sheet="Summary",
    range="A1:D4",
    data=summary_data
)

# 4. Create visualization
print("Adding chart...")
add_chart(
    spreadsheet_id=spreadsheet_id,
    sheet="Summary",
    chart_type="COLUMN",
    data_range="A1:B4",
    title="Key Metrics"
)

# 5. Share with team
print("Sharing...")
share_spreadsheet(
    spreadsheet_id=spreadsheet_id,
    recipients=[
        {'email_address': 'team@example.com', 'role': 'reader'}
    ]
)

print(f"Report created: https://docs.google.com/spreadsheets/d/{spreadsheet_id}/edit")
```

--------------------------------

### Configure Environment Variables

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/authentication.md

Set the required environment variables to point to your service account key file and target Google Drive folder.

```bash
export SERVICE_ACCOUNT_PATH="/path/to/service-account-key.json"
export DRIVE_FOLDER_ID="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
```

--------------------------------

### Configure Local Development Environment

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Use this configuration when running the server directly from a cloned repository. Adjust the directory path to match your local workspace.

```json
{
  "mcpServers": {
    "mcp-google-sheets-local": {
      "command": "uv",
      "args": [
        "run",
        "--directory",
        "/path/to/your/mcp-google-sheets",
        "mcp-google-sheets"
      ],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/path/to/your/mcp-google-sheets/service_account.json",
        "DRIVE_FOLDER_ID": "your_drive_folder_id_here"
      }
    }
  }
}
```

--------------------------------

### Run the MCP Server

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/authentication.md

Execute the server command after configuring the environment variables.

```bash
mcp-google-sheets
```

--------------------------------

### Run the MCP server

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Command to execute the latest version of the mcp-google-sheets server using uvx.

```bash
uvx mcp-google-sheets@latest
```

--------------------------------

### Run mcp-google-sheets with Environment Variables

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/configuration.md

Executes the container with specific configuration for credentials, folder ID, and network settings.

```bash
docker run -e CREDENTIALS_CONFIG="base64_string" \
           -e DRIVE_FOLDER_ID="folder_id" \
           -e HOST="0.0.0.0" \
           -e PORT="8000" \
           -p 8000:8000 \
           mcp-google-sheets-image
```

--------------------------------

### Add rows to a sheet

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/usage-examples.md

Inserts a specified number of rows into a sheet starting at a given row index.

```python
result = add_rows(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Data",
    count=10,
    start_row=5
)
```

--------------------------------

### Create a new spreadsheet

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/usage-examples.md

Initializes a new spreadsheet with a specified title and optional folder ID.

```python
result = create_spreadsheet(
    title="Sales Report Q4 2024",
    folder_id="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
)
spreadsheet_id = result['spreadsheetId']
print(f"Created spreadsheet: {spreadsheet_id}")
```

--------------------------------

### Configure Service Account via Base64 String

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Use this configuration to provide credentials as a Base64 encoded string. A DRIVE_FOLDER_ID is still required for folder context.

```json
{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        "CREDENTIALS_CONFIG": "ewogICJ0eXBlIjogInNlcnZpY2VfYWNjb3VudCIsCiAgInByb2plY3RfaWQiOiAi...",
        "DRIVE_FOLDER_ID": "your_shared_folder_id_here"
      }
    }
  }
}
```

--------------------------------

### Enable Tool Filtering via Command-line Argument

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Use the --include-tools flag in the command-line arguments to specify a comma-separated list of tools to enable.

```json
{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": [
        "mcp-google-sheets@latest",
        "--include-tools",
        "get_sheet_data,update_cells,list_spreadsheets,list_sheets"
      ],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/path/to/credentials.json"
      }
    }
  }
}
```

--------------------------------

### Create and Populate Workflow

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/INDEX.md

Sequence of operations to initialize a new spreadsheet, add content, visualize data, and manage permissions.

```text
1. create_spreadsheet() — Create new spreadsheet
2. create_sheet() — Add sheet tabs
3. update_cells() — Write data
4. add_chart() — Visualize data
5. share_spreadsheet() — Grant access
```

--------------------------------

### Authenticate for local development using gcloud CLI

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/authentication.md

Use the gcloud CLI to authenticate your account and set a quota project for local development environments.

```bash
# Authenticate with your Google account
gcloud auth application-default login \
  --scopes=https://www.googleapis.com/auth/cloud-platform,https://www.googleapis.com/auth/spreadsheets,https://www.googleapis.com/auth/drive

# Set quota project (required for some scenarios)
gcloud auth application-default set-quota-project my-project-id

# Now run the server without any credential files
mcp-google-sheets
```

--------------------------------

### Claude Desktop Resource Reference

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/mcp-resources.md

How to reference a resource directly within a Claude Desktop prompt.

```text
Look at spreadsheet://25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI/info
and tell me the structure
```

--------------------------------

### Authenticate using GOOGLE_APPLICATION_CREDENTIALS

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/authentication.md

Explicitly point the server to a service account JSON file using environment variables.

```bash
export GOOGLE_APPLICATION_CREDENTIALS="/path/to/service-account.json"
export DRIVE_FOLDER_ID="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
mcp-google-sheets
```

--------------------------------

### Set environment variables for authentication

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Commands to configure authentication credentials and drive folder IDs for the MCP server.

```bash
# Replace with YOUR actual path and folder ID from the Google Setup step
export SERVICE_ACCOUNT_PATH="/path/to/your/service-account-key.json"
export DRIVE_FOLDER_ID="YOUR_DRIVE_FOLDER_ID"
```

```cmd
set SERVICE_ACCOUNT_PATH="C:\path\to\your\service-account-key.json"
set DRIVE_FOLDER_ID="YOUR_DRIVE_FOLDER_ID"
```

```powershell
$env:SERVICE_ACCOUNT_PATH = "C:\path\to\your\service-account-key.json"
$env:DRIVE_FOLDER_ID = "YOUR_DRIVE_FOLDER_ID"
```

--------------------------------

### Create and Populate Workflow

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/README.md

Sequence of operations to create a new spreadsheet and populate it with data and charts.

```text
create_spreadsheet() → create_sheet() → update_cells() → add_chart() → share_spreadsheet()
```

--------------------------------

### Configure Service Account Authentication

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Use this configuration for Service Account-based access. macOS users should replace 'uvx' with the full path to their local binary if a spawn error occurs.

```json
{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/full/path/to/your/service-account-key.json",
        "DRIVE_FOLDER_ID": "your_shared_folder_id_here"
      }
    }
  }
}
```

```json
{
  "mcpServers": {
    "google-sheets": {
      "command": "/Users/yourusername/.local/bin/uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/full/path/to/your/service-account-key.json",
        "DRIVE_FOLDER_ID": "your_shared_folder_id_here"
      }
    }
  }
}
```

--------------------------------

### Project File Structure

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/README.md

Directory layout of the project documentation files.

```text
output/
├── README.md                              (This file)
├── INDEX.md                               (Master index & navigation)
├── overview.md                            (Project overview)
├── api-reference-data-operations.md       (7 tools: read/write data)
├── api-reference-sheet-management.md      (6 tools: manage sheets)
├── api-reference-spreadsheet-management.md (4 tools: manage spreadsheets)
├── api-reference-discovery.md             (2 tools: search/discover)
├── api-reference-visualization.md         (1 tool: create charts)
├── configuration.md                       (Setup & env variables)
├── authentication.md                      (Auth methods & guides)
├── types.md                               (Data types & structures)
├── usage-examples.md                      (Code examples)
└── mcp-resources.md                       (MCP resource details)
```

--------------------------------

### Configure OAuth with Token Caching

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/configuration.md

Enables OAuth authentication where the initial login is performed via browser and subsequent sessions use a cached token.

```bash
export CREDENTIALS_PATH="/home/user/credentials.json"
export TOKEN_PATH="/home/user/.mcp-token.json"
mcp-google-sheets
# Browser login on first run, token cached for future runs
```

--------------------------------

### Discovery and Visualization

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/INDEX.md

Tools for discovering files and adding visual elements.

```APIDOC
## Discovery and Visualization

- `list_folders`: List Google Drive folders.
- `find_in_spreadsheet`: Search for specific cell values.
- `add_chart`: Create charts within a sheet.
```

--------------------------------

### Configure Base64 Credentials for Docker

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/configuration.md

Uses a base64-encoded credentials string for containerized environments and sets up SSE transport.

```bash
export CREDENTIALS_CONFIG="ewogICJ0eXBlIjogInNlcnZpY2VfYWNjb3VudCIsCi..."
export DRIVE_FOLDER_ID="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
export HOST="0.0.0.0"
export PORT="8000"
mcp-google-sheets --transport sse
```

--------------------------------

### Configure Application Default Credentials (ADC)

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Use ADC via environment variables or gcloud authentication. Ensure the gcloud CLI is authenticated with the necessary scopes before use.

```json
{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        "GOOGLE_APPLICATION_CREDENTIALS": "/path/to/service-account.json"
      }
    }
  }
}
```

```json
{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {}
    }
  }
}
```

--------------------------------

### Configure Claude Desktop Integration

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/configuration.md

Adds the MCP server configuration to the Claude Desktop application settings file.

```json
{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/full/path/to/service-account-key.json",
        "DRIVE_FOLDER_ID": "your_folder_id_here",
        "ENABLED_TOOLS": "get_sheet_data,update_cells,list_spreadsheets,list_sheets"
      }
    }
  }
}
```

--------------------------------

### Filter Tools via Command-Line Argument

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/overview.md

Use the --include-tools flag to specify a subset of tools directly when executing the server.

```bash
uvx mcp-google-sheets@latest --include-tools "get_sheet_data,update_cells"
```

--------------------------------

### A1 Notation Conversion Utilities

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/types.md

Internal helper functions for mapping between A1 notation strings and integer-based column indices.

```python
def _column_index_to_letter(index: int) -> str:
    """Convert 0-based index to letter (0='A', 25='Z', 26='AA')"""

def _letter_to_column_index(letter: str) -> int:
    """Convert letter to 0-based index ('A'=0, 'Z'=25, 'AA'=26)"""

def _parse_a1_notation(range_str: str) -> Dict[str, int]:
    """Parse A1 notation to row/column indices"""
```

--------------------------------

### Configure Tool Filtering

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/configuration.md

Limits the available tools to a specific subset to reduce context usage.

```bash
export SERVICE_ACCOUNT_PATH="/home/user/service-account.json"
export ENABLED_TOOLS="get_sheet_data,update_cells,list_spreadsheets,list_sheets"
mcp-google-sheets
# Only the 4 most common tools are enabled, reducing context usage
```

--------------------------------

### Configure Application Default Credentials

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/configuration.md

Uses Google Cloud Application Default Credentials (ADC) to avoid manual environment variable configuration.

```bash
# First, set up ADC locally
gcloud auth application-default login --scopes=https://www.googleapis.com/auth/cloud-platform,https://www.googleapis.com/auth/spreadsheets,https://www.googleapis.com/auth/drive
gcloud auth application-default set-quota-project my-project-id

# Then, no environment variables needed
mcp-google-sheets
```

--------------------------------

### Programmatic Resource Access

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/mcp-resources.md

Pseudo-code for fetching resources programmatically in an MCP-compatible client.

```python
# Pseudo-code for MCP clients
resource = client.read_resource("spreadsheet://25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI/info")
# Returns: {'contents': [{'uri': '...', 'mimeType': 'application/json', 'text': '...'}]}
```

--------------------------------

### Configure OAuth 2.0 Authentication

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Use this configuration for OAuth 2.0. Ensure the token path is writable and be prepared for a browser-based login flow on the first use.

```json
{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        "CREDENTIALS_PATH": "/full/path/to/your/credentials.json",
        "TOKEN_PATH": "/full/path/to/your/token.json"
      }
    }
  }
}
```

--------------------------------

### Create a line chart tracking trends

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/usage-examples.md

Adds a line chart to visualize growth trends over a specified range.

```python
result = add_chart(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Data",
    chart_type="LINE",
    data_range="A1:C25",
    title="Growth Trends",
    x_axis_label="Quarter",
    y_axis_label="Growth %"
)
```

--------------------------------

### Dockerfile for mcp-google-sheets

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/configuration.md

Defines the base image and entry point for running the application with SSE transport.

```dockerfile
FROM python:3.11-slim
RUN pip install mcp-google-sheets

ENTRYPOINT ["mcp-google-sheets", "--transport", "sse"]
```

--------------------------------

### add_chart

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Creates a chart in a Google Spreadsheet.

```APIDOC
## add_chart

### Description
Generates a chart based on data in a sheet.

### Parameters
- **spreadsheet_id** (string) - Required - The spreadsheet ID.
- **sheet** (string) - Required - Name of the sheet.
- **chart_type** (string) - Required - Type of chart (COLUMN, BAR, LINE, AREA, PIE, SCATTER, COMBO, HISTOGRAM).
- **data_range** (string) - Required - A1 notation range.
- **title** (string) - Optional - Chart title.
- **x_axis_label** (string) - Optional - X axis label.
- **y_axis_label** (string) - Optional - Y axis label.
- **position_x** (integer) - Optional - Horizontal offset (default 0).
- **position_y** (integer) - Optional - Vertical offset (default 0).
- **width** (integer) - Optional - Width in pixels (default 600).
- **height** (integer) - Optional - Height in pixels (default 400).
```

--------------------------------

### Configure included tools via CLI

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/configuration.md

Overrides the ENABLED_TOOLS environment variable using a comma-separated list of tools.

```bash
mcp-google-sheets --include-tools get_sheet_data,update_cells
```

--------------------------------

### Configure Cloud Run service account

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/authentication.md

Define the service account and environment variables in a Cloud Run YAML configuration file.

```yaml
# cloud-run.yaml
apiVersion: serving.knative.dev/v1
kind: Service
metadata:
  name: mcp-google-sheets
spec:
  template:
    spec:
      serviceAccountName: mcp-service
      containers:
      - image: gcr.io/my-project/mcp-google-sheets
        env:
        - name: DRIVE_FOLDER_ID
          value: "1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
```

--------------------------------

### Filter Tools via Environment Variable

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/overview.md

Use the ENABLED_TOOLS environment variable to restrict the available tools before launching the server.

```bash
export ENABLED_TOOLS="get_sheet_data,update_cells,list_spreadsheets,list_sheets"
uvx mcp-google-sheets@latest
```

--------------------------------

### Service Account JSON Key Structure

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/authentication.md

The expected format of the JSON key file downloaded from the Google Cloud Console.

```json
{
  "type": "service_account",
  "project_id": "my-project-123456",
  "private_key_id": "abc123...",
  "private_key": "-----BEGIN PRIVATE KEY-----\n...\n-----END PRIVATE KEY-----\n",
  "client_email": "mcp-sheets-service@my-project-123456.iam.gserviceaccount.com",
  "client_id": "123456789...",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url": "..."
}
```

--------------------------------

### create_spreadsheet

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Creates a new spreadsheet with a specified title.

```APIDOC
## create_spreadsheet

### Description
Creates a new spreadsheet.

### Parameters
- **title** (string) - Required - The desired title for the spreadsheet.
- **folder_id** (string) - Optional - Google Drive folder ID where the spreadsheet should be created.
```

--------------------------------

### create_spreadsheet

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-spreadsheet-management.md

Creates a new Google Spreadsheet with the specified title, optionally within a specific folder.

```APIDOC
## create_spreadsheet

### Description
Creates a new Google Spreadsheet. The function accepts a title and an optional folder ID to specify the destination in Google Drive.

### Signature
`create_spreadsheet(title: str, folder_id: Optional[str] = None, ctx: Context = None) -> Dict[str, Any]`

### Parameters
- **title** (str) - Required - The title/name of the new spreadsheet.
- **folder_id** (str) - Optional - Google Drive folder ID where the spreadsheet should be created.

### Return Type
`Dict[str, Any]` - Object containing `spreadsheetId`, `title`, and `folder`.

### Example
```python
result = create_spreadsheet(
    title="Quarterly Report Q1 2024",
    folder_id="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
)
```
```

--------------------------------

### Create a pie chart

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/usage-examples.md

Adds a pie chart to a specified sheet using a defined data range.

```python
result = add_chart(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Market",
    chart_type="PIE",
    data_range="A1:B5",
    title="Market Share by Product"
)
```

--------------------------------

### Generate Base64 Credentials in PowerShell

Source: https://github.com/xing5/mcp-google-sheets/blob/main/README.md

Converts a local JSON credentials file into a Base64 string for direct environment variable injection.

```powershell
$filePath = "C:\path\to\your_credentials.json"; # Use actual path
$bytes = [System.IO.File]::ReadAllBytes($filePath);
$base64 = [System.Convert]::ToBase64String($bytes);
$base64 # Copy this output
```

--------------------------------

### Create a new sheet

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-sheet-management.md

Creates a new sheet tab in an existing spreadsheet by providing the spreadsheet ID and the desired title.

```python
def create_sheet(
    spreadsheet_id: str,
    title: str,
    ctx: Context = None
) -> Dict[str, Any]
```

```python
result = create_sheet(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    title="Summary"
)
# Returns: {'sheetId': 123456, 'title': 'Summary', 'index': 2, 'spreadsheetId': '25_-_...'}
```

--------------------------------

### Spreadsheet Management

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/INDEX.md

Tools for managing entire spreadsheet files.

```APIDOC
## Spreadsheet Management

- `create_spreadsheet`: Create a new spreadsheet file.
- `list_spreadsheets`: List available spreadsheets.
- `search_spreadsheets`: Search for spreadsheets.
- `share_spreadsheet`: Grant permissions to a spreadsheet.
```

--------------------------------

### list_folders

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-discovery.md

Lists all folders in a Google Drive folder. If no parent folder ID is provided, it defaults to the root of 'My Drive'.

```APIDOC
## list_folders

### Description
Lists all folders in a Google Drive folder. If no parent folder ID is provided, it defaults to the root of 'My Drive'.

### Method
Python Function

### Parameters
- **parent_folder_id** (str) - Optional - Google Drive folder ID to search within. If omitted, searches the root of 'My Drive'.

### Return Type
List[Dict[str, str]] — List of folder objects, each containing id (folder ID), name (folder name), and parent (parent folder ID or 'root'). Ordered alphabetically by name.

### Throws
- Exception — If API authentication fails or parent folder is not accessible.
```

--------------------------------

### create_sheet

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-sheet-management.md

Creates a new sheet tab in an existing spreadsheet.

```APIDOC
## create_sheet

### Description
Creates a new sheet tab in an existing spreadsheet.

### Signature
`create_sheet(spreadsheet_id: str, title: str, ctx: Context = None) -> Dict[str, Any]`

### Parameters
- **spreadsheet_id** (str) - Required - The spreadsheet ID
- **title** (str) - Required - The name for the new sheet tab

### Return Type
`Dict[str, Any]` - Object containing sheetId (integer), title, index (tab order), and spreadsheetId.

### Example
```python
result = create_sheet(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    title="Summary"
)
# Returns: {'sheetId': 123456, 'title': 'Summary', 'index': 2, 'spreadsheetId': '25_-_...'}
```
```

--------------------------------

### Chart Creation Response Structure

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/types.md

The structure returned by add_chart() upon successful execution.

```python
{
    "success": bool,
    "message": str,
    "chartId": int,
    "result": dict  # Full Google Sheets API response
}
```

--------------------------------

### Encode Credentials via PowerShell

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/authentication.md

Use this script on Windows to convert a JSON credentials file into a Base64 string for the CREDENTIALS_CONFIG environment variable.

```powershell
$filePath = "C:\path\to\your_credentials.json"
$bytes = [System.IO.File]::ReadAllBytes($filePath)
$base64 = [System.Convert]::ToBase64String($bytes)
Write-Output $base64
```

--------------------------------

### List folders in Google Drive

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/usage-examples.md

Retrieves a list of folders from Google Drive, optionally filtered by a parent folder ID.

```python
folders = list_folders(parent_folder_id=None)
for folder in folders:
    print(f"{folder['name']}: {folder['id']}")
```

--------------------------------

### get_multiple_spreadsheet_summary

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-data-operations.md

Retrieves spreadsheet titles, sheet names, headers, and preview rows for a list of spreadsheet IDs.

```APIDOC
## get_multiple_spreadsheet_summary

### Description
Gets spreadsheet titles, sheet names, headers, and preview rows for multiple spreadsheets.

### Signature
`get_multiple_spreadsheet_summary(spreadsheet_ids: List[str], rows_to_fetch: int = 5, ctx: Context = None) -> List[Dict[str, Any]]`

### Parameters
- **spreadsheet_ids** (List[str]) - Required - List of spreadsheet IDs to summarize
- **rows_to_fetch** (int) - Optional - Number of rows (including header) to fetch for preview (Default: 5)

### Return Type
`List[Dict[str, Any]]` - List of summary objects, one per spreadsheet. Each includes `spreadsheet_id`, `title`, `sheets` (list of sheet summaries with `title`, `headers`, `first_rows`, and `error` if applicable), and `error` if the spreadsheet couldn't be fetched.
```

--------------------------------

### Define Resource URI Scheme

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/mcp-resources.md

The standard URI pattern for accessing spreadsheet metadata.

```text
spreadsheet://{spreadsheet_id}/info
```

--------------------------------

### Fetch data from multiple spreadsheets

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/usage-examples.md

Performs batch data retrieval from multiple spreadsheets using a list of query definitions.

```python
queries = [
    {'spreadsheet_id': 'abc123', 'sheet': 'Sales', 'range': 'A1:B100'},
    {'spreadsheet_id': 'xyz789', 'sheet': 'Costs', 'range': 'A1:B50'},
    {'spreadsheet_id': 'def456', 'sheet': 'Summary', 'range': 'A1:D10'}
]

results = get_multiple_sheet_data(queries=queries)

for result in results:
    if 'error' in result:
        print(f"Error fetching {result['spreadsheet_id']}: {result['error']}")
    else:
        print(f"Got {len(result['data'])} rows from {result['sheet']}")
```

--------------------------------

### Define Spreadsheet Summary Object

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/types.md

Structure returned by get_multiple_spreadsheet_summary() containing spreadsheet metadata and sheet summaries.

```python
{
    'spreadsheet_id': str,
    'title': str,
    'sheets': [SheetSummary, ...],
    'error': Optional[str]
}
```

--------------------------------

### Specify MCP transport mechanism

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/configuration.md

Sets the transport layer for the server, defaulting to stdio if not specified.

```bash
mcp-google-sheets --transport sse
```

--------------------------------

### Handle Share Failures

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/usage-examples.md

Checks the result of a share operation for specific failures and reports them to the user.

```python
result = share_spreadsheet(
    spreadsheet_id=spreadsheet_id,
    recipients=[...]
)

if result['failures']:
    print("Warning: Failed to share with:")
    for failure in result['failures']:
        email = failure.get('email_address', 'unknown')
        error = failure.get('error', 'unknown error')
        print(f"  {email}: {error}")
else:
    print(f"Successfully shared with {len(result['successes'])} users")
```

--------------------------------

### Search and Analyze Workflow

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/INDEX.md

Sequence of operations to locate relevant data across spreadsheets and retrieve it for analysis.

```text
1. search_spreadsheets() — Find relevant spreadsheets
2. get_multiple_spreadsheet_summary() — Preview data
3. find_in_spreadsheet() — Find specific values
4. get_sheet_data() — Retrieve for analysis
```

--------------------------------

### Retrieve formulas with get_sheet_formulas

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-data-operations.md

Fetches formulas from a specified range in a Google Sheet. Returns a 2D list where non-formula cells are represented as empty strings or values.

```python
def get_sheet_formulas(
    spreadsheet_id: str,
    sheet: str,
    range: Optional[str] = None,
    ctx: Context = None
) -> List[List[Any]]
```

```python
formulas = get_sheet_formulas(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Sheet1",
    range="A1:C5"
)
# Returns: [['=SUM(A1:A5)', '=AVERAGE(B1:B5)', '=COUNT(C1:C5)'], [...], ...]
```

--------------------------------

### List spreadsheets in a folder

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/usage-examples.md

Retrieves a list of all spreadsheets located within a specific Google Drive folder.

```python
spreadsheets = list_spreadsheets(
    folder_id="1xcRQCU9xrNVBPTeNzHqx4hrG7yR91WIa"
)
for sheet in spreadsheets:
    print(f"{sheet['title']}: {sheet['id']}")
```

--------------------------------

### Create a column chart

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/usage-examples.md

Adds a column chart to a specified sheet with defined axes and positioning.

```python
result = add_chart(
    spreadsheet_id="25_-_raTaKjaVxu9nJzA7-FCrNhnkd3cXC54BPAOXemI",
    sheet="Sales",
    chart_type="COLUMN",
    data_range="A1:B13",
    title="Monthly Sales 2024",
    x_axis_label="Month",
    y_axis_label="Revenue ($)",
    position_x=100,
    position_y=200
)

if result.get('success'):
    print(f"Chart created with ID: {result['chartId']}")
else:
    print(f"Error: {result['error']}")
```

--------------------------------

### Define list_folders function

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/api-reference-discovery.md

Signature for the list_folders function used to retrieve folder structures.

```python
def list_folders(
    parent_folder_id: Optional[str] = None,
    ctx: Context = None
) -> List[Dict[str, str]]
```

--------------------------------

### Define a Query Object

Source: https://github.com/xing5/mcp-google-sheets/blob/main/_autodocs/types.md

Schema definition for a single data fetch operation in batch queries.

```python
{
    'spreadsheet_id': str,
    'sheet': str,
    'range': str
}
```
Tokens:
Raw