| Next revision | Previous revisionNext revisionBoth sides next revision |
| transformations:googledrivecommand [2020/10/06 04:57] – created dmitry | transformations:googledrivecommand [2021/07/04 22:54] – [List files settings] craigt |
|---|
| ===== Google Drive Command ===== | {{ transformations:GoogleDriveCommandAction.png}} |
| | ====== GOOGLE DRIVE COMMAND ====== |
| | Category: Workflow / App/Cloud\\ |
| |
| The action performs a file operation with Google Drive. Requires a configured connector "Google Drive". | \\ |
| | =====Description===== |
| | This action performs file operations with Google Drive. A configured [[connectors:airtable|Google Drive connector]] is required. |
| |
| === Available commands === | \\ |
| | =====Action settings===== |
| | ^ Setting ^ Description ^ |
| | |Connector<sup>*</sup>|Select the preconfigured Google Drive connector, or, build one by selecting //Add connector//.\\ See [[connectors:airtable|Google Drive connector]] for details.| |
| | |Command|Select the file operation this action will perform. Options: //List files//, //Download file//, //Download list of files//, //Upload file//, //Upload list of files//, //Delete file//, or //Delete list of files//. See below for details of each command type.| |
| | <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| |
| ^ Command ^ Description ^ | \\ |
| |List files | Produce a list of files in a specified folder on Google Drive. | | ====List files settings==== |
| |Download file | Download a single file from Google Drive to a local folder. | | **Description:** Produce a list of files, with selected file properties, in a specified folder on Google Drive. |
| |Download list of files | Download files which paths are specified in a column in the action's input dataset. Typically, the list is produced using the "List files" command and optionally filtered using EasyMorph actions. | | ^ Setting ^ Description ^ |
| |Upload file | Upload a single local file to a specified folder on Google Drive. | | |Folder<sup>*</sup>|Select a subfolder (under the "My Drive" folder) to access. By default, this action will access the "My Drive" root folder (no value appears in the Folder field).| |
| |Upload list of files | Upload files which paths are specified in a column in the action's input dataset. Typically, the list is produced using the [[transformations:filelist|"List of files" action]] and optionally filtered using EasyMorph actions. | | |Columns|Select the details of the found files to be included in the dataset. Each detail produces a column. Options: //File name with full path//, //File name only//, //File extension//, //Size//, //Date created//, //Date modified//, and //MIME type//.| |
| |Delete file | Delete a single file on Google Drive. | | <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| |Delete list of files | Delete files which paths on Google Drive are specified in a column in the action's input dataset. Typically, the list is produced using the the "List files" command and optionally filtered using EasyMorph actions.| | |
| |
| | \\ |
| | ====Download file settings==== |
| | **Description:** Downloads the specified file from Google Drive to the local location defined. |
| | ^ Setting ^ Description ^ |
| | |File path<sup>*</sup>|Enter or browse to the file in Google Drive to be downloaded.| |
| | |Local folder<sup>*</sup>|Enter or browse to the local folder to download the file to.| |
| | |If a file with such name already exists|Select how EasyMorph will handle saving the file if a file with the same name exists in the destination folder. Options: //Overwrite//, //Do nothing//, or //Halt project execution//. See the "File already exists" table below.| |
| | <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| |
| === See also === | \\ |
| | ====Download list of files settings==== |
| | **Description:** Downloads multiple files specified in a column in the action's input dataset. |
| | ^ Setting ^ Description ^ |
| | |File list|Select the table column containing the list of fully qualified file names to be downloaded.| |
| | |Local folder<sup>*</sup>|Enter or browse to the local folder to download the files to. This action will //overwrite// files with the same name(s)\\ that already exist(s) in the destination folder.| |
| | <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| | |
| | \\ |
| | ====Upload file settings==== |
| | **Description:** Uploads the specified local file to the defined Google Drive folder. |
| | ^ Setting ^ Description ^ |
| | |File path<sup>*</sup>|Enter or browse to the local file to upload.| |
| | |Target folder<sup>*</sup>|Enter or browse to a Google Drive folder to upload the file to.| |
| | |If a file with such name already exists|Select how EasyMorph will handle saving the file if a file with the same name exists in the destination folder. Options: //Overwrite//, //Do nothing//, or //Halt project execution//. See the "File already exists" table below.| |
| | <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| | |
| | \\ |
| | ====Upload list of files settings==== |
| | **Description:** Uploads multiple files specified in a column in the action's input dataset. |
| | ^ Setting ^ Description ^ |
| | |File list|Select the table column containing the list of fully qualified local file names to be uploaded.| |
| | |Target folder<sup>*</sup>|Enter or browse to a Google Drive folder to upload the files to. This action will //overwrite// files with the same name(s)\\ that already exist(s) in the destination folder.| |
| | <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| | |
| | \\ |
| | ====Delete file settings==== |
| | **Description:** Deletes the specified file stored on Google Drive. |
| | ^ Setting ^ Description ^ |
| | |File path<sup>*</sup>|Enter or browse to the remote file to delete.| |
| | |If the file doesn't exist|Select how EasyMorph handles situations when the specified file does not exist. Options: //Do nothing// (nothing happens, the workflow continues, no error is displayed), or //Halt project execution// (workflow stops, an error is displayed).| |
| | <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| | |
| | \\ |
| | ====Delete list of files settings==== |
| | **Description:** Deletes multiple files specified in a column in the action's input dataset. |
| | ^ Setting ^ Description ^ |
| | |File list|Select the table column containing the list of fully qualified Google Drive file names to be deleted.| |
| | |If a file from the list doesn't exist|Select how EasyMorph handles situations when a file in the list does not exist. Options: //Ignore// (nothing happens, the workflow continues, no error is displayed), or //Halt project execution// (workflow stops, an error is displayed).| |
| | <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| | |
| | \\ |
| | ====File already exists options==== |
| | ^Option ^Description ^ |
| | |Overwrite|The new file replaces the original file.| |
| | |Do nothing|No file is downloaded/uploaded, the workflow does not halt, and no error is displayed.| |
| | |Halt project execution|The project will stop processing and this action will display an error.| |
| | |
| | \\ |
| | =====Remarks===== |
| | The easiest way to build a list of remote files on a Google Drive to be downloaded or deleted is to use this action in its //File list// configuration, including the "File name with full path" option. This list can then be modified to generate the final list of files to be downloaded or deleted. |
| | |
| | If building the list manually, the root folder is the "My Drive" folder with subfolders falling underneath. To reference a file in the root My Drive folder, just list the filename. e.g., "MyFile". When defining subfolders, list the subfolder name followed by a forward-slash ("/") and the filename, or subsequent subfolders. e.g., "MySubFolder / MyFile" or "SubFolder1 / Subfolder2 / MyFile" (extra spaces added for clarity). |
| | |
| | \\ |
| | =====See also===== |
| * [[transformations:filecommand|File command]] | * [[transformations:filecommand|File command]] |
| * [[transformations:filelist|List of files]] | * [[transformations:filelist|List of files]] |
| * [[transformations:importgooglesheets|Import from Google Sheets]] | * [[transformations:importgooglesheets|Import Google Sheets]] |
| * [[transformations:exportgooglesheets|Export to Google Sheets]] | * [[transformations:exportgooglesheets|Export Google Sheets]] |
| |
