Common use cases

Data Management

Application

Google Drive

Inputs (what you have)

Title	Description	Data Type	Required?	Example
Folder link	Link to the Google Drive folder being searched	URL	Yes	`https://drive.google.com/drive/folders/1AGivk11BManKUk1PVA?ths=true`
Maximum number of results		Predefined Choice List	Yes
File type	The type of file you want to retrieve	Predefined Choice List	No	PDF File
File name	The name of the file you want to retrieve	Text(Short)	No	file-1
Minimum file size in megabytes	The minimum size of the file	Integer	No	50
Maximum file size in megabytes	The maximum size of the file	Integer	No	200
Owner full name	The owner of the files name	Text(Short)	No	John Doe

Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data library section. These variables in the Data library section are the outputs of previous Wrk Actions in the Wrkflow.

Outputs (what you get)

Name	Description	Data Type	Example
File name	Name of the file	Text(short)	file-1
File link	Link to the file	string	`https://docs.google.com/spreadsheets/d/123/edit?usp=drivesdk`
Created date and time	Creation date and time of the file	Date and time	2023-01-13T18:07:39.746Z
Last modified date and time	Last modified date and time of the file	Date and time	2023-01-13T18:07:53.920Z
Owners	Full name(s) of the owners of the file	Text(short)	Jane Doe
File size in bytes	Size of the file in bytes	Integer	1024
Last modifying user	Full name of the last user to modify the file	Text	Janet Smith
PDF download link	Link to convert and download the file to a PDF if applicable.	URL	`https://docs.google.com/spreadsheets/export?id=123&exportFormat=pdf`
PPTX download link	Link to convert and download the file to a PPTX if applicable.	URL	`https://docs.google.com/feeds/download/presentations/Export?id=123&exportFormat=pptx`
CSV download link	Link to convert and download the file to a CSV if applicable.	URL	`https://docs.google.com/spreadsheets/export?id=123&exportFormat=csv`
Excel download link	Link to convert and download the file to an Excel document if applicable.	URL	`https://docs.google.com/spreadsheets/export?id=123&exportFormat=xlsx`
Word download link	Link to convert and download the file to a Word document if applicable.	URL	`https://docs.google.com/feeds/download/documents/export/Export?id=123&exportFormat=docx`
Media type	The media type of the file	Text(short)	folder

Outcomes

Name	Description
Success	This status is selected if the files were successfully searched for using the provided criteria
No Result	This status is selected in the event of the following scenarios: No files are found using the provided search criteria
Unsuccessful	This status is selected in the event of the following scenarios: The external system is not accessible The Google Drive link provided is not valid The credentials do not have access to the Google Drive link provided

Requirements

The provided file must give editing permissions to googlewrkbots@wrk.com
Editing permissions to googlewrkbots@wrk.com should also be given to all source and destination folders
- If the file is nested in multiple folders editing permission to googlewrkbots@wrk.com should be given to every folder

Copy file in Google Drive

Download file from Google Drive

Upload file to Google Drive

Edit cell value in Google Sheets

Move file in Google Drive