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.
The component uses the Google Drive API to process WHERE clause conditions built with the following column. The rest of the filter is executed client-side within the component.
SELECT * FROM Sheets WHERE DriveId = '0ACkq0ZiV0yJCUk9PVA'
Note: You must set the connection property SupportsAllDrives to true, in order to query from a specific Drive.
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier assigned to the file in Google Drive. |
| Name | String | The display name of the file. This name does not need to be unique within a folder. Items such as the root folder of My Drive, Team Drive roots, and the Application Data folder have fixed names. |
| DriveId | String | The identifier of the personal or shared drive that contains the file. |
| Description | String | A user-defined summary describing the purpose or contents of the file or folder. |
| Extension | String | The file extension that reflects its format, such as pdf, csv, or jpg. |
| CreatedTime | Datetime | The timestamp when the file or folder was first created in Google Drive. |
| ModifiedTime | Datetime | The timestamp of the most recent change made to the file or folder. |
| Size | Long | The total size of the file in bytes. This does not apply to folders or native Google Workspace files. |
| OwnerName | String | The full name of the user who owns the file or folder. |
| OwnerEmail | String | The email address of the owner of the file or folder. |
| Starred | Boolean | If the value is 'true', the resource is marked as starred by the user. |
| Trashed | Boolean | If the value is 'true', the resource has been moved to the trash. |
| Viewed | Boolean | If the value is 'true', the file or folder has been opened or previewed by the authenticated user. |
| ParentIds | String | The unique ID of the parent folder that contains the file. If omitted, the file is located in the root directory. |
| Query | String | Accepts a custom query string using the Google Drive Software Development Kit (SDK) language. Overrides any conditions defined in the WHERE clause. |