get_table_data_tool
Retrieve table data from Google Sheets with optional column filtering and row limits. Specify columns to extract specific data efficiently or fetch all columns for complete table information.
Instructions
Input Schema
Name | Required | Description | Default |
---|---|---|---|
column_names | No | List of column names to retrieve (optional - if not provided, gets all columns) | |
end_row | No | Ending row index (0-based, optional, use -1 for all rows) | |
include_headers | No | Whether to include header row in results | |
max_rows | No | Maximum number of rows to return (optional, use -1 for no limit) | |
sheet_name | Yes | The name of the sheet containing the table | |
spreadsheet_name | Yes | The name of the Google Spreadsheet | |
start_row | No | Starting row index (0-based, optional, use -1 for all rows) | |
table_name | Yes | Name of the table to read data from |