Google Sheets node doesn't always collect row_number

[Oestle]

Bug Description

When using the Google Sheets node with operation "Get row(s)" it doesn't always collect and forward the row_number of the found rows.
It seems to me that it's working when testing just that node, but as soon as the whole workflow is run/tested it doesn't forward the row_numbers.
I'm using the row_number in a workflow to delete certain rows in a next node, but without the row_number information that doesn't work.

To Reproduce

• Use Google Sheets node with operation "Get row(s)"
• Test just that node -> rows will be there
• Test whole workflow -> rows will be missing

Expected behavior

row_numbers should always be collected and forwarded when using "Get row(s)"

Operating System

Official Docker Image running on Kubernetes (Ubuntu 22.04)

n8n Version

1.62.3

Node.js Version

20.17.0

Database

PostgreSQL

Execution mode

main (default)

[Joffcom]

Hey @Oestle,

We have created an internal ticket to look into this which we will be tracking as "GHC-338"

[Joffcom]

Hey @Oestle,

I am not able to reproduce this on the 1.65.0 release of n8n, Are you able to upgrade to see if you have the issue and if you do can you share a minimal workflow that reproduces it? For my test I used a production webhook that gets rows and the row_number was there.

[Oestle]

Sadly not on 1.65.0 yet, but we're on 1.63.4 now and i can still reproduce the issue.
I'll try to spin up 1.65.0 later if i get the chance.

But it seems i wasn't fully correct on the issue, it seems to collect some row_numbers even when testing the whole workflow, but not all.
My test setup to reproduce the issue looks like this:

I get all rows of a Google Sheet, i filter for a String in a field (in this example the "all_done" column should say "yes"), if it's found i want that row to be appended to another sheet and deleted on the first sheet (that's why i need the row number)

When testing just the first Google Sheets node i get this output:

[
{
"row_number": 2,
"name": "test",
"todo1": "done",
"todo2": "done",
"all_done?": "yes"
},
{
"row_number": 3,
"name": "test2",
"todo1": "test2",
"todo2": "",
"all_done?": ""
}
]

If i test the whole workflow i get this on the same node:

[
{
"name": "test",
"todo1": "done",
"todo2": "done",
"all_done?": "yes"
},
{
"row_number": 3,
"name": "test2",
"todo1": "test2",
"todo2": "",
"all_done?": ""
}
]

If i disconnect the steps after the Sheets node, so it's the only node running, it always outputs all the row_numbers.

[Joffcom]

Hey @Oestle,

Did you have the same issue on a newer version of n8n?

[Oestle]

Tried just now on 1.65.2 (via npx n8n@1.65.2), same result.

[Joffcom]

@Oestle can you share the json for a workflow that reproduces this? I tried copying what you have the image but it appears to be working fine.

[Oestle]

Weird. Sure, there you go.
My_workflow.json
And thanks again for looking into it!

[Oestle]

@Joffcom were you able to reproduce the issue with the provided workflow?

[janober]

Fix got released with n8n@1.79.0