Gists These are sample scripts for putting an image into a cell of a Spreadsheet using Google Apps Script. Sample 1 In this sample, the image is put into a cell using thumbnailLink retrieved by Drive API. So, when you test this, please enable Drive API at Advanced Google services. The image is put into cell “A1”. function sample1() { const fileId = "###"; // Please set the file ID of the PNG image file on Google Drive.
Gists This is a workaround for automatically installing the OnEdit trigger to the copied Google Spreadsheet using Google Apps Script. The sample situation for this workaround is as follows. You have a Google Spreadsheet. Your Spreadsheet is shared with a user as the writer. Your Spreadsheet has a button for executing a script for copying the active Spreadsheet. Your Spreadsheet has a function installedOnEdit for executing by the installable OnEdit trigger.
v2.0.3 (April 5, 2023) Forgot to update the version number and modified it. And, built the sources with the latest version. Ref The detail information and how to get this are https://github.
Gists In this post, I would like to introduce a sample script for putting Time-based One-time Password (TOTP) value into Google Spreadsheet using Google Apps Script. In this sample script, I used a Javascript library of https://github.com/hectorm/otpauth . In the current stage, Google Apps Script can run with V8 runtime. By this, it seems that this library can be used with Google Apps Script. Sample script function myFunction() { const secret = "ABCDEFGHIJKLMN23"; // Please set your secret here.
Gists In the current stage, Google Spreadsheet can use rich texts in cells. The rich texts can be also managed by Google Apps Script. But, I thought that creating a script for editing the existing rich text in the cell might be a bit complicated. Because, for example, in the current stage, when the text of the rich text of a cell is changed using a script, all text styles are cleared.