ggsrun was updated to v.1.3.0 From this version, container-bound scripts can be downloaded. The container-bound script is the script created at the script editor on Google Sheets, Docs, or Forms file. In order to download container-bound scripts, the project ID of container-bound scripts is required. The project ID can be retrieved as follows. Open the project. And please operate follows using click. -> File -> Project properties -> Get Script ID (This is the project ID.
Gists This is a sample script for retrieving values by header title for Spreadsheet. This is created by Google Apps Script. The main script is as follows. Main script : When the instance is retrieved, all data of the sheet is analyzed. So when the each value is retrieved, the speed is fast. function GetValueByKey(sheetname) { return new getValueByKey(sheetname); }; (function(r) { var getValueByKey; getValueByKey = (function() { getValueByKey.
Gists This is a sample script for exporting a project on Google Drive to local PC using Golang Quickstart. A file with refresh token is saved to the same directory with this script as go-quickstart.json. Before you run this script, please enable Drive API on your Google API console. Points for exporting project In order to export project, both drive.DriveScriptsScope and drive.DriveScope have to be included in the scope. The mimeType for exporting has to be “application/vnd.
OnedriveApp was updated to v1.0.2. Moved the instance of PropertiesService.getScriptProperties() to outside of this library. When there is the PropertiesService.getScriptProperties() inside the library, it was found that the parameters that users set was saved to the library. So this was modified. I’m sorry that I couldn’t notice this situation. GitHub of OnedriveApp
OnedriveApp was updated to v1.0.1. Added a method for retrieving access token and refresh token using this library. By added this method, OneDrive APIs can be used by only this library. GitHub of OnedriveApp