"no path back to referenced node" on Google Sheets node

Questions
1

Describe the problem/error/question

The “Google Sheets” node cannot get the ID from “Strapi - Get Sheet ID” node.

But I can see it on the “input” view.

image
image2559×1227 315 KB

What is the error message (if any)?

No path back to referenced node [item 0]
There is no connection back to the node 'Strapi - Get Sheet ID', but it's used in an expression here.

Please wire up the node (there can be other nodes in between).

Please share your workflow

Share the output returned by the last node

(The error message mentioned above)

Information on your n8n setup

  • n8n version: 1.67.1
  • Database (default: SQLite): Postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main): (I have not configured this)
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Ubuntu
2

Hey @y2kbug , as your reference to the sheet ID is based on item it implies you ask n8n to figure out the path to the item in “Strapi - Get Sheet ID” automatically. However, your workflow includes branching by means of “Compare Datasets” node which prevents n8n from figuring out the path back to the requested node.

To resolve, replace item with first() which instructs n8n to look at a specific value (assuming “Strapi - Get Sheet ID” node produces only one item).

2 Likes