I'll just use the regular built in DriveApp to play around with folder and file names as it's a little easier that way. A question in the Apps Script community prompted me to write this post about file conversion and the nature of files on Drive. It needs to use Advanced Drive to be able to get access to these Urls - which means you'll need to authorize the Advanced Drive service in Apps Script and in the developer console. If running the script for first time, it will ask for your authentication.
To execute, click, or from the Run menu, select a function. Go to File > Save > add script name > Click OK. It needs a little sugar, since the op wants to use folder and file names rather than file IDS, but that's simple enough. To create and run a script in Drive, follow these steps: Create/open a Google Doc or Sheet. So to get back to the community question, how to schedule something that converts a sheet to an excel file every now and again, the solution is simple. No coding or conversion needed - just fetch the blob at the Url. You can get more information on each of these mimetypes here. Google Apps Scripts can be created as standalone files in Drive, inside a document or spreadsheet (these are known as container-bound), or in a Google Site.
In the current stage, when you transfer the ownership of your file on your Google Drive to another user and/or copy the file Shared with me to the specific folder on your Google Drive, the file becomes the shortcut file. So this tells me that, simply by retrieving the blob at each of those Urls, I can convert a sheet to ods, pdf, xlsx, csv, and zip. Gists This is a sample script for retrieving the files of ‘Shared with Me’ in the specific folder using Google Apps Script.
0 kommentar(er)
