There is also a much easier, but less clean solution, if you don’t want to bother with the API or Google Authentication. Go to your Spreadsheet in Google Drive. Go to File -> Publish to the Web In the Publish to the web dialog you can get a .csv Link to your spreadsheet. You can … Read more
The documentation on insert operations already contains examples in a bunch of programming languages, here is how to do it using the HTTP based protocol of the Google Drive API. First, POST the new file metadata to the Drive endpoint. It has to be in the form of a File resource JSON object: POST /drive/v2/files … Read more
In my opinion the easiest and fastest way to get a Google Drive file ID is from Google Drive on the web. Right-click the file name and select Get shareable link. The last part of the link is the file ID. Then you can cancel the sharing.
It is possible to use the Google APIs Javascript client library with Drive but you have to be aware that there are some pain points. There are 2 main issues currently, both of which have workarrounds: Authorization First if you have a look closely at how Google Drive auth works you will realize that, after … Read more
One thing you could do (this of course depends on what you are trying to accomplish) is: Store the necessary information (i.e. like a loop counter) in a spreadsheet or another permanent store(i.e. ScriptProperties). Have your script terminate every five minutes or so. Set up a time driven trigger to run the script every five … Read more
Google Docs: application/vnd.google-apps.document application/vnd.google-apps.kix Google Presentations: application/vnd.google-apps.presentation Google Spreadsheets: application/vnd.google-apps.spreadsheet Google Drawing: application/vnd.google-apps.drawing See here for more information. Here is a long list of Google Docs and Google Drive MIME types (it is not exhaustive): application/vnd.google-apps.audio application/vnd.google-apps.document application/vnd.google-apps.drawing application/vnd.google-apps.file application/vnd.google-apps.folder application/vnd.google-apps.form application/vnd.google-apps.fusiontable application/vnd.google-apps.kix application/vnd.google-apps.photo application/vnd.google-apps.presentation application/vnd.google-apps.script application/vnd.google-apps.sites application/vnd.google-apps.spreadsheet application/vnd.google-apps.unknown application/vnd.google-apps.video
In the new Google API Console, configure your OAuth2.0 authorized origins from Your Project > APIs & auth > Credentials You might need to add a new Client ID specifically for a web application (I did because the default was for AppEngine) Create Client ID > Web Application > Authorized Javascript origins If you are … Read more
How about this method? When the file is such large size, Google returns a code for downloading the file. You can download the file using the code. When such large file is downloaded using curl, you can see the code as follows. <a id=”uc-download-link” class=”goog-inline-block jfk-button jfk-button-action” href=”/uc?export=download&confirm=ABCD&id=### file ID ###”>download</a> The query with confirm=ABCD … Read more
Update December 8th, 2015 According to Google Support using the googledrive.com/host/ID method will be turned off on Aug 31st, 2016. I just ran into this issue. The trick is to treat your Google Drive folder like a web host. Update April 1st, 2015 Google Drive has changed and there’s a simple way to direct link … Read more
DriveApp is indeed missing a getFileByUrl (and also folder for that matter). You may want to open an enhancement request on Apps Script issue tracker. But what I do on my scripts (since these openByUrl functions are somewhat new), is to get the id using a regex. Like this. function getIdFromUrl(url) { return url.match(/[-\w]{25,}/); } … Read more