Error 400: Bad Request Get List Google Drive

Describe the issue/error/question

Hello! I’m trying to retrieve the list of files I have within a folder in Google Drive to a Google Sheets. It seems to give me a 400 error on the folder name I input, but I’ve tried several different names and none of the work - always come back with the same 400 bad request error.

What is the error message (if any)?

ERROR: Bad request - please check your parameters

Invalid Value

Please share the workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.9.0
  • Database you’re using (default: SQLite): SQLite
  • Running n8n with the execution process [own(default), main]: own
  • Running n8n via [Docker, npm,, desktop app]: desktop app (Mac)

Hey @BrandaoCamilla,

What happens if you remove the ' from the query string? Is the query correct as well? Normally I would expect it to be something like term operator value so parents in 'your-id' you can find more info on the query strings here: Search query terms and operators  |  Google Drive  |  Google Developers

Hello @Jon , thanks a lot for your help!

Unfortunately no success yet. I tried several forms of putting the folder name, as well as picking other folders to see if worked with any other folder but no luck. I’ve also tried to change the authentication method and the way of writing the query string as you suggested.

The thing I need to do is list the all the file names I have within a specific folder. I have over 300 files with random names I need to transfer them to a spreadsheet… Don’t know if there’s any other way of doing it.

I appreciate your time though! Thanks a lot.

Hey @BrandaoCamilla,

I have had a quick play and I have managed to get it working…

I found that a query string of parents in '0B_yIMxAoFm31N1NrVkpvMnRXQzA' has allowed me to get the contents of this folder (but not sub folders)

It might sound odd but does the user you authenticated with have access to the folder? I can’t really think of anything else that would cause the issue.

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