google spreadsheet selet file in another folder

Hello everyone, how can I read a spreadsheet file inside a folder in Google Drive? I have tried using a combination of Node Google Authenticator → Google Sheet Connector → Google Sheet Reader. The problem is that in the Google Sheet Reader node, I cannot select a file within a folder. How can I read a file located in a Google Drive folder with the path /project/employee/employee_form.spreadsheet ?
Thank you in advance

image

Hi @HazelRD ,

as of today, there only are workarounds do to this. See Google Drive Shared Folders - #2 by k10shetty1 for how to do this.
Still sounds like a very valid use case. I added a +1 for you to the ticket (internal reference AP-11391).

Hope this helps,
nan

2 Likes