Access gsheet from a Shared Drive

Just came across the following (closed) topic and wanted to add my solution…
Continuing the discussion from Can't access gsheets from a Shared Drive posted by @solabelleyro :

I could only see an option to pick a gdrive file from a drop down list that seemed random (and tedious with no order or search function). Sometimes my file was in the list and sometimes not.

Instead, Google has a tool called Google Drive for Desktop which creates a sync folder on your desktop that makes your gdrive look like Microsoft File Explorer on your desktop. Be careful not to setup synching or you’ll get a full copy of every file on your local hard drive. But for all intents and purposes, you can browse your gdrive easily.
When you point Knime to this drive it can see everything easily.

An interesting workaround - thanks for posting it! Hopefully this will help others dealing with the same issue. :+1:

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