list_spreadsheets
Retrieve and display a formatted list of Google Sheets files accessible to a specific user, including file name, ID, and modification time. Specify the user's email and optional result limit.
Instructions
Lists spreadsheets from Google Drive that the user has access to.
Args: user_google_email (str): The user's Google email address. Required. max_results (int): Maximum number of spreadsheets to return. Defaults to 25.
Returns: str: A formatted list of spreadsheet files (name, ID, modified time).
Input Schema
Name | Required | Description | Default |
---|---|---|---|
max_results | No | ||
user_google_email | Yes |
Input Schema (JSON Schema)
{
"properties": {
"max_results": {
"default": 25,
"title": "Max Results",
"type": "integer"
},
"user_google_email": {
"title": "User Google Email",
"type": "string"
}
},
"required": [
"user_google_email"
],
"type": "object"
}