Sheets
Query the Google Sheets contained in a user's Google Drive.
Select
It is also possible to get all the sheets from a Team Drive.
Note: You must set the connection property TeamDriveSupport to 'true', in order to query from a specific Team Drive.
SELECT * FROM Sheets WHERE TeamDriveId='0ACkq0ZiV0yJCUk9PVA'
Columns
| Name | Type | Description |
| Id [KEY] | String | The ID of the file. |
| Name | String | The name of the file. This is not necessarily unique within a folder. Note that for immutable items such as the top level folders of Team Drives, My Drive root folder, and Application Data folder the name is constant. |
| TeamDriveId | String | The Id of the teamDrive. |
| Description | String | A short description of the file or folder. |
| Extension | String | The extension of the file. |
| CreatedTime | Datetime | The creation date of the file or folder. |
| ModifiedTime | Datetime | The last modified date of the file or folder. |
| Size | Long | The size of the file in bytes. |
| OwnerName | String | The name of the resource's owner. |
| OwnerEmail | String | The email of the resource's owner. |
| Starred | Boolean | This field sets whether or not the resource is starred. |
| Trashed | Boolean | This field sets whether or not the resource has been moved to the trash. |
| Viewed | Boolean | This field sets whether or not the resource has been viewed by the current user. |
| ParentIds | String | A comma-separated list of parent folder Ids. |
| ChildIds | String | A semicolon-separated list of child resource Ids. |
| ChildLinks | String | A semicolon-separated list of child resource links. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Query | String | This field accepts a valid Google Drive SDK query, which overrides conditionals in the WHERE clause. |