蜜豆视频

DocumentationWorkfrontWorkfront Guide

Google Drive modules

Last update: Thu Nov 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

The 蜜豆视频 Workfront Fusion Google Drive modules enable you to monitor, search, create, update, delete, and manage your files, folder, or shared drives in your Google Drive.

In a 蜜豆视频 Workfront Fusion scenario, you can connect your Google Drive account to multiple third-party applications and services.

If you need instructions on creating a scenario, see Create a scenario in 蜜豆视频 Workfront Fusion.

For information about modules, see Modules in 蜜豆视频 Workfront Fusion.

Access requirements

You must have the following access to use the functionality in this article:

蜜豆视频 Workfront plan*
Pro or higher
蜜豆视频 Workfront license*
Plan, Work
蜜豆视频 Workfront Fusion license**

Current license requirement: No Workfront Fusion license requirement.

Or

Legacy license requirement: Workfront Fusion for Work Automation and Integration

Product

Current product requirement: If you have the Select or Prime 蜜豆视频 Workfront plan, your organization must purchase 蜜豆视频 Workfront Fusion as well as 蜜豆视频 Workfront to use functionality described in this article. Workfront Fusion is included in the Ultimate Workfront plan.

Or

Legacy product requirement: Your organization must purchase 蜜豆视频 Workfront Fusion as well as 蜜豆视频 Workfront to use functionality described in this article.

To find out what plan, license type, or access you have, contact your Workfront administrator.

For information on 蜜豆视频 Workfront Fusion licenses, see 蜜豆视频 Workfront Fusion licenses.

Google Drive API information

The Google Drive connector uses the following:

Base URL
https://www.googleapis.com/drive/v3
API version
v3
API tag
v4.1.22

Connecting Google Drive to Workfront Fusion

If you are @gmail.com or @googlemail.com user you need to create an OAuth client on in order to obtain Client ID and Client Secret.

For step-by-step instructions on how to create the OAuth client (and obtain Client ID and Client Secret), see Connect 蜜豆视频 Workfront Fusion to Google Services using a custom OAuth client.

For instructions about connecting your Google Drive account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions

Google Drive modules and their fields

When you configure Google Drive modules, Workfront Fusion displays the fields listed below. Along with these, additional Google Drive fields might display, depending on factors such as your access level in the app or service. A bolded title in a module indicates a required field.

If you see the map button above a field or function, you can use it to set variables and functions for that field. For more information, see Map information from one module to another in 蜜豆视频 Workfront Fusion.

Triggers

Watch Files In Folder

Retrieves file details when a file is added or modified in the specified folder.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
Select the folder to be watched
Select the folder on your drive that you want to watch the files in.
What files to watch

Select which type of files you want to watch.

  • All
  • Google Documents
  • Google Spreadsheets
  • Google Slides
  • Google Drawings
Convert Google Documents files to format
Select the file format that you want to convert Google Documents to.
Convert Google Spreadsheets files to format
Select the file format that you want to convert Google Spreadsheets to.
Convert Google Slides files to format
Select the file format that you want to convert Google Slides to.
Convert Google Drawings files to format
Select the file format that you want to convert Google Drawings to.
Watch
Select whether you want to watch new files and all changes, or only new files.
Maximum number of downloaded files
Set the maximum number of results that Workfront Fusion will download during one cycle (the number of repetitions per scenario run).

Watch All Files

Retrieves file details when a file in your Google Drive is added or modified.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
What files to watch

Select which type of files you want to watch.

  • All
  • Google Documents
  • Google Spreadsheets
  • Google Slides
  • Google Drawings
Convert Google Documents files to format
Select the file format that you want to convert Google Documents to.
Convert Google Spreadsheets files to format
Select the file format that you want to convert Google Spreadsheets to.
Convert Google Slides files to format
Select the file format that you want to convert Google Slides to.
Convert Google Drawings files to format
Select the file format that you want to convert Google Drawings to.
Watch
Select whether you want to watch new files and all changes, or only new files.
Maximum number of downloaded files
Set the maximum number of results that Workfront Fusion will download during one cycle (the number of repetitions per scenario run).

Watch shared files

Triggers when a new file is shared to you, or an existing shared file is updated.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
Select the folder to be watched
Select the shared folder that you want to watch the files in.
What files to watch

