tanaike

The Thinker

Putting TOTP into Google Spreadsheet using Google Apps Script

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.

Enriched Management of Rich Text on Google Spreadsheet using Google Apps Script

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.

GAS Library - RichTextAssistant

Overview This is a GAS library for supporting editing RichText in Google Spreadsheet using Google Apps Script. Description There is RichTextApp in my published libraries. RichTextApp can be used mainly for converting RichText to Google Documents and vice versa. This library RichTextAssistant will support editing the rich text in Google Spreadsheets using Google Apps Script. Google Spreadsheet can use rich text as the cell value using Google Apps Script. But, I thought that when I created a script for editing the existing rich text in the cell, it might be a bit complicated.

Folder Picker using jsTree with Google Apps Script and Javascript

Gists This is a sample script for the folder picker using jsTree with Google Apps Script and Javascript. I have already published “File Picker using Google Apps Script and Javascript without 3rd party”. In this post, jsTree is used. Usage 1. Install Google Apps Script library. In this script, “FilesApp” of my Google Apps Script library is used. So, please install it. You can see how to install it at here.