Skip to content

Instantly share code, notes, and snippets.

Avatar

Kanshi TANAIKE tanaikech

View GitHub Profile
@tanaikech
tanaikech / submit.md
Created Aug 19, 2022
Benchmark: High-Efficiency Finding and Replacing Many Values in Google Spreadsheet with Low Process Cost using Google Apps Script
View submit.md

Benchmark: High-Efficiency Finding and Replacing Many Values in Google Spreadsheet with Low Process Cost using Google Apps Script

This is a sample script for high-efficiency finding and replacing many values in Google Spreadsheet with the low process cost using Google Apps Script.

When the various values are replaced in Google Spreadsheet using Google Apps Script, I'm worried about the process cost. So, in this report, I would like to introduce a sample script for high-efficiency achieving this.

As the result, using a sample situation, when the process cost of the sample script using Sheets API is compared with that of the sample script using Spreadsheet services (SpreadsheetApp), it was found that the above script using Sheets API could reduce the process cost by about 70 % from the script using Spreadsheet service.

@tanaikech
tanaikech / submit.md
Created Aug 18, 2022
Updating Destination Sheet by Source Sheet in Google Spreadsheet using Google Apps Script
View submit.md

Updating Destination Sheet by Source Sheet in Google Spreadsheet using Google Apps Script

This is a sample script for updating the destination sheet by the source sheet in Google Spreadsheet using Google Apps Script.

The sample situation is as follows.

Sample script

@tanaikech
tanaikech / submit.md
Created Aug 17, 2022
Moving Cell Detection on Google Spreadsheet using Google Apps Script
View submit.md

Moving Cell Detection on Google Spreadsheet using Google Apps Script

This is a sample script for detecting whether the specific cells on Google Spreadsheet are manually moved using Google Apps Script.

In this case, the named range, OnChange trigger, and PropertiesService are used.

Usage:

@tanaikech
tanaikech / submit.md
Last active Aug 17, 2022
Using RichTextValues with Custom Function on Google Spreadsheet
View submit.md

Using RichTextValues with Custom Function on Google Spreadsheet

In this post, I would like to introduce the method for using RichTextValue with a custom function of Google Apps Script.

This sample is for this thread in Stackoverflow.

In this thread, the OP's goal is as follows.

@tanaikech
tanaikech / submit.md
Created Aug 13, 2022
Retrieving Icons of each mimeType on Google Drive using Google Apps Script
View submit.md

Retrieving Icons of each mimeType on Google Drive using Google Apps Script

This is a sample script for retrieving icons of each mimeType on Google Drive using Google Apps Script.

Sample script

Sample list of mimeType is from this official document.

@tanaikech
tanaikech / submit.md
Created Aug 10, 2022
Report: Challenging Exporting Selected Cells on Spreadsheet as Image using Google Apps Script and Javascript
View submit.md

Report: Challenging Exporting Selected Cells on Spreadsheet as Image using Google Apps Script and Javascript

Overview:

This is a report for challenging exporting the selected cells on Spreadsheet as an image using Google Apps Script and Javascript.

Description:

@tanaikech
tanaikech / submit.md
Created Aug 8, 2022
Clearing Discrete Cell Values on Multiple Sheets using Google Apps Script
View submit.md

Clearing Discrete Cell Values on Multiple Sheets using Google Apps Script

This is a sample script for clearing the discrete cell values on multiple sheets using Google Apps Script.

There might be a case where you want to clear the values of the discrete cells in the multiple sheets using Google Apps Script. In this post, I would like to introduce the efficient script for achieving this.

Sample script 1

Please copy and paste the following script to the script editor of the Google Spreadsheet you want to use.

@tanaikech
tanaikech / submit.md
Last active Aug 8, 2022
Sample Script for Resumable Upload to Google Drive using Axios with Node.js
View submit.md

Sample Script for Resumable Upload to Google Drive using Axios with Node.js

This is a sample script for the resumable upload using Axios with Node.js.

Sample script

In this sample script, as a sample situation in order to explain the resumable upload, the file data is loaded from the local PC, and the data is uploaded to Google Drive with the resumable upload.

const axios = require("axios");
@tanaikech
tanaikech / submit.md
Created Aug 1, 2022
Creating User's Dashboard by Inputting Name and Password using Web Apps with Google Apps Script
View submit.md

Creating User's Dashboard by Inputting Name and Password using Web Apps with Google Apps Script

This is a sample script for creating the user's dashboard by inputting the user name and password using Web Apps with Google Apps Script. In this case, Google Spreadsheet is used as a database of the dashboard.

Usage

1. Create a Google Apps Script project.

In order to use Web Apps, please create a new Google Apps Script project. In this case, please create a new Spreadsheet and open the script editor of Spreadsheet.

@tanaikech
tanaikech / submit.md
Created Jul 30, 2022
Retrieving Names of Month and Day of Week using Google Apps Script
View submit.md

Retrieving Names of Month and Day of Week using Google Apps Script

This is a sample script for retrieving the names of month and day of week using Google Apps Script.

I think that you might have a case that you want to retrieve the names of month and day of week using Google Apps Script. This sample script retrieves them using a simple script.

Using Utilities.formatDate of Google Apps Script, the names of month and day of week can be retrieved using a simple script.

Sample script 1