Updated goodls to v200

  • v2.0.0 (February 25, 2022)

    1. By changing the specification of methods, drive.New() and transport.APIKey were deprecated. By this, I updated go-getfilelist. In this version, I used this updated library to goodls. And also, drive.NewService() is used instead of drive.New().

The detail information and how to get this are https://github.com/tanaikech/goodls.

Updated: Go Library - go-getfilelist to v200

go-getfilelist was updated to v2.0.0

  • v2.0.0 (February 25, 2022)

    1. By changing the specification of methods, drive.New() and transport.APIKey were deprecated. By this, I updated the specification of this library as the version 2. When you are required to continue to use drive.New() and transport.APIKey, you can use them with the version 1. At version 1, *http.Client is given to this library. From version 2, *drive.Service is given instead of *http.Client. Please be careful this. You can see the sample script at the above.

You can get this from https://github.com/tanaikech/go-getfilelist

Updated: CLI Tool - goris to v300

goris is a CLI tool to search for images with Google Reverse Image Search.

Today, it was updated to v3.0.0. Please check it out. https://github.com/tanaikech/goris

  • v3.0.0 (February 23, 2022)

    1. The specification for running the reverse image search was changed at Google side. By this, this application was also changed.

Updated goodls to v128

  • v1.2.8 (February 17, 2022)

    1. Recently, it seems that the specification the process for downloading the shared file on Google Drive has been changed. So I updated goodls for reflecting this. The usage of goodls is not changed.

The detail information and how to get this are https://github.com/tanaikech/goodls.

Counter in Cell of Google Spreadsheet using Infinite Loop with Google Apps Script

Gists

Counter in Cell of Google Spreadsheet using Infinite Loop with Google Apps Script

This is a sample script of a counter in a cell of Google Spreadsheet using the infinite loop with Google Apps Script. Recently, I have reported about the infinite loop on Google Spreadsheet. Ref This sample script achieves a counter in a cell using the infinite loop.

Sample script

This sample script is a test script for counting the number using the infinite loop. Please be careful this. Please copy and paste the following script to the script editor of Google Spreadsheet and save it. And, please install OnChange trigger to the function onChange().

Report: Occurring and Resolving Infinite Loop on Google Spreadsheet using Google Apps Script

Gists

Report: Occurring and Resolving Infinite Loop on Google Spreadsheet using Google Apps Script

Here, I would like to introduce a report for occurring and resolving the infinite loop on Google Spreadsheet using Google Apps Script. I have reported this to Google issue tracker. Ref

Sample script: Occurring infinite loop

This sample script is a test script for confirming the infinite loop. Please be careful this. Please copy and paste the following script to the script editor of Google Spreadsheet and save it. And, please install OnChange trigger to the function onChange().

Report: Inserting Multiple Paragraphs to Google Document in Order using Google Docs API

Gists

This is a report for inserting the multiple paragraphs to Google Document in order using Google Docs API.

When the multiple paragraphs are inserted to Google Document using Google Docs API, it is required to pay attention to the index for inserting the texts. In this report, I would like to introduce the points for achieving this with a simple method.

Although this report uses Google Apps Script, the logic of this method can be used for other language.