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)
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

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

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

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

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

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

List files in root folder

Lists files in the Google Drive root folder

Returns

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

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'.