Sheets
Returns metadata and properties for Google Sheets documents stored in Drive, such as spreadsheet titles and modification history.
Select
It is also possible to get all the sheets from a Drive.
Note: You must set the connection property SupportsAllDrives to 'true', in order to query from a specific Drive.
SELECT * FROM Sheets WHERE DriveId = '0ACkq0ZiV0yJCUk9PVA'
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier assigned to the Google Sheets file in Drive. |
| Name | String | The display name of the Google Sheets file. This name is not guaranteed to be unique within a folder. Root items such as My Drive, Team Drives, and Application Data folders use constant names. |
| DriveId | String | The identifier of the Drive (personal or shared) where the spreadsheet is stored. |
| Description | String | A short user-defined summary of the contents or purpose of the spreadsheet. |
| Extension | String | The file extension indicating the format, such as xlsx or csv, associated with the spreadsheet file. |
| CreatedTime | Datetime | The timestamp of when the spreadsheet was initially created in Drive. |
| ModifiedTime | Datetime | The timestamp of the last modification made to the spreadsheet file. |
| Size | Long | The size of the spreadsheet file in bytes. Native Google Sheets files typically do not include file size. |
| OwnerName | String | The full name of the Google account that owns the spreadsheet. |
| OwnerEmail | String | The email address associated with the spreadsheet owner. |
| Starred | Boolean | If the value is 'true', the spreadsheet is marked as starred by the user. |
| Trashed | Boolean | If the value is 'true', the spreadsheet has been sent to the trash. |
| Viewed | Boolean | If the value is 'true', the spreadsheet has been accessed or opened by the authenticated user. |
| ParentIds | String | A comma-separated list of folder IDs, such as abc123, def456, ghi789, that act as parent directories for the spreadsheet. |
| ChildIds | String | A semicolon-separated list of resource IDs, such as file001; file002; file003, referencing child items contained under the spreadsheet, if any. |
| ChildLinks | String | A semicolon-separated list of URLs, such as https://drive.google.com/file1; https://drive.google.com/file2, that link to child resources. |
| Query | String | Accepts a query string written using the Google Drive Software Development Kit (SDK) syntax. Overrides default filters applied through the WHERE clause. |