Hi everyone,
The easiest way to get your Google Sheets into KNIME is definitively by using the Google Authentication node, which @ipazin mentioned.
It is, however, also possible to use the Google Authentication (API Key) node.
-
First, to solve your problem when trying to select a spreadsheet, make sure that you also have the Google Drive API enabled for you project in Google’s developer console. Listing the files in Google Drive requires access to that API, since the Google Sheets API only handles spreadsheets.
-
Second, in order to have the spreadsheets from your private account available to your service account, you have to share your private sheets with your service account’s email address. You can do that in browser, as if you would share it with another person. (top right corner)
The service account really is a separate account to your own Google account.
I hope this helps, if you have any further questions, please ask!