Google Drive package

Automate tasks related to files and folders by using the actions in the Google Drive package.

Before you start

Use the actions in the Google Drive package in the following order:

Use the Connect action to establish a connection to the Google server.
See Using the Connect action for Google packages.
Use a combination of actions available in this package to automate tasks.
Note: To use actions from other Google packages, establish a connection using the Connect action from that package.
Use the Disconnect action to terminate the connection.

Actions in the Google Drive package

The Google Drive package includes the following actions:


Action	Description
Check permissions	Checks for a file or folder permissions and returns `read`, `write`, or `delete` to a list variable. Enter the same username that you provided in the Connect action. Select whether to check permissions for a file or a folder. Select File or Folder and enter the name and path to the file or folder. To check the permissions of files shared with you in Google Drive, select File ID to enter the file id. You can extract the file id from the URL of the file name and enter it in the File ID field. Note: If you select the File ID option, the user with a Commenter role with the write access will observe that the bot does not check the write permission and returns the value as false. To check the various kinds of permissions, select Read, Write, or Delete. This returns read, write, or delete to a Boolean variable. Select or create a Boolean variable to hold the permissions.
Copy file	Copies a file from one folder to another in the Google Drive. Enter the same username that you provided in the Connect action. Select whether to identify the source file by file path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Select whether to identify the destination folder by directory path and name, or by ID. Optional: Mark the Rename file option and enter the new file name.
Copy folder	Copies a folder from one location to another. Enter the same username that you provided in the Connect action. Select whether to identify the source file by folder path and name, or by ID. If this is a shared folder, you must use the Folder ID option. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Select whether to identify the destination folder by directory path and name, or by ID.
Create file permission	Creates a new permission for a file. Enter the same username that you provided in the Connect action. Select whether to identify the file by file path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Select a role. For more information, see Google Drive Roles. Select the grantee type. Choose from: User Group Domain Anyone If you select User or Group, enter the email address. If you select domain, enter the domain. Optional: Select or create a variable to hold the permission ID.
Create folder	Creates a folder. Enter the same username that you provided in the Connect action. Enter the parent folder where to create the folder. To create the folder in the root folder enter `root`. Enter the folder name. Optional: Select or create a string variable to hold the ID of the new folder.
Delete file	Deletes a file on your Google Drive. Enter the same username that you provided in the Connect action. Select whether to identify the file by file path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Optional: Select or create a boolean variable to hold the file delete status.
Delete file permission	Deletes a file permission for a file. Enter the same username that you provided in the Connect action. Select whether to identify the file by file path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. In the Permission id field, enter the permission ID. Optional: Select or create a variable to hold the permission ID.
Delete folder	Deletes a folder from the Google Drive. Enter the same username that you provided in the Connect action. Select whether to identify the folder by path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://drive.google.com/drive/folders/0B0MqCb--3Y8QQzlJcVRJb3UxcTg`, the ID is `0B0MqCb--3Y8QQzlJcVRJb3UxcTg`. Optional: Select or create a boolean variable to hold the folder delete status.
Download file	Downloads a file from your Google Drive to a specific location on your desktop. Enter the same username that you provided in the Connect action. Select whether to identify the file by file path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Specify the download file path. For example, C:/Users/Downloads. Optional: Mark the Overwrite existing file option to overwrite the file of the same name. Optional: Mark the Rename file option to enter a new name for the downloaded file. Optional: Select or create a variable to hold the ID of the downloaded file.
Find file/folder	Finds files or folders in a specific directory in your Google Drive. Enter the same username that you provided in the Connect action. Select whether to search for files or folders. Enter the source folder to search in. For example, /Home/Accounts/. Specify whether to return exact matches or Enter the file or folder name to search for. Select or create a variable to hold the list of files or folders.
Get file information	Gets file information of a file. Enter the same username that you provided in the Connect action. Select whether to identify the file by file path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Select or create a dictionary variable to hold the file information which is stored in two keys: the `name` key holds the file name and the `extension` key holds the file extension.
Get file permission	Retrieves file information for specific file or folder from Google Drive. Enter the same username that you provided in the Connect action. Select whether to identify the file by file path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Select or create a list variable to hold the file permissions.
Move file	Moves a file from one folder to another. Enter the same username that you provided in the Connect action. Select whether to identify the file by file path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Select whether to identify the destination folder by directory path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`.
Move folder	Moves a folder from one location to another. Enter the same username that you provided in the Connect action. Select whether to identify the source file by folder path and name, or by ID. If this is a shared folder, you must use the Folder ID option. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Select whether to identify the destination folder by directory path and name, or by ID.
Open file	Opens a file from the specified directory in Google Drive. Enter the same username that you provided in the Connect action. Select whether to identify the file by file path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`.
Open folder	Opens a folder from the specified directory in Google Drive. Enter the same username that you provided in the Connect action. Select whether to identify the folder by directory path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`.
Rename file	Renames a file in the Google Drive. Enter the same username that you provided in the Connect action. Select whether to identify the file by file path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Enter the new file name.
Rename folder	Renames a folder in a specific directory in Google Drive. Enter the same username that you provided in the Connect action. Select whether to identify the folder by directory path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Enter the new folder name.
Upload file	Uploads a file from the desktop to your Google Drive. Enter the same username that you provided in the Connect action. Enter the file path and name. Select whether to identify the folder where to upload the file by directory path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. Optional: Mark the Overwrite existing file option to overwrite the file of the same name. Optional: Select or create a variable to hold the ID of the uploaded file.
Update file permission	Update the permissions for a file. Select whether to identify the file by file path and name, or by ID. Note: The ID is the value in the URL after the last forward slash. For example, if the URL is `https://docs.google.com/spreadsheets/d/12dlAwvrEA4JeLysfFky9`, the ID is `12dlAwvrEA4JeLysfFky9`. In the Permission id field, enter your user ID. Select a role. For more information, see Google Drive Roles. Optional: Select or create a variable to hold the permission ID.

Automation 360