N8N Memory issues

for some reason n8n is not able to clear 1k rows and throwing memory issues
any solution ?

1 Like

Hi @Marketing_Tools I see you are using n8n cloud, and although the error message should not arise at least in 1k rows, but this can be due to as i can see you have a lot of data moving around in a single session/run, what i would recommend is that use a loop with batches like 50-70 per request and then a wait for 5-10sec and that would really help. (by the way your chrome tabs are crazy :laughing: )

2 Likes

Hi @Marketing_Tools

From my perspective, the better solution is to have Clear sheet run on its own with just a single input item, instead of placing it after the node that reads all rows. I’d connect Start directly to Clear sheet and use the Google Sheets Clear > Whole Sheet operation there, so it runs only once without carrying all row data through the execution. If reading the rows is needed for some other reason, I’d keep that in a separate branch or even a separate workflow so the clear step stays independent.

i found the solution had to add execute only once to handle such cased..took me a while but yeah

1 Like