# Sheets node - Delete rows

**URL:** <https://community.n8n.io/t/sheets-node-delete-rows/34462>\
**Category:** Questions\
**Tags:** node, google-sheets\
**Created:** [December 21, 2023, 9:15pm UTC](https://community.n8n.io/t/sheets-node-delete-rows/34462 "2023-12-21T21:15:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pablo\_de\_Brito\_Carva](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/pablo_de_brito_carva/32/33399_2.png) [@Pablo\_de\_Brito\_Carva](https://community.n8n.io/u/Pablo_de_Brito_Carva)\
**Post date:** [December 21, 2023, 9:15pm UTC](https://community.n8n.io/t/sheets-node-delete-rows/34462/1 "2023-12-21T21:15:22Z")

</div>

## 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_

---

<div class="post-metadata">

**Author:** ![MutedJam](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mutedjam/32/70851_2.png) [@MutedJam](https://community.n8n.io/u/MutedJam)\
**Post date:** [December 28, 2023, 1:55pm UTC](https://community.n8n.io/t/sheets-node-delete-rows/34462/3 "2023-12-28T13:55:14Z")

</div>

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](https://europe1.discourse-cdn.com/n8n/original/3X/7/4/74edf1dedef05d62d41e3fa261ebfd71cd0eb98f.png)

Hope this helps!

---

<div class="post-metadata">

**Author:** ![Pablo\_de\_Brito\_Carva](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/pablo_de_brito_carva/32/33399_2.png) [@Pablo\_de\_Brito\_Carva](https://community.n8n.io/u/Pablo_de_Brito_Carva)\
**Post date:** [December 28, 2023, 2:50pm UTC](https://community.n8n.io/t/sheets-node-delete-rows/34462/4 "2023-12-28T14:50:43Z")

</div>

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 🙂

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/36532_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [March 27, 2024, 2:51pm UTC](https://community.n8n.io/t/sheets-node-delete-rows/34462/5 "2024-03-27T14:51:17Z")

</div>

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