API Handling

Questions
1

Im having trouble linking my google sheets API. The key and secret have been entered, but i cant see my individual sheets, or rows. the message i keep receiving is Could not load list

Unable to sign without access token

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

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

Hi @Evan_Young

This error means the authentication method is wrong for Google Sheets in n8n.

Reason

  • Google Sheets does not support API key/secret authentication in n8n

  • It requires OAuth2

  • Without an OAuth access token, n8n cannot list spreadsheets, sheets, or rows
    → hence “Unable to sign without access token”

Try this fix

  1. Create an OAuth Client ID in Google Cloud (not an API key)

  2. Enable Google Sheets API

  3. Add this redirect URL:https:///rest/oauth2-credential/callback

  4. In n8n, create Google Sheets OAuth2 credentials and connect the account

    Once OAuth is completed, your sheets and rows will load correctly.

3

Hi @Evan_Young Welcome! Just Remove existing Google Sheets credentials, then upgrade n8n to the latest version and then recreate credentials. Also, makes sure the Google Sheets API and Google Drive API are enabled in your Google Cloud Console. Hope this helps.

4

Hi @Evan_Young,

After you set the client id and secret, make sure to click the button at the bottom to actually log into your google account. This is what will set the token which is related to the error you’re getting

image
image2392×1488 184 KB