Download files from a Google Drive
This Action also works when accessing the web through a PROXY server: Please consult the section 18.104.22.168. for more details on this subject.
To be able to use this Action, you need to get these 3 parameters from Google: (1) your “Client ID”, (2) your “Client Secret”, (3) your “Refresh Token”. To get these 3 parameters, you must use the “Unlock Google Services” action detailed in section 5.22.11.
The GDriveDownload Action expects a table with (at least) 2 columns in input:
1.A column containing the “Remote File ID to download”: All the files in a gdrive are uniquely identified by their “File ID” (and not by their filepath). So, to download a file from your GDrive, you first need to get its “File ID”. There are two ways to get a “File ID”:
oUse the GDriveList Action from the previous section (section 5.22.11): This action gives as output a column named “FileID” that contains thea “File ID” that you want.
oNavigate on your GDrive (using a web-browser) to the file that you want to download and right-clik it: . Then, select the “Get shareable link” option:
You receive an URL inside your clipboard that looks like this:
The “File ID” (that you are searching for) is the “id” parameter inside the url.
For example, in the above url, your “File ID” is: 0BwGsipwcl6WCc3RhcnRlcl9maWxlX2Rhc2hlclYw
2.A column containing the local filepath (i.e. the file path + the file name + the file extention) of the file(s) to create locally.
One option to create this second required column is to use the column named “Filename” originating from the GdriveList Action. Unfortunately, this won’t always work properly because, for example, the “Google Spreadsheet files” do not have any extention (i.e. they should have a .xlsx extention but it’s missing). So, for your convenience, the GdriveList Action also outputs another column named “FilePathWithExtention” that, basically, adds the missing file extentions to the “Google Spreadsheet” files, the “Google document” files, etc.
Here is a small example of usage of the GDriveDownload Action: