Google Sheets "Add Row" Module adding each bundle multiple times

Hey everyone,

I’m new to Make and currently tweaking my first scenario.
It fetches new articles from inoreader, runs them through ChatGPT and outputs a summarizing newsletter to me every day, saving me time. In trying to channel bundles through the process without getting one email per bundle, I use a google sheet to store data, that I address with “Add a Row”.

Unfortunately, bundles are added multiple times - sometimes twice, sometimes 90 times (!), draining my operations. I havent been able to solve this issue yet. I may be able to block this from the sheets side, but that wouldnt solve the operations issue. Here’s a partial screenshot of the scenario, each horizontal arm fetches different article categories. You can see the error in the top one, getting one bundle and adding 4 rows. The parser module is used to get a thumbnail image src, that inoreader only outputs in a huge variable containing the whole article.

I am fairly new to this, so any ideas are welcome. Also, I am aware that the google sheet part is probably a workaround that can be done more elegantly. Happy for any feedback you may have.

Best
Gen

1 Like

Hey @Generic1337

To assist you better, could you please tell us what are you trying to achieve???

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

1 Like

Hey,

sure, so on top level, the scenario fetches articles and newsletters and outputs one summarizing newsletter on those.

The input comes from lists in inoreader, article data including title, URL, img src, etc. These are put into rows in excel sheets, one row per article. These are then put into JSON files and sent to Chatgpt to analyze and summarize. The ChatGpt prompt collects multiple variables to create one text output to be sent via email.

Previous attempts with arrays instead of google sheets, or directly sending inoreader data to chatgpt resulted in chatgpt not being able to process the data. This workaround solved these issues, though I am aware there might be better solutions.

While each article is only supposed to be added to the google sheet once, it curently is added multiple times (4-90 each so far), draining my operations. I want each article to only be added once.

Please let me know if you need more info, looking forward to your ideas.

Best
Gen