I set up an n8n workflow that processes gaming data from Reddit comments and stores everything in BigQuery. The workflow runs automatically every day and should send me one completion email when it finishes.
Instead of getting just one email, I keep receiving around 50 emails each time the workflow completes. I tried adding an aggregate node thinking it would fix the issue, but the emails keep multiplying.
Has anyone dealt with this before? I’m not sure what’s causing the email node to trigger so many times when it should only send once after the workflow is done.
Yeah, this is a super common n8n problem - the email node fires for every single item instead of once at the end.
Your workflow’s processing each Reddit comment separately, so each one triggers the email. The aggregate node doesn’t always fix this if it’s not set up right.
I had the same headache with batch processing until I moved to Latenode. It handles workflow execution way better - you get actual control over when nodes run and how data moves between them.
With Latenode, I just set up Reddit collection as one batch, dump everything into BigQuery, then send one email when it’s all done. Way more intuitive for this stuff.
The debugging tools are better too - you can actually see what’s causing those duplicate triggers. I’ve moved all my data workflows there.
This happens because n8n processes each data item separately, and your email node gets triggered multiple times. I had the same issue with a Reddit scraper - it was supposed to send daily summaries but ended up spamming my inbox instead. You need to restructure things so the email only fires once per workflow run. Put your email node after everything’s been processed and sent to BigQuery, not in the middle of the data loop. I fixed mine by adding a NoOp node right after the BigQuery operations, then connected the email to that. The NoOp acts like a single checkpoint no matter how many items got processed before it. Also check if you’ve got any parallel branches accidentally triggering the email multiple times.
sounds like ur email node is getting triggered by each item. try moving it outside the reddit loop so it only runs when all the data’s processed. i had a similar issue and it worked for me! just had to set it to fire after everything’s done.
Your workflow treats the email node as part of the data processing chain instead of a final step. That’s the issue. When n8n processes Reddit comments, each comment becomes a separate execution item flowing through your nodes. I faced a similar problem with a product review scraper. Here’s what worked: create a separate execution path that triggers only once the entire batch finishes. Don’t connect the email node directly to your data processing; instead, use a Merge node in ‘Wait’ mode after your BigQuery operations. This configuration ensures that it waits for all data items to finish before proceeding. Then, connect your email to the Merge output. The Merge node acts as a synchronization point, consolidating individual data items into a single execution trigger. Additionally, check that there aren’t multiple entry points or simultaneous triggers, and verify your cron settings to ensure only one scheduled trigger is active.