Gists This is a sample script for converting various images to PNG Format and JPEG format using Google Apps Script. The flow of this sample script is as follows. Convert the file to PNG format by the thumbnail link. Convert PNG format to JPEG format if outputFormat is “JPEG”. Create the image data in the JPEG format in the root folder as a file. Sample script Please set your file ID and output format.
Gists This is a sample script for copying a Google Spreadsheet including a container-bound script by removing the container-bound script using Google Apps Script. When you want to copy a Google Google Spreadsheet including a container-bound script by removing the container-bound script using Google Apps Script, this could be achieved by using “get” and “create” methods of Sheets API before. The sample script is as follows. const obj = Sheets.Spreadsheets.get( SpreadsheetApp.
Gists This is a sample script for notifying the new release of Google APIs and Google Apps Script with an email using Google Apps Script. Recently, I published a sample script of “Retrieving Release Notes of Google Apps Script and Google APIs from RSS using Google Apps Script”. After this was published, I got an email that it wants to automatically notice the new release of Google APIs and Google Apps Script with an email.
Gists This is a sample script for managing the row height and the column width of a table on Google Slides using Google Apps Script. In the current stage, Google Slides service (SlidesApp) cannot manage the row height and the column width of the table on Google Slides, while the table width and height can be managed. But, fortunately, when Google Slides API is used, this can be achieved. In this post, I would like to introduce a sample script for managing the row height and the column width of a table on Google Slides using Google Apps Script.
Gists This is a sample script for converting the relative reference to the absolute reference and vice versa of A1Notation on Google Spreadsheet using Google Apps Script. Description A1Notation is used in the cells on Google Spreadsheet. As the 1st sample, it supposes that a formula of =A1 is put into a cell “B1”. Under this condition, when the cell “B1” is copied to “B2” and “C1”, the cells “B2” and “C1” have the formulas of =A2 and =B1, respectively.