Tool
List spreadsheets
The Google Sheets List Spreadsheets tool enables users to quickly retrieve a list of all Google Spreadsheets accessible to their authenticated account. With optional search and limit features, it streamlines spreadsheet management and access.
Features
- Lists all Google Spreadsheets accessible to the authenticated user.
- Allows optional search by spreadsheet name to filter results.
- Supports setting a maximum limit on the number of spreadsheets returned.
- Provides spreadsheet IDs compatible with other Google Sheets tools for seamless integration.
- Offers a read-only interface ensuring no accidental changes to spreadsheets during listing.
Benefits
- Simplifies management of multiple Google Sheets by providing quick access to spreadsheet lists.
- Enhances productivity by allowing targeted search for specific spreadsheets by name.
- Improves integration with other tools through easy retrieval of spreadsheet IDs.
- Reduces the risk of data mishandling with its read-only design for listing spreadsheets.
- Customizable limit feature helps users focus only on relevant spreadsheets and avoid overload.
Description
List Google Spreadsheets accessible to the authenticated user. Optionally search by name. Returns spreadsheet IDs that can be used with all other tools.
Parameters
2 parameters
| Name | Type | Description |
|---|---|---|
| query | string | Search spreadsheets by name. Leave empty to list all. |
| limit | integer | Maximum number of spreadsheets to return. Default: 20. |