Google Sheets delete rows node deleting too many rows

[Gabe_Robinson]

Describe the problem/error/question

When the Google Sheets node is set to delete 1 row, it is deleting many more, up to 1000 if they are there. I have both the clear sheet node and delete node set to only run once, but this continues to happen. I’m not entirely sure what the fix would be, it may be a bug.

The workflow is set to get the sheet row that matches the right credentials. It is only returning one row, but is still continuing to delete far more than that.

What is the error message (if any)?

None

Please share your workflow

Share the output returned by the last node

[
{
“success”: true
}
]

Information on your n8n setup

• n8n version: 1.117.2
• Database (default: SQLite): SQLite
• n8n EXECUTIONS_PROCESS setting (default: own, main): own,main
• Running n8n via (Docker, npm, n8n cloud, desktop app): Desktop App
• Operating system: Windows 10

[Piotr_Sikora]

Hi @Gabe_Robinson

Both nodes ‘Clear sheet’ and ‘Delete rows’ removes a 1 row.

So as I understand after workflow there should be 2 rows removed from the document.

Please check “Executions” of the workflow in n8n instance and history of “Google Sheets” to check how many rows are removed per one execution of workflow.

[Gabe_Robinson]

The clear sheet node is for a different worksheet. It is for worksheet “Raw”, and the Delete Row node is for worksheet “Formatted”. It shows that only one row is deleted from what I am seeing.

[Piotr_Sikora]

I’m running same case on my side:
Calendar output:

Simplified “Get row” to match two rows (to check if there is any option to remove two rows)

Before:

After:

Still removes only one row.

So from my side your workflow is OK.

Is it possible on your side that this flow is ran two times or even more times in a row?
Please check if there is more executions of this workflow.