Download file from google drive in r

Is there a way I can download a drive's full contents based on the Drive ID from the URL? If so, how would I go about doing this?

The package allows you to programmatically download files from your google drive account. After you load the package, run to list files which will give you an opportunity to give R access and, if you wish, to cache your logon credentials for R to use in future sessions. You might want to set the argument of to a low number if you're trying that out interactively, as it will return a list of files in your google drive.

allows you to download files. See the linked Vignette for details.

I'm not sure what you mean by the ID. As long as you have the google account login credentials you can use the package to do the download. When you run the first time, a browser window will pop up asking you to authorize R to access the account. After that you should be good to go with the method described above.

If I understand correctly, @realhiphop is talking about a file ID? I think we are confused by this wording:

"download a drive's full contents"
"use the ID to format file by file"

Are you asking how to download the "full contents" of a single file on Google Drive or all files included someone's Google Drive? Or all files in a specific folder on Google Drive? Those are three different questions.

To download a file based on its ID or URL:

What exactly is the ID you are talking about?

Sorry for the lack of clarity everyone!

I have the following URL to a shared drives folder contents. I'd like to be able to download either all of the contents, or specific files.

The URL is: www.cronistalascolonias.com.ar

The ID I was referring to is "0B7tJg2i5HAo2c0VzVFVhLUdQcnM"

If you use "Add to My Drive" (see below), you can map , as @joels described.

OK that is the "file ID" for a folder on Drive. Here's how to download the csv files within it, based just on the URL.

^{Created on by the reprex package (v)}

Jenny-

Thank you so much! Worked perfectly on the CSV files. I tried to do a drive download of all files in the folder.

I'm getting the following error:

It downloads a bunch of files before hitting this error. Any idea why?

Hard to say. Perhaps you don't have necessary permission for every single file or perhaps there are subfolders. Folders cannot be downloaded. You could wrap the call in and use instead of to proceed past failures and store the result. Then you could inspect the failures more closely.

Thanks Jenny. I tried doing exactly what you said with the corresponding code:

I wasn't sure if I formatted your code properly so then I tried:

This got most of the files, but it stopped before getting all of the files.

is an adverb. You apply it to a function.

So, more like caveat: untested cde

Just passing by to say that I had the exact same problem and this solution worked perfectly for me, thanks Jenny!

All of the files are in .csv format. How would I go about using Google Drive to download the full contents, or at a minimum, use the ID to format file by file?

Note that you'd have to somehow go through and download the files in bulk— in the same way that people read a batch of csv files in from a folder. With Google native formats, you have to export them to something else, see:

We can download files from Google Drive. Native Google file types (such as Google Documents, Google Sheets, Google Slides, etc.) need to be exported to some conventional file type. There are reasonable defaults or you can specify this explicitly via or implicitly via the file extension in .

So, in terms of your broader question, can you download the full contents with a URL, it depends…but there's not a built-in mechanism to do so.

realhiphop:

use the ID to format file by file

I'm actually not sure what ID this is, because googledrive (the tidyverse package) uses oauth, I don't think you actually use this type of ID directly. So, I think the answer to your initial question (at least with this package) might be no (@joels, I don't know if there's something else you were thinking of).

tidyverse/googledrive/blob/ecdc5bb0afb51fb0cdf2c/R/drive_auth.R

@mara, the method I tested for downloading files is as follows:

This downloaded the first 10 files in my google drive to the local directory.

So, to download all of the files in your google drive, you could do:

If you have lots of file types and just want to download the csv files:

Thanks Joel. Is there a way to do this on someone else's shared google drive if I have the ID as part of the URL?

Yeah, I was speaking specifically to the ID thing. I don't know how that would work with the auth setup.