tanaike

The Thinker

Opening and Closing Google Forms on Time using Google Apps Script

Gists This is a sample script for opening and closing Google Forms on time using Google Apps Script. In order to test this sample script, please do the following flow. Usage 1. Create a new Google Form. Please create a new Google Form and set your sample questions. And, please open the script editor of Google Form. 2. Prepare sample script. Please copy and paste the following script to the script editor of Google Form.

Decrypting Salted Base64 of finance.yahoo.com using Google Apps Script

Gists This sample script decrypts the salted base64 data of finance.yahoo.com using Google Apps Script. Recently, it seems that the specification of the key for decrypting the data has been changed at the server side. So. in this post, this post is updated. About this specification, I checked this thread. Sample script function myFunction() { // Load crypto-js.min.js. const cdnjs = "https://cdnjs.cloudflare.com/ajax/libs/crypto-js/4.1.1/crypto-js.min.js"; eval(UrlFetchApp.fetch(cdnjs).getContentText()); // Retrieve HTML and retrieve salted base64.

Converting All Pages in PDF File to PNG Images using Google Apps Script

Gists This is a sample script for converting all pages in a PDF file to PNG images using Google Apps Script. I have already published “Merging Multiple PDF Files as a Single PDF File using Google Apps Script”. In this post, it was found that pdf-lib can be used with Google Apps Script. From this, in this post, I would like to propose a sample script for converting all pages in a PDF file to PNG images using Google Apps Script.

Merging Multiple PDF Files as a Single PDF File using Google Apps Script

Gists This is a sample script for merging multiple PDF files as a single PDF file using Google Apps Script. In this sample script, pdf-lib is used. In the current stage, it seems that this Javascript can be directly used with Google Apps Script. Sample script 1 As a sample situation, please put multiple PDF files in your Google Drive. This sample merges those PDF files as a single PDF file.

Transferring Owner of File to Other User using Google Apps Script

Gists This is a sample script for transferring the ownership of a file to another user using Google Apps Script. In the current stage, about the consumer account (gmail.com) the specification for transferring the ownership of a file has been changed as follows. Ref The current owner initiates an ownership transfer by creating or updating the prospective new owner’s file permission. The permission must include these settings: role=writer, type=user, and pendingOwner=true.