Sheet authentication issue

Questions
,
1

Describe the issue/error/question

I want to read a sheet from google sheets.
But i’m getting an error message when connecting to the Google sheets node . Please see the attached screenshot.

N8Nerror
N8Nerror2421×1527 229 KB

I’ve checked the credential: Account connected
Of course i’m using the link of my sheet : https://docs.google.com/spreadsheets/d/...yxIrEbFN...oN
I’m stuck here. Please let me know if I’m missing something.

Thank you for your help

What is the error message (if any)?

ERROR: The resource you are requesting could not be found

Please share the workflow

I didn't have start the workflow because it not getting the first node of it

Share the output returned by the last node

Information on your n8n setup

  • n8n version:0.160.0
  • Database you’re using (default: SQLite): none
  • Running n8n with the execution process [own(default), main]: don’t know
  • Running n8n via desktop app
2

Hi @terryble66, welcome to the community!

n8n would require the ID of your spreadsheet rather than the full URL. So if you have a URL like https://docs.google.com/spreadsheets/d/1mHUdWcQTCeJrXHQgO26QlMe9xsslTPcjAaHq949wtq8/edit#gid=0, the ID you’d need to use in the node would be 1mHUdWcQTCeJrXHQgO26QlMe9xsslTPcjAaHq949wtq8.

n8n should also show a little hint on the right value when hovering over the little question mark:

image

Let me know if you still have trouble one you’ve updated your ID :slight_smile:

1 Like
3

Got it working with your suggestion above.
Thank you for your help

1 Like