Select which type of files you want to watch.

  • All
  • Google Documents
  • Google Spreadsheets
  • Google Slides
  • Google Drawings
Convert Google Documents files to format
Select the file format that you want to convert Google Documents to.
Convert Google Spreadsheets files to format
Select the file format that you want to convert Google Spreadsheets to.
Convert Google Slides files to format
Select the file format that you want to convert Google Slides to.
Convert Google Drawings files to format
Select the file format that you want to convert Google Drawings to.
Watch
Select whether you want to watch new files and all changes, or only new files.
Maximum number of downloaded files
Set the maximum number of results that Workfront Fusion will download during one cycle (the number of repetitions per scenario run).

Watch Comments

Triggers when a comment is added or modified on the selected file.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
File
Select the file that you want to watch for comments.
Watch
Select whether you want to watch for all changes or for new comments only
Maximum number of returned comments
Set the maximum number of comments that Workfront Fusion will return during one cycle (the number of repetitions per scenario run).

Actions

Upload a File

Uploads a file to your Google Drive.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
Destination

Select the destination that you want to upload a file to.

  • My Drive
  • Shared with Me
Target folder
Select the folder that you want to upload a file to.
Source file
Select whether you want to use a file passed in from a previous module, or if you want to map the file manually.
File name
Select the file name. This option is available if you select "Map" in the source file field.
Data
Select the data file that you want to upload. This option is available if you select "Map" in the source file field.
Title
Enter a title for the new file.
Convert a file
Enabling this option allows the module to convert files to the corresponding Google format.

Update a File

Updates a file鈥檚 metadata or content.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
Destination

Select the destination that you want to upload a file to.

  • My Drive
  • Shared with Me
Move to a folder
If you want to move the file to a different folder, select the folder that you want to move the file into.
File ID
Map the ID聽of the file that you want to update.
Title
Enter a title for the updated file.
Change a file content
Select whether you want to replace the content of the file.
Source file
Select whether you want to use a file passed in from a previous module, or if you want to map the file manually. This field is available if you selected to change the file's content in the previous field.
File name
Select the file name. This option is available if you select "Map" in the source file field.
Data
Select the data file that you want to upload. This option is available if you select "Map" in the source file field.

Copy a File

Copies a file to the new location.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
Destination

Select the destination that you want to upload a file to.

  • My Drive
  • Shared with Me
Target folder
Select the folder where the file you want to copy is located/
File ID
Map the ID聽of the file that you want to update.
The name of the copy
Enter a title for the new file. Leave this field blank if you do not want to change the original file name.

Delete a File

Permanently deletes a file or folder.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
File ID
Map the ID聽of the file that you want to delete.

Move a File/Folder to Trash

Moves a file or folder to the trash.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
File ID
Map the ID聽of the file that you want to move to the trash.

Get a file

Retrieves the file with the ID specified.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
Convert Google Documents files to format
Select the file format that you want to convert Google Documents to.
Convert Google Spreadsheets files to format
Select the file format that you want to convert Google Spreadsheets to.
Convert Google Slides files to format
Select the file format that you want to convert Google Slides to.
Convert Google Drawings files to format
Select the file format that you want to convert Google Drawings to.
File ID
Map the ID聽of the file that you want to retrieve.

Search for Files/Folders

Searches for files or folders based on search criteria.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
Destination

Select the destination that you want to search.

  • My Drive
  • Shared with Me
List a folder
Navigate to the folder you want to search for the files or folders.
Retrieve
Select whether you want to search for files, folders, or both.
Search

Select the type of the search you want to perform.

  • Search within file/folder names

    • Query

      Enter a part of the file name or full file name (including the suffix) you want to search.

    • Search Options

      Select whether you want to search for the exact term, or if you want to search for names containing the search term.

  • Fulltext search

    • Query

      Enter any search term you want search in your Google Drive.

  • Enter custom search query

    • Query

      Enter the custom search query. For more details, please refer to the Search for Files section of this article.

    • Add the folder selected above to the query

      Searches for the folder n the parents collection. This finds all files and folders located directly in the folder selected above.

Maximum number of returned results
Set the maximum number of files or folders Workfront Fusion will return during one execution cycle.
Continue the execution of the route even if the module returns no results
Enable this option to ensure that the scenario is not stopped if the module returns no results.

Create a Folder

Creates a folder in the specified location.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
Destination

