Sheets node - Delete rows

Questions
,
1

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
3

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:

image
image623×543 29.7 KB

Hope this helps!

4

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 :slight_smile: