I am almost done with my filter workflow. I will get the workflow to filter one time then it gets a A1 Notation Specify Row A50:xNull which ends on the second loop. I ask chatGPT and it sends me down another forever loop. Change A1 Notation to eliminate header and then it breaks a different way. Then it wants me to revamp my entire workflow. Which I have fallen for a couple of times. I started thinking for myself in that I thought if I used specify range (row) instead of A1 notation and used the row 1 header and an expression to specify which batch I was utilizing it would solve it. Didn’t work. Hopefully I am explaining this correctly. Just needing a little help.
Thank you in advance.
Describe the problem/error/question
What is the error message (if any)?
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
Share the output returned by the last node
Information on your n8n setup
- n8n version:
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app):
- Operating system:
1 Like
Hey @Octavios Welcome to the n8n community!
it’s almost certainly the Google Sheets step before it.
On the first run, your Sheets node returns rows, but on the second run your range/config ends up outside the data, so the Sheets node outputs 0 items and the loop has nothing to process, so it “stops”.
To fix it, focus on the Sheets node:
-
Use a stable range: either let n8n auto-detect, or set header row and first data row instead of a changing A1 expression.
-
On the second run, check each node before the loop and confirm they still output items. The first node that goes from “some items” to “0 items” is what you need to adjust.
If you share your Sheets node settings (range / data location) and where the loop connects, I can suggest an exact change.
1 Like
@Anshul_Namdev Thank you for the response. I worked on it a little bit. It is reading through the workflow properly. The only problem is that it is now writing into the spreadsheets 0-32, 0-64, 0-90, 0-122…. So it will break the write code eventually because it will request too much data. Chatgpt sends me down some loops that I have tried multiple times so your help is greatly appreciated.
1 Like
Hey @Octavios
The “0–32, 0–64, 0–90…” pattern means your write node is receiving accumulated items, so every loop it writes the previous batches again + the new one.
make sure the loop returns to the batching node (Split in Batches) and the write node only ever receives the current batch items.
Recommended flow:
Read → Split in Batches → Filter/Transform → Append → back to Split in Batches.
If you’re doing manual range batching, add an Item Lists “Slice” (or Code node) right before the write step to keep only the current batch items, otherwise the Merge/loop will keep growing the dataset.
After that, if you still hit rate limits, add a small Wait (500–1500ms) between batches. Let me know if this helps! And you can share your workflow code with us as well with that we can easily identify your actual configurations
