Issue with Google Sheets Node (Get)

Hi everyone,

I’m having trouble with the Google Sheets node in n8n. I’m trying to perform a simple Get operation, but the node returns nothing, and the workflow stops at this step.

What I’ve tried so far:

  • Authentication seems to work: I can select my spreadsheet and sheet from the list.
  • I’ve tested different cell ranges (A1:D10, Sheet1!A:D, etc.).
  • I made sure the sheet contains data.
  • I checked Executions, but there are no errors—just no results and the workflow wont go any further.
  • I added a “Debug” node after the Google Sheets node, but it receives nothing.

Does anyone have an idea of what could be causing this issue? Thanks in advance for your help!

As for the n8n infos, i’ll need to check with my it colleague to know more

Could you post your workflow using the </> button?
Here is how: How to get help on n8n community forum fast · GitHub

If you filter inputs by date or datetime, this may work not as expected, due to peculiar way datetime is stored in Excel (and Sheets for compatibility reasons).

it’s the most basic workflow just to test the block, there is a set block to get the output but the flow never reaches it

You need row 1 to contain column names.

If this resolves your question, please mark this post as a :white_check_mark: Solution.

2 Likes

So Thanks for your reply.
It appears that the issue is not what I thought it was.
Today another of my workflows is stopping at a set block like if the workflow was finished. And if I remove the block, the flow stops at the next block.
Also, the issue disappeared yesterday when I worked on another pc and today it appears on a new pc on a different workflow.

Please post the part of workflow that causes the issue. If this posted fragment is never reached, not much insights about what happens before can be extracted from it.

Hello, sorry, here’s the code that is stuck today:

So today the flow stops at the “Edit Fields1”.
It’s empty because a was trying to execute the previous nodes to get the schema.
I tried to remove it from the flow, but then it stops at the loop

Thanks again for the help !

You cannot just wire two nodes into a code node. It will not work as expected. You need to Merge data before that, so that code receives it as a single entity.

I think it’s a bit different problem than you had before. Why do you think it’s the same?

I’m asking because you probably need to open a new topic. Otherwise future readers will be confused.

In your current setup the Code node tries to process inputs from those two wired nodes independently, one by one, and that is why it breaks and passes no data further, effectively terminating the workflow.

I think yesterday it was the same issue because, at first, I thought the problem came from my misconfiguration of the Sheets brick. But in the end, I realize that the same phenomenon is happening. The blocking brick does not see the inputs from the previous bricks and stops the workflow as if there was nothing after it.

And yesterday, I also tested it. If I replaced the Sheets brick with another one, the flow still wouldn’t move forward.

Thanks for the advice, I will make the modification. However, I don’t think this is the solution to the problem. Today, the blocking brick is the second set, there is a filter before it, and when my flow works, the code brick also works and sends data to the filter brick. But from there, the flow stops.

It’s true that the ticket no longer reflects the issue because, in the end, I had misidentified the problem. Do you think I can modify the title of the topic, or should I create a new one?

Thanks again for your help!!

I think it is better to open a new topic.
Please post a bigger fragment of your workflow there (maybe even the entire workflow) pinning some data that cannot be obtained without having credentials or access to specific resources.

Remember, you can edit pinned data to replace sensitive data points with random bits.

One interactive workflow with pinned data is worth 100s of screenshots and 1000s of words. This doesn’t mean the business logic explanations aren’t needed tho

2 Likes

Thanks, I am going to apply the changes with the addition of the merge block, and if the issue still happens, I’ll open a new ticket.

1 Like

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