ÃÛ¶¹ÊÓƵ

Google Drive modules

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.

For instructions on creating a scenario, see the articles under Create scenarios: article index.

For information about modules, see the articles under Modules: article index.

Access requirements

Expand to view access requirements for the functionality in this article.

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

table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
ÃÛ¶¹ÊÓƵ Workfront package Any
ÃÛ¶¹ÊÓƵ Workfront license

New: Standard

Or

Current: Work or higher

ÃÛ¶¹ÊÓƵ Workfront Fusion license**

Current: No Workfront Fusion license requirement.

Or

Legacy: Workfront Fusion for Work Automation and Integration

Product

New:

  • Select or Prime Workfront package: Your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion.
  • Ultimate Workfront package: Workfront Fusion is included.

Or

Current: Your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion.

For more detail about the information in this table, see Access requirements in documentation.

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 use @gmail.com or @googlemail.com user you must create an OAuth client on the Google Cloud Platform to obtain your 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.

Map toggle

Triggers

Watch all files

This trigger module starts a scenarion 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 Comments

This trigger module starts a scenario 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).

Watch files in folder

This trigger module starts a scenario 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 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).

Actions

Copy a file

This action module 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 copy a file to.

  • My Drive
  • Shared with Me
Target folder
Select the folder that contains the file you want to copy.
File ID
Map the ID of the file that you want to copy.
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.

Create a folder

This action module 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 where you want to create a folder.

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

Delete a file

This action module 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.

Get a file

This action module 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.

This action module 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.

Move a file to trash

This action module 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.

Search for Files/Folders

This search module 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 drive 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.

Update a File

This action module updates a file’s 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 contains the file you want to update.

  • My Drive
  • Shared with Me
Move to a folder
If you want to move the file to a specific 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
If you are replacing the content, select a source file from a previous module, or map the source file's name and data.
Conver a file
Enable this option to convert the file to the corresponding Google file format.

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 a source file from a previous module, or map the source file's name and data.
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.

Troubleshooting

Unable to upload or update a file

There are several reasons that 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. In this case, the scenario stops and you must select a different target folder in the module.
recommendation-more-help
7e1891ad-4d59-4355-88ab-a2e62ed7d1a3