Google Drive

Integromat Updated January 23, 2020 07:46

Getting started with Google Drive

To use any of the above modules, you need to connect your Google account to Integromat. If you do not have a Google account yet, you can create one here.

Connecting the Google Drive service to Integromat

To connect your Google account to Integromat, follow the general instructions for Connecting to services. After you click the Continue button, Integromat will redirect you to the Google website where you will be prompted to grant Integromat access to your account:

Here, allow access by clicking the Allow button. Afterwards, you will be redirected back to the Integromat administration page. Now, you can continue creating your scenario.

Possible problems

Unable to upload or update a file

There are several situations when uploading or updating a file fails:

• The uploaded file is too big and exceeds the maximum file size limit allowed for your Google Drive plan or you have exceeded your Google Drive storage limit. You can either upgrade your storage plan or delete existing files from the Google Drive service.

• The selected folder where the file was to be uploaded to no longer exists. The scenario stops and it is then necessary to select a target folder again.

Search for files

In the module List files in a folder you can use your own query which consists of these parts:

Field - Attribute of the file that is being searched, e.g. the attribute name of the file.

Operator - Test that is performed on the data to provide a match, e.g. contains.

Value - The content of the attribute that is tested, e.g. the name of the file My cool document.

Combine clauses with the conjunctions and or or, and negate the query with not.

Fields

[1] The contains operator only performs prefix matching for a title. For example, the title "HelloWorld" would match for title contains 'Hello' but not title contains 'World'.

[2] The contains operator only performs matching on entire string tokens for fullText. For example, if the full text of a doc contains the string "HelloWorld" only the query fullText contains 'HelloWorld' would return a result. Queries such as fullText contains 'Hello' would not return results in this scenario.

[2] The contains operator will match on an exact alphanumeric phrase if it is surrounded by double quotes. For example, if the fullText of a doc contains the string "Hello there world", then the query fullText contains '"Hello there"' will return a result, but the query fullText contains '"Hello world"' would not. Furthermore, since the search is alphanumeric, if the fullText of a doc contains the string "Hello_world", then the query fullText contains '"Hello world"' would return a result.

[3] Fields of type date are currently not comparable to each other, only to constant dates.

Value types

Operators

For compound clauses, you can use parentheses to group clauses together. For example:
modifiedDate > '2012-06-04T12:00:00' and (mimeType contains 'image/' or mimeType contains 'video/')

This search returns all files with an image or video MIME type that their last modification was after June 4, 2012. Because and and or operators are evaluated from left to right, without parentheses, the above example would return only images modified after June 4, 2012, but would return all videos, even those before June 4, 2012.

Examples

All examples on this page show the unencoded q parameter, where title = 'hello' is encoded as
title+%3d+%27hello%27. Client libraries handle this encoding automatically.

Search for files with the name "hello"
title = 'hello'

Search for folders using the folder-specific MIME type
mimeType = 'application/vnd.google-apps.folder'

Search for files that are not folders
mimeType != 'application/vnd.google-apps.folder'

Search for files with a name containing the words "hello" and "goodbye"
title contains 'hello' and name contains 'goodbye'

Search for files with a name that does not contain the word "hello"
not title contains 'hello'

Search for files containing the word "hello" in the content
fullText contains 'hello'

Search for files not containing the word "hello" in the content
not fullText contains 'hello'

Search for files containing the exact phrase "hello world" in the content
fullText contains '"hello world"'fullText contains '"hello_world"'

Search for files with a query containing the "\" character (e.g., "\authors")
fullText contains '\\authors'

Search for files writeable by the user "test@example.org"
'test@example.org' in writers

Search for the ID 1234567 in the parents collection. This finds all files and folders located directly in the folder whose ID is 1234567.
'1234567' in parents

Search for the alias ID appDataFolder in the parents collection. This finds all files and folders located directly under the Application Data folder.
'appDataFolder' in parents

Search for files writeable by the users "test@example.org" and "test2@example.org"
'test@example.org' in writers and 'test2@example.org' in writers

Search for files containing the text "important" which are in the trash
fullText contains 'important' and trashed = true

Search for files modified after June 4th 2012
modifiedDate > '2012-06-04T12:00:00' // default time zone is UTC
modifiedDate > '2012-06-04T12:00:00-08:00'

Search for files shared with the authorized user with "hello" in the name
sharedWithMe and title contains 'hello'

Search for files with a custom file property named additionalID with the value 8e8aceg2af2ge72e78.
properties has { key='additionalID' and value='8e8aceg2af2ge72e78' and visibility='PRIVATE' }

Source of this guide is Google Drive documentation.