Cannot connect to google sheet

Questions
1

Describe the problem/error/question:

Google Sheet credential is successfully added, but it cannot detect any Google Shee,t even after public access

From list, By ID, and By URL are not working

What is the error message (if any)?

Could not load list

EAUTH - The provided authorization grant (e.g., authorization code, resource owner credentials) or refresh token is invalid, expired, revoked, does not match the redirection URI used in the authorization request, or was issued to another client.

Please share your workflow

Information on your n8n setup

  • n8n version: 1.97.1
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker, using Ngrok
  • Operating system: Windows 10
2

Hi @Hossein_Kurd

The best way to connect is via oauth2. Is that how you are connecting? Otherwise, you’ll need to take a bunch of steps in google cloud console to connect, including adding a redirect url.

image
image1181Ă—791 32.1 KB

4

Updated version to: 1.107.4

I have tried all possible ways, they didn’t work

5

@Hossein_Kurd

What are your errors? Are you on self hosted? if you are, you might need to step through a lot of steps on google cloud console.

  • Enable google sheets api
  • create new credentials
  • enter your redireect url
  • add yourself as a test user

create and copy your oauth credentials and paste them in into your n8n credentials.

Let me know your error and we can step through.

Here’s a youtube video that can help you step through as well.

: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

6

I followed all those steps

  • Enable google sheets api

  • create new credentials

  • enter my redireect url

Also, it wasn’t mentioned at the Video

  • add myself as a test user
7

Did you add the OAuth Redirect URL that generates n8n?

8

Yes

I found the issue

Instead of creating a Google Sheet, the file was uploaded to Google Drive

Now Solved.

9

@Hossein_Kurd

Glad you figured it out! Did you mean to mark your reply as the solution? or is there an answer that would help others solve this problem if they encounter it?

10

I could be another’s problem too. Shouldn’t upload an Excel file instead of using a Google Sheet one

Both of them will appear on Google Drive.

11

Hi @Hossein_Kurd

What are you trying to do with the google sheet in n8n? I can walk you though how to do it.

12

Getting data from Google Sheets. Already done