Gists

This is a sample Google Apps Script for processing the values in Google Spreadsheet. In this sample situation, each column are merged using the same header title.

In this sample script, the sample input and output situations are as follows.

Sample situation

Input: “Sheet1”

Output: “Sheet2”

Gists

Introduction

In this report, I would like to introduce to apply the spread syntax and the destructuring assignment to Google Spreadsheet with Google Apps Script. The destructuring assignment can be used without V8 runtime. But, the spread syntax is required to be used with V8 runtime. Recently, I often saw the script using them at Stackoverflow. And also, I have sometimes gotten the questions related to the spread syntax and the destructuring assignment. So, I thought that I would like to introduce in my blog.

Finally, Google Forms API has been officially released as version 1.

Create surveys, quizzes, and more using the Google Forms API, now generally available

The Google Forms API provides programmatic access for managing Google Forms and acting on responses— empowering developers to build powerful integrations on top of Forms.

Forms API

Gists

When I tested Google Forms API, I noticed that when a new Google Form is created by the method of forms.create, there is not title of the created Google Form. So, I have reported this to Google issue tracker. Ref Today, I confirmed that this bug has been removed.

And, when I saw the official document, I noticed that the following document has been added. Ref

getcode was updated to v1.0.1

• v1.0.1 (February 26, 2022)

  1. Latest libraries are reflected to this library. And, the sample script is shown using the Quickstart for go of Drive API.

You can get this from https://github.com/tanaikech/getcode

• v2.0.1 (February 26, 2022)

  1. A bug for the resumable download was removed.

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

• v2.0.0 (February 25, 2022)

  1. Modified using the latest libraries. The specification of ggsrun is not changed.

You can check ggsrun at https://github.com/tanaikech/ggsrun.

• 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.

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

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.