Select the destination that you want to upload a file to.

  • My Drive
  • Shared with Me
New folder location
Navigate to the location where you want to create a new folder.
The name of the new folder
Enter a name for the folder that you are creating.
Share folder
Select this option if you want to share the folder with anyone with the Share link. Otherwise, the share link is for the owner only.

Retrieves the share link for a file in Google Drive.

Connection
For instructions about connecting your Google Drive account to Workfront Fusion, see Connecting Google Drive to Workfront Fusion
File ID
Map the ID聽of the file that you want to get the share link for.

Troubleshooting

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, for example, the attribute name of the file.

  • Operator - Test that is performed on the data to provide a match, for example, contains.

  • Value - The content of the attribute that is tested, for example, the name of the file My cool document.

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

Fields

Field
Value Type
Operators
Description
title
string
contains1, =, !=
Name of the file.
fullText
string
contains2, 3
Full text of the file including name, description, content, and indexable text.
mimeType
string
contains, =, !=
MIME type of the file.
modifiedDate
date4
<=, <, =, !=, >, >=
Date of the last modification to the file.
lastViewedByMeDate
date4
<=, <, =, !=, >, >=
Date that the user last viewed a file.
trashed
boolean
=, !=
Whether the file is in the trash or not.
starred
boolean
=, !=
Whether the file is starred or not.
parents
collection
in
Whether the parents collection contains the specified ID.
owners
collection
in
Users who own the file.
writers
collection
in
Users who have permission to modify the file.
readers
collection
in
Users who have permission to read the file.
sharedWithMe
boolean
=, !=
Files that are in the user's "Shared with me" collection.
properties
collection
has
Public custom file properties.

Consider the following about operators in these fields:

  • The contains operator only performs prefix matching for a title.

    For example, the title 鈥淗elloWorld鈥 matches for title contains 'Hello' but not for title contains 'World'.

  • The contains operator only performs matching on entire string tokens for fullText.

    For example, if the full text of a doc contains the string 鈥淗elloWorld鈥 only the query fullText contains 'HelloWorld' returns a result. Queries such as fullText contains 'Hello' would not return results in this scenario.

  • The contains operator matches on an exact alphanumeric phrase if it is surrounded by double quotes.

    For example, if the fullText of a doc contains the string 鈥淗ello there world鈥, then the query fullText contains '"Hello there"' returns a result, but the query fullText contains '"Hello world"' does not.

    Furthermore, because the search is alphanumeric, if the fullText of a doc contains the string 鈥淗ello_world鈥, then the query fullText contains '"Hello world"' returns a result.

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

Value types

Value Type
Notes
String
Surround with single quotes '. Escape single quotes in queries with \', e.g., 'Valentine\'s Day'.
Boolean
true or false.
Date
RFC 3339 format, default timezone is UTC, e.g., 2012-06-04T12:00:00-08:00.

Operators

Operator
Notes
contains
The content of one string is present in the other.
=
The content of a string or boolean is equal to the other.
!=
The content of a string or boolean is not equal to the other.
<
A date is earlier than another.
<=
A date is earlier than or equal to another.
>
A date is later than another.
>=
A date is later than or equal to another.
in
An element is contained within a collection.
and
Return files that match both clauses.
or
Return files that match either clause.
not
Negates a search clause.
has
A collection contains an element matching the parameters.

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>q</q> parameter, where title = 'hello' is encoded as title+%3d+%27hello%27. Client libraries handle this encoding automatically.

  • Search for files with the name 鈥渉ello鈥

    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 鈥渉ello鈥 and 鈥済oodbye鈥

    title contains 'hello' and name contains 'goodbye'

  • Search for files with a name that does not contain the word 鈥渉ello鈥

    not title contains 'hello'

  • Search for files containing the word 鈥渉ello鈥 in the content

    fullText contains 'hello'

  • Search for files not containing the word 鈥渉ello鈥 in the content

    not fullText contains 'hello'

  • Search for files containing the exact phrase 鈥渉ello 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 .

    '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 鈥渋mportant鈥 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 鈥渉ello鈥 in the name

    sharedWithMe and title contains 'hello'

  • Search for files with a named additionalID with the value 8e8aceg2af2ge72e78.

    properties has { key='additionalID' and value='8e8aceg2af2ge72e78' and visibility='PRIVATE' }

Source of this guide is .

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43