Gists
Abstract One day, you might have a situation where you are required to create a Web Apps with Google Apps Script and are required to load another HTML created by Javascript on the Web Apps. This report will help achieve such a situation.
Introduction Google Apps Script can create Web Apps. Ref When you access the Web Apps using your browser, you can see the HTML. When your browser can run Javascript, you can see the HTML reflecting the Javascript.
Gists
Abstract One day, you might have a situation where it is required to run Google Apps Script using the service account. Unfortunately, in the current stage, Google Apps Script cannot be directly run with the service account because of the current specification. So, this report introduces a workaround for executing Google Apps Script using the service account.
Introduction When you want to execute Google Apps Script from outside of Google, as the basic approach, it can be achieved by Google Apps Script API.
HtmlFormApp was updated to v1.0.2. v1.0.2 (October 17, 2023)
The 2nd argument row of appendFormData(object, row) was added. This is from this suggestion. When row is used, the value is put into the specific row of the Spreadsheet. In this case, please set the value of row more than 1.
In this case, the submitted row can be forcefully put into the specific row of Google Spreadsheet.
go-gettokenbyserviceaccount was updated to v1.0.1 v1.0.1 (October 12, 2023)
Updated README.md and updated the script. You can get this from https://github.com/tanaikech/go-gettokenbyserviceaccount
Gists
Abstract This report introduces the method for managing the histories of the Google Apps Script project.
Description On August 23, 2023, the project history has been implemented in the new IDE of Google Apps Script. Ref and Ref In the current stage, the users can see the history of the previously deployed script version. This is a very important implementation for a lot of developers.
Here, I remember the classic IDE.