Here is the excerpt from one of the other post ( Google Sheets Reader, Writer, Appender, Updater only sees one sheet and unable to see others or change the selection )
"To access a spreadsheet from your Google Drive you have to mark it as favorite or you have to be the owner/creator. You’re not able to navigate through your Gdrive folder structure. The list shows all the favorites and own files sorted by the last modification DESC. "
I even tried this, where I have marked as “favorite” or starred the file and the all team members have access to this file equally. User x logs in from Knime → Google Authentication to connect to drive where in Google Drive Connector he can see all folders, but from the Google Sheet Updater, the file is not visible.
