Google Drive
Google Drive is a file storage and synchronization service created by Google. It allows users to store files in the cloud, share files, and edit documents, spreadsheets, and presentations with collaborators.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure China regions - US Department of Defense (DoD) |
| Power Automate | Standard | All Power Automate regions except the following: - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Apps | Standard | All Power Apps regions except the following: - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | Microsoft |
| URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://www.google.com/drive/ |
| Privacy policy | https://policies.google.com/privacy |
Known issues and limitations
- This connector is no longer a tabular connector and therefore cannot be used as a tabular data source - including for the Excel connector.
General Limits
| Name | Value |
|---|---|
| Maximum sheet rows count | 500000 |
| Maximum content length (in MB) | 10 |
| Maximum number of megabytes being transferred to/from the connector within a bandwidth time interval (per connection) | 1000 |
| Bandwidth time interval (in miliseconds) | 60000 |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Copy file |
Copies a file on Google Drive |
| Create file |
Uploads a file to Google Drive |
| Delete file |
Deletes a file from Google Drive |
| Extract archive to folder |
Extracts an archive file into a folder in Google Drive (example: .zip) |
| Get file content using id |
Retrieves file content from Google Drive using id |
| Get file content using path |
Retrieves file content from Google Drive using path |
| Get file metadata using id |
Retrieves file metadata from Google Drive using id |
| Get file metadata using path |
Retrieves file metadata from Google Drive using path |
| List files in folder |
List files in a Google Drive folder |
| List files in root folder |
Lists files in the Google Drive root folder |
| Update file |
Updates a file in Google Drive |
Copy file
Copies a file on Google Drive
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Source url
|
source | True | string |
Url to source file |
|
Destination file path
|
destination | True | string |
Destination file path in Google Drive, including target filename |
|
Overwrite?
|
overwrite | boolean |
Overwrites the destination file if set to 'true' |
Returns
Blob metadata
- Body
- BlobMetadata
Create file
Uploads a file to Google Drive
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Folder path
|
folderPath | True | string |
Folder path to upload the file to Google Drive |
|
File name
|
name | True | string |
Name of the file to create in Google Drive |
|
File content
|
body | True | binary |
Content of the file to upload to Google Drive |
Returns
Blob metadata
- Body
- BlobMetadata
Delete file
Deletes a file from Google Drive
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
File
|
id | True | string |
Specify the file to delete |
Extract archive to folder
Extracts an archive file into a folder in Google Drive (example: .zip)
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Source archive file path
|
source | True | string |
Path to the archive file |
|
Destination folder path
|
destination | True | string |
Path in Google Drive to extract the archive contents |
|
Overwrite?
|
overwrite | boolean |
Overwrites the destination files if set to 'true' |
Returns
- response
- array of BlobMetadata
Get file content using id
Retrieves file content from Google Drive using id
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
File id
|
id | True | string |
Unique identifier of the file to retrieve in Google Drive |
|
Infer Content Type
|
inferContentType | boolean |
Infer content-type based on extension |
Returns
The content of the file.
- File Content
- binary
Get file content using path
Retrieves file content from Google Drive using path
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
File path
|
path | True | string |
Path of the file in Google Drive |
|
Infer Content Type
|
inferContentType | boolean |
Infer content-type based on extension |
Returns
The content of the file.
- File Content
- binary
Get file metadata using id
Retrieves file metadata from Google Drive using id
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
File
|
id | True | string |
Specify the file |
Returns
Blob metadata
- Body
- BlobMetadata
Get file metadata using path
Retrieves file metadata from Google Drive using path
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
File path
|
path | True | string |
Path of the file in Google Drive |
Returns
Blob metadata
- Body
- BlobMetadata
List files in folder
List files in a Google Drive folder
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Folder id
|
id | True | string |
Specify the folder in Google Drive |
Returns
- response
- array of BlobMetadata
List files in root folder
Update file
Updates a file in Google Drive
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
File
|
id | True | string |
Specify the file to update |
|
File content
|
body | True | binary |
Content of the file to upload to Google Drive |
Returns
Blob metadata
- Body
- BlobMetadata
Definitions
BlobMetadata
Blob metadata
| Name | Path | Type | Description |
|---|---|---|---|
|
Id
|
Id | string |
The unique id of the file or folder. |
|
Name
|
Name | string |
The name of the file or folder. |
|
DisplayName
|
DisplayName | string |
The display name of the file or folder. |
|
Path
|
Path | string |
The path of the file or folder. |
|
LastModified
|
LastModified | date-time |
The date and time the file or folder was last modified. |
|
Size
|
Size | integer |
The size of the file or folder. |
|
MediaType
|
MediaType | string |
The media type of the file or folder. |
|
IsFolder
|
IsFolder | boolean |
A boolean value (true, false) to indicate whether or not the blob is a folder. |
|
ETag
|
ETag | string |
The etag of the file or folder. |
|
FileLocator
|
FileLocator | string |
The filelocator of the file or folder. |
|
LastModifiedBy
|
LastModifiedBy | string |
The user who last modified the file or folder. |
binary
This is the basic data type 'binary'.