Google Sheets API HTTP request 400 unauthorized

Questions
1

What is the error message (if any)?
I was using google sheets API in an HTTP node. It worked fine previously so I know JSON and sheet ID etc. should not be the issue.
Then I tried to use it, got an error. Told me to refresh credentials. When I went to refresh I got this. I’ve tried literally everything I can think of and chatted with Chatgpt for like two hours to no avail. Any ideas?

Here’s a screenshot of the error.

image
image491×758 32 KB

Information on your n8n setup

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

It appears that the app is misconfigured in Google Cloud Platform. Please see this video for an example of how it should be configured.

3

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