Skip to content

Tag: google-sheets-api

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

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

I would like to read a Google Spreadsheet like described in the Java Quickstart 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