How to access public google sheet (without authentication)?

KNIME Analytics Platform
1

I’m trying to access a public google sheet which I can open by URI.

Now I would like to use the data as input for a KNIME workflow. But I’m unable to open it.
Using the xls-Reader does not work.
So I tried to use the Google Sheets Reader (GSR).
What I understand:That requires the Google Sheets Connector (GSC) beforehand and GSC requires Google Authenticator (GA).
But GA does not have something in the configuration like an anonymous mode without login.

Tried it with this example Google Spreadsheet Table Sample - Google Sheets

So what is the process to read the public google sheet in KNIME without Google Login?

2

I had a look around. Unauthenticated access to public Google Sheets is not possible with the Reader, I noted down your interest in internal id AP-8372.

You can access the file if you open it with your Google account once in the browser, then it will show up in the list of sheets.

As some kind of workaround, you could create your own API Key (which might a good idea for quota reasons anyway) and then use the HTTP API to query the data as described here: bash - HTTP Google Sheets API v4 how to access without OAuth 2.0? - Stack Overflow

2 Likes
3

@hotzm

Thanks for your reply and support.
Looking forward for this update

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.