Describe the problem/error/question I have to delete rows of my google sheet based on specific colum called “expired” if it has any value in it, it gets duplicated to another sheet (a workflow that works perfectly fine). Now Google Sheets is a bit tricky because you can only input the number of the …

It looks like your topic is missing some important information. Could you provide the following if applicable. n8n version: Database (default: SQLite): n8n EXECUTIONS_PROCESS setting (default: own, main): Running n8n via (Docker, npm, n8n cloud, desktop app): Operating system:

From what I understand, you want to take out the expired rows and put them into an ‘expired’ sheet, while keeping the rest in the original sheet. Here is a way to do that. It might not be super efficient, but it gets the job done given the constraints.

thanks for your reply! So far I was not able to find a super efficient way to work with google sheets :grin: The problem is the original sheet get´s bloated really quick with a lot of expired listings especially when vendors delete and reupload their listings. Your approach certainly attacks the pr…

Sure! To be honest, I feel like the Google Sheets node is lacking. A better way to do this would be to simply ‘Delete all cleared rows’, which would alleviate the need for the sheet swapping. I’m not sure if that’s a limitation of the API or of the node itself. At some point, I will try to investiga…

make.com has the same limitation you can only delete based on row number which changes dynamically … I tried to lookup their API documentation so I could potentially send an API request instead of using the node but that opened up more problems that it solved, for me at least.

not all heroes wear capes, this makes things a lot easier for me!

Setting the amount of loops for a "loop over items node"

Questions

KHarv September 14, 2024, 7:01pm 7

Just to update you on this–I did find a way to delete empty rows using the API and have submitted the change. Hopefully it will be merged into the next version of n8n

Filtering rows in google sheets with empty value in specific colum

Topic		Replies	Views
Loop in n8n Questions	1	3293	March 13, 2020
Sheets node - Delete rows Questions node , google-sheets	2	713	December 28, 2023
Google Sheets delete rows node deleting too many rows Questions	3	102	October 29, 2025
Problem with Google Sheets Node "Delete Rows" Questions	8	2288	March 9, 2024
Google sheet delete multiple Questions	9	1492	January 30, 2024

Setting the amount of loops for a "loop over items node"

Related topics