Get values in range
The Google Sheets Get Values in Range tool enables users to easily retrieve all or specific values from a spreadsheet using A1 notation. It integrates seamlessly with Google Sheets API to provide quick, precise access to spreadsheet data.
Features
- Supports fetching values from entire sheets or specific cell ranges using A1 notation.
- Allows selection of spreadsheets via spreadsheet ID for targeted data retrieval.
- Enables specifying worksheet ID to pinpoint exact worksheet within a spreadsheet.
- Supports retrieval from both My Drive and Shared Drives for flexible file access.
- Provides integration-ready design for automated workflows and easy API usage.
Benefits
- Streamlines data extraction from Google Sheets for enhanced productivity.
- Facilitates automation by enabling programmatic access to spreadsheet data.
- Reduces manual data handling errors by automating value retrieval.
- Supports dynamic reporting and data analysis by fetching up-to-date data on demand.
- Improves integration with other tools and systems through standardized API calls.
Description
Get all values or values from a range of cells using A1 notation. See the documentation
Parameters
4 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-get-values-in-range, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-get-values-in-range, propName: sheetId. |
| worksheetIdrequired | integer | Select a worksheet or provide a worksheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-get-values-in-range, propName: worksheetId. |
| range | string | The A1 notation of the values to retrieve. E.g., |