Sheets node - Delete rows

[Pablo_de_Brito_Carva]

Describe the problem/error/question

When I set the Sheets node to delete a row, the process deletes more than the specified data.
For example:

• Start Row: 2 | Rows to Delete: 1
• Rows deleted: At least 10.

What is the error message (if any)?

No error message

Please share your workflow

Share the output returned by the last node

[
{
“success”: true
}
]

Information on your n8n setup

• **n8n version:0.233.1 and 1.8.2
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• **Running n8n via (Docker, npm, n8n cloud, desktop app):Docker or npm
• **Operating system:Linux Ubuntu 22.04

[MutedJam]

Hi @Pablo_de_Brito_Carva, welcome to the community!

Are you passing on more than 1 item to your Google Sheets node? If so, this behaviour is expected, as the node will run the delete action for every single item it receives. With a few exceptions, this what most n8n nodes will do.

If you only want to delete a single row you’d need to ensure you have enabled the Execute Once option of the node. I’ve highlighted this below:

Hope this helps!

[Pablo_de_Brito_Carva]

Hi @MutedJam,

Yes, i’m passing more than 1 item and yout tip was helpfull. Beside that, to avoid any problem while deleting any row I added a new sheets node to make a new row validation.

So, in the end of the proccess everything works good!

Thanks