tanaike - Google Apps Script, Gemini API, and Developer Tips

The Thinker

Inverting Selected Objects on Google Slides using Google Apps Script

Gists This is a sample script for inverting the selected objects on Google Slides using Google Apps Script. I have the case that I want to invert the selected objects on Google Slides. This sample script can be achieved this goal using Google Apps Script. Sample script Please copy and paste the following script to the script editor of Google Slides, and save the script. And, please select the objects on the Slide and run the function main().

Inverting Selected Ranges on Google Spreadsheet using Google Apps Script

Gists This is a sample script for inverting the selected ranges on Google Spreadsheet using Google Apps Script. I have the case that I want to invert the selected ranges on Google Spreadsheet. This sample script can be achieved this goal using Google Apps Script. Sample script Please copy and paste the following script to the script editor of Google Spreadsheet, and save the script. And, please select the cells and run the function main().

Checking whether Cells on Google Spreadsheet have Checkboxes using Google Apps Script

Gists This is a sample script for checking whether the cells on Google Spreadsheet have checkboxes using Google Apps Script. When the checkboxes are used in Google Spreadsheet, there is the case that it is required to know whether the cells have the checkboxes. This sample script can be used for such the situation. Sample script 1 This sample script can check whether all cells in “A1:B10” have the checkboxes. When all cells in “A1:B10” have the checkboxes, res is true.

Converting from String to Hex, from Hex to Bytes, from Bytes to String using Google Apps script

Gists This is a sample script for converting from the string value to the hex value, from the hex value to the byte array, from the byte array to the string value using Google Apps script. When the creation of a signature for requesting and the encryption of data are used, there is the case that these conversions are required to be used. So I would like to introduce these scripts as sample scripts.

GitHub: Google Forms API Apps Script Web app

The sample scripts for using Google Forms API have been published by cschalk-goog. The scripts include the method for basically requesting to Forms API. This information will be very useful for a lot of users. https://github.com/googleworkspace/apps-script-samples/tree/master/forms-api/demos/AppsScriptFormsAPIWebApp