Cant see google sheets in list - help please

Questions
1

Appreciate some help please. This is so basic - I must be doing something wrong. I have spent about an hour and half checking documentation and youtube - none of which seem to help. I am a newbie.

I have created a google sheet node and connected using the oauth2 option. The problem: The sheets in my google drive are not displayed in the “Document / From list field”

I have tried pasting a URL to the sheet but then the tab names do not display in the “Sheet / From list” field. I type a tab name then the columns do not appear.

My Google account indicates n8n has access.

I have upgraded to the latest stable version 1.62.5 ( on n8n cloud) but this has not helped.

Screenshots:

google access
google access848×687 51.1 KB

n8nsheetnode
n8nsheetnode396×653 20.1 KB

n8n connected
n8n connected1171×285 16.6 KB

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

Hey @diggooddog , you need to have “Cloud Resource Manager API” enabled in your app. Also, bear in mind that it still should work when selecting the document by URL or ID. It is just to be able to list the docs you need “Cloud Resource Manager API” enabled.

1 Like
4

Thanks ihortom,

I tried your suggestion but the list still doesnt display. To be honest I dont need the list to display if pasting the URL works. I tried pasting the document URL and entering the sheet name then tested the step and got an error “The resource you are requesting could not be found” as follows:

sheet error
sheet error1136×845 97 KB

I noticed in the docs here that there are the following steps. I cannot do any of them as the fields do not display in the credential screens in n8n. Is this the source of the problem?:

  1. From your n8n credential, copy the OAuth Redirect URL. Paste it into the Authorized redirect URIs in Google Console.
  2. From Google’s OAuth client created modal, copy the Client ID. Enter this in your n8n credential.
  3. From the same Google modal, copy the Client Secret. Enter this in your n8n credential.

My credential screens:

credential3
credential31170×239 13.4 KB

credential2
credential21174×251 19.5 KB

credential1
credential11177×254 18.1 KB

5

Hi @ihortom or anyone else - appreciate your help with the above error please. I cannot use the google sheet node at the moment. Thank you.

6

Hi @ihortom or anyone else - appreciate your help with the above error please. I cannot use the google sheet node at the moment. Thank you.

1 Like
7

Hey @diggooddog , looks like permissions issue. Ensure you have also enabled Google Sheets API and Google Drive API in addition to Cloud Resource Manager API.

image
image910×294 18.8 KB

If issue persist, try (re-)creating the credentials following the doc you have mentioned, Google OAuth2 single service | n8n Docs?

8

Hi @ihortom yes I agree I think its permission’s related. I created a credential for Gmail today, I could follow all steps and it works fine.

Interestingly there is another credential type for Google Sheets called “Google Sheets Trigger account OAuth API” and this has the extra fields (OAuth Redirect URL, Client ID, Client Secret). These fields do not appear in the “Google Sheets OAuth API” credential. Screen shots below. I am using the “Google Sheets OAuth API” credential and think that’s why this is not working.
a) Is this a bug?
b) When should the “Google Sheets Trigger account OAuth API” be used versus “Google Sheets OAuth API”?

Thanks

Screen for “Google Sheets Trigger account OAuth API”:

image
image1092×632 21.5 KB

Screen for “Google Sheets OAuth API”:

image
image1076×281 10.9 KB

9

No, there should be another reason.

No, if you self-host you will see the “missing” fields. When on n8n Cloud, it sufficient to just sign on when accessing Google Sheet API.

I tested such an access with a brand new Google account and everything was working for me, including the list of available documents.

It is used with Google Sheets Trigger node.

  • Do you have access to the spreadsheets in questions when you are logged on via web to Google account?
  • If so, perhaps you need to reconnect with n8n ensuring you grant all the access offered during the process
  • You also could try Google Service account instead of OAuth2
10

Thanks for the clarification @ihortom

Problem solved: When signing in to Google sheets I thought only the following access was required: “See, edit, create and delete only the specific Google Drive files that you use with this app” I tried selecting all 3 access services and this solved the problem.

Might be worth updating the docs in case it helps others:
a) To say that it is intentional that the 3 fields (OAuth Redirect URL, Client ID, Client Secret) will not display in the Google sheet credential on n8n cloud, and
b) To say that all 3 access services are required when signing in to Google for the Google sheet node

Thanks again

1 Like
11

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