Google sheets authentication issue

Questions
1

Hi all,

I’ve just spent the whole morning on this, and I am just about to give up so I thought I’d come and ask.

I’m trying to revive an old workflow that used to connect to a google sheet and retrieve data from it.

For some reason the authentication wasn’t valid anymore so I removed them and tried to set up new google oauth.

I did it, and it worked and in the node “Google Sheets Trigger”, I selected a sheet from the list and it appeared in the dropdown.

I exited, did a few more things and came back to continue, and then in the dropdown for the sheet to choose from list, it now says Could not load list, and underneath that it says Please check your credentials

I have removed all of my authentication, readded it, double checked it in the google web application dashboard. When I create the new credentials in N8N, it saves and I can connect and I give it permission and it accepts permission and everything’s good and happy until I drop down the list in the “Google Sheets Trigger”, spreadsheet selection dropdown box and then I can’t continue.

I am bashing my head against wall here, and I wonder if anyone can offer any advice?

I am on version 1.38.1, self hosted via docker.

Any advice greatly appreciated, thank you so much

Please share your workflow

Information on your n8n setup

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

UPDATE: I was able to solve it.

It turns out in the document drop down box, I needed to paste the URL of the form without any of the edit attributes at the end.

I was then able to select the sheet from the list and continue with the workflow

3 Likes
3

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