Row_number not included in Google Sheets Trigger on row added

[AlexMi]

Describe the problem/error/question

I have a Google Sheets Trigger activated after a new row is being added. I want then to update this same row by updating a column. To ensure the update is consistent and safe, I want to base this update on the row number but I it is not returned by the trigger node. I must do a search with all the columns but the operation is expensive and not duplicates-safe.

How can I fix this missing row_number ?

What is the error message (if any)?

Column to match on (row_number) is not defined. Since the field is used to determine the row to update, it needs to have a value set.

Please share your workflow

Share the output returned by the last node

Column to match on (row_number) is not defined. Since the field is used to determine the row to update, it needs to have a value set.

Information on your n8n setup

• n8n version: 1.95.3
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app): npx
• Operating system: MacOS 13

[darrell_tw]

Maybe it’s sheet api limit.

If the value of the field is not duplicated.

You can use match column by that field to update.

[AlexMi]

I don’t think it’s an API limit since I saw it when using the new “Evaluation” feature.

The search is an option but it is not duplicates-safe. A row can have the same value as another one, so it might work but at one point it won’t.

[darrell_tw]

Yeah the evalution feature it’s the same as using Google Sheet get rows action.

In that action you can get all the row_number with data.

Unfortunately is you using append_row or row_added. You won’t get the row number.

The other way might be add a Sheet node using get rows and get last of the row number.

It might be the row_number you need. But as you said it’s quite expensive operation.

[AlexMi]

It’s working perfectly on make.com, I get the row number on Google Sheets row added trigger. Your workaround seems good but I don’t get why there is not the information to start with.