Google Sheets v3 API is being shutdown on March 3, 2020

[gitlech]

Hi!

On the 3rd of October 2019 I received an email from Google saying that "Google Sheets v3 API is being shutdown on March 3, 2020". Sounds like the plugin has to be updated to use Google Sheets v4 API.

Here is the email from Google:

Hello Sheets Developer,

We're writing to let you know that Google Sheets v3 API will be shut down on March 3, 2020.

What do I need to know?

The Sheets v4 API, launched in 2016, opened new doors to custom development with programmatic access to critical features like conditional formatting, charts and pivot tables. Since then, we’ve continually improved version 4 by supporting new Sheets features and introducing developer metadata.

As part of the migration to the Sheets v4 API, we will shut down the Sheets v3 API on March 3, 2020.

What do I need to do?

To ensure projects originally built on the Sheets v3 API continue working long after it is gone, please migrate your projects to the Sheets v4 API before March 3, 2020.

• You can review this migration guide which provides tips on how to transition your apps, including a mapping of operations in Sheets v3 API to operations in Sheets v4 API and some ideas for using the new functionality to your advantage.

• Note that the Sheets v4 API does not provide the "List spreadsheets for the authenticated user" operation. However, this operation can be replicated via the Drive API Files.list method.

We have identified that the following projects have used the Sheets v3 API in the past 30 days:

1. (removed)

Need help?

• Additional documentation is available to help you get started on a new project or leverage the content and appearance controls not available in previous versions.

Please bear in mind that after March 3, 2020, the Sheets v3 API will no longer be supported.

Thanks for being a valued Sheets Developer.

Sincerely,

The Sheets API team

[jfmonteil]

I have upgraded the Google Sheet Plugin with latest API's here : https://github.com/jfmonteil/Pentaho-Google-Sheet-Plugin.
Any comments welcome.

[gitlech]

Cool, thanks. Will look into it