Tag: google-sheets-api

PDI “Google Spreadsheet Input/Output” plugin compatible with Google Sheets API v4?

compatibility google-sheets-api java pentaho-data-integration

I am using the “Google Spreadsheet Input/Output” plugin from the Pentaho Data Integration marketplace, which is no longer maintained. Github repository link. Recently I have received an email from Google with the subject: [Action Required] Google Sheets v3 API is being shutdown on March 3, 2020 Can someone please have a look the source code and check if the plugin

Reading whole Google Spreadsheet with Sheets API v4 Java

google-sheets google-sheets-api java

I would like to read a Google Spreadsheet like described in the Java Quickstart https://developers.google.com/sheets/quickstart/java The Quickstart explaines how to read data from a give range But I have the problem that I do not know the Range of the Spreadsheet. The number of columns can change. So how can I read for example all the data of the Sheet