Google sheets Error: Could not load list 400 - Bad request please check your parameters

Permissions granted but it shows nothing in the list under “Document”

Could not load list 400 - Bad request please check your parameters

Please share your workflow

Output:

No parameters are set up to be filled by AI. Click on the :sparkles: button next to a parameter to allow AI to set its value.

No parameters are set up to be filled by AI. Click on the :sparkles: button next to a parameter to allow AI to set its value.

No parameters are set up to be filled by AI. Click on the ✨ button next to a parameter to allow AI to set its value.

Information on n8n setup

  • n8n version: 1.97.1
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (desktop app, Ngrok webhook):
  • Operating system: Windows 10
1 Like

Hi @AFHKDeveloper

Make sure you have the required scopes in google cloud console.

![image|637x236]

(upload://cj0vmZD5aDFAcKMVhPlWeo2AyrN.png)

:heart:If this response helped you, please click the heart to show that it is useful
:white_check_mark:If this response solved your issue, mark it as the solution to help the community

1 Like

It’s sensitive scope

What’s an easier way to store contacts?

a code node that returns a json?

1 Like

@AFHKDeveloper

drive.file is a non sensative scope.

If you need a code node to store contacts, this should work.