Read Sheet Values
read_sheet_valuesRead values from a specific range in a Google Sheet. Customize formatting and date representation for tailored output.
Instructions
Read values from a specific range in a Google Sheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range_name | No | The range to read (e.g., "Sheet1!A1:D10", "A1:D10"). Defaults to "A1:Z1000". | A1:Z1000 |
| spreadsheet_id | Yes | The ID of the spreadsheet. Required. | |
| user_google_email | No | The user's Google email address for Sheets access. If None, uses the current authenticated user from FastMCP context (auto-injected by middleware). | |
| value_render_option | No | How values should be rendered. One of: FORMATTED_VALUE (default), UNFORMATTED_VALUE, FORMULA. If omitted, the Google Sheets API default is used. | |
| date_time_render_option | No | How dates, times, and durations should be rendered. One of: SERIAL_NUMBER, FORMATTED_STRING. If omitted, the Google Sheets API default is used. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| error | No | Error message if operation failed | |
| range | Yes | Range that was read from the sheet | |
| values | Yes | 2D array of cell values | |
| rowCount | Yes | Number of rows returned | |
| columnCount | Yes | Number of columns returned | |
| spreadsheetId | Yes | Unique identifier for the spreadsheet |