Google sheets access

[n8nforken]

I been trying to connect my google sheets in my drive to use the “get rows in google sheets tool”. I used Oauth test users and successfully granted access with google drive api where it works perfectly, giving me access to all drives in my account. I updated scopes to grant access for all google drive and sheets related APi. I enabled cloud resources manager api on google cloud account. I did the same thing for google sheets tool, made sure it has access to see, edit create, delete and every google drive options it offers when n8n asked for it. However, when I open the sheets tool, under document ‘from list’ the only sheets that show up are the “shared with me” sheets from my drive.

I tried accessing through by ID and it came back empty
I tested it with two gmail accounts both came back the same way
I use n8n cloud version 1.101.1
google sheets tool node version 4.6
simple database

I want to apologize in advance if my informations are missing or misleading, I just started learning this tool and I havent learned a lot of tools.

[mrrobot]

Hey @n8nforken,

Welcome to the community, have you tried to search for the document by Url not by document?
Try creating a new test sheet in drive and see if it appears.

Let me know what you get so we can investigate more

Jm

[Bastien_Buffat]

I found the solution. You have to convert your files in the “google” format. They are the only one it sees.