Cannot Get OAuth Access to Google Sheets

Questions
1

Hello. I am new to N8N and am unable to connect my Google Sheets account to N8N.
My Google Sheets account says “Account connected.” When I select a document, it says, “Could not load list. Please check your credentials.” When I check the credentials, it takes me back to the Google Sheets account page, where it says “Account connected.” I would greatly appreciate any help getting this to work. I am willing to pay someone for their time if they can help me with this. Thanks.
Mitchell

  • n8n version: Community edition n8n Version 1.36.2
  • Database (default: SQLite): N8n Database postgres
  • **n8n EXECUTIONS_PROCESS setting (default: own, main):**default
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):**We are using Docker
  • Operating system: Alma Linux
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

hello @Mitchell_Herman

Try to set the document/spreadsheet id manually. Seems your API token does not have some permissions to load the list.

4

To add to that. You need google drive read permissions to list files on your drive. (If I recall correctly)
So like @barn4k said please test with just inserting ID or URL and see if that works.