I’m reporting a logic-breaking bug with the Google Sheet Reader node using the “Use Link” method.
The Issue: When feeding a dynamic URL (string output from a previous node) into the “Link” field, downstream nodes (for exemple “Combine Lists”) fail intermittently with: 'Combine Lists' node could not be run! Missing input 'input1', did not receive a value.
Crucial Details:
Intermittency: It works ~50% of the time with the exact same input string.
False Negative: Even when the downstream node fails, the Google Sheet Reader logs explicitly show the correct output list generated successfully.
Isolation:
Hardcoded URL = Works 100%.
Direct Drive File selection = Works 100%.
Dynamic String Input = Random failures.
This looks like a race condition where the Reader node signals completion to the workflow runner before the output payload is actually ready/passed to the next node.
Can you please investigate the state handoff for this node when using dynamic inputs? It’s currently making the node unusable for automated workflows.
This is actually expected behavior based on how the native Google Sheets Reader node works. When you use the “Use Link” method, the node fetches the column schema as its output based on the tab you select. Each column becomes a separate list output that downstream nodes depend on.
When you pass the sheet link dynamically from a previous node, you need to ensure that the same tab name and the same columns still exist in the target sheet as what the node was originally configured with. If the schema doesn’t match – different tab name, missing columns, renamed headers – the node won’t be able to produce the expected outputs, which is why downstream nodes like Combine Lists intermittently report missing inputs.
That’s why hardcoded URLs and direct Drive selection work 100% of the time since the schema is known and consistent.
If you need full dynamic flexibility (reading from sheets with varying structures), I’d recommend using an SheetsMCP node instead. You can create a custom Google Sheets MCP node by:
Dragging the Google Sheets MCP node onto your canvas
Describing what you need (e.g., “Given a Google Sheets URL, output all the contents”)
Gumloop’s AI will generate a custom node that works with any URL dynamically and outputs the content in your required format
This approach doesn’t rely on a pre-defined column schema, so it handles varying sheet structures seamlessly.
