tanaike

The Thinker

Letting Users Running Google Apps Script on Google Spreadsheet without both Authorizing Scopes and Showing Script

Gists This is a sample workaround for letting users running Google Apps Script on Google Spreadsheet without both authorizing the scopes and showing the script. The flow of this workaround is as follows. Create Web Apps created by Google Apps Script and deploy it as Web Apps. As the returned value, the XML data is returned. Your script can be included in this script. User put a formula of =IMPORTML("WebApps URL", "xpath") to a cell.

Uploading Movie File on Google Drive to YouTube using Google Apps Script

Gists This is a sample script for uploading a movie file on Google Drive to YouTube using Google Apps Script. Before you use these scripts, please enable YouTube API at Advanced Google services. Ref Sample script 1 This sample script uses YouTube API at Advanced Google services. function myFunction() { const fileId = "###"; // Please set the file ID of movie file on the Google Drive. const res = YouTube.

Updating Values of Sheet A with Values of Sheet B using Google Apps Script

Gists This is a sample script for updating the values of “Sheet A” with the values of “Sheet B” using Google Apps Script. I often see this situation at Stackoverflow and other sites. So, in this post, I would like to introduce the sample script using Google Apps Script. Sample script function myFunction() { const ss = SpreadsheetApp.getActiveSpreadsheet(); const [src, dst] = ["Sheet1", "Sheet2"].map((e) => ss.getSheetByName(e)); const obj = src .

Reducing Table Height of Table Inserted from Google Spreadsheet to Google Slides using Google Apps Script

Gists This is a sample script for reducing the table height of the table inserted from Google Spreadsheet to Google Slides using Google Apps Script. Sample script Please copy and paste the following script to the script editor of Google Slides. This sample script uses Slides API. So, please enable Slides API at Advanced Google services. Ref As the sample situation, this script supposes that a table is manually copied from Google Spreadsheet to the 1st slide of Google Slides.