

This worked, but had (and would still have) big limitations.

What I ended up doing to get around my own fear of learning new things was to set up drive to sync with a local directory on my machine and use R to read files that would be synced with google drive every X hours.


Once upon a time I too had a job requirement to view/read in various files on google drive but only knew R and even then didn't even think to look into getting api credentials. I would really recommend trying out their interactive tutorial because it's probably going to be your best bet to learn the basics and get something up and running. It looks like they also have a little interactive tutorial page set up that should guide you through connecting to drive and viewing files.įrom there it's really just a matter of building a wrapper function (or a Class is you fee brave) that does an operation you need and googling around to see what the best methods are. Here's their quickstart page for python users which can actually be very useful, though maybe a bit daunting at first. So, yes and technically no, but really yes. All I'd like is a little program I can open and run in Colab and call it a day. I'm hoping that somebody can point me in the right direction here. One of my questions is about whether or not it would be easier to make this code run locally on my computer (so that I can use things like webbrowser.open instead of Javascript stuff). I also found some stuff on StackExchange about how I can open a browser tab which, because I'd prefer to use Colab, requires some JavaScript which I don't know at all. So far I have a script that reads a Google Sheet and imports that data into lists to be used later when I search the drive. The internet tells me I'll need the Google Drive API, but whenever I went to try to set everything up on my google dev page, a lot of things are going over my head and it seems like it's all a lot more than I actually need to do the job. I know Python decently, but I'm a physicist so this is a little bit out of my wheel house. This can get pretty tedious and annoying to manage, so I'm trying to automate the process by writing a program in Google Colab that reads a Google Sheet, which is where it can find the names of the files I'll need for the day, then search my google drive for those names and, if those names are in the drive, open the files in different tabs. So my job requires that I open up a bunch of google drive files all in separate windows at the beginning of my work day.
