Hello, I am trying to build an autmoation which will scan RSS news feeds when i execute it.
Flow description:
Scan given RSS feeds / link
Check if there are any new news compared to last execution
Append new scanned items to sheet called “Data”
If no new items, do nothing
Also add Newly added lines to sheet called “NewNews” to get good overview of added items.
PS! NewNews sheet should be cleared right at the start of execuition, so only new added files get appended there.
I also hpped i could add summary column to all news which will generate small summary using AI after each news and then have this automation run automatically every month and email me a list of new news with summaries, but thats too much for me to generate
Currently I have this. So it works so it adds items to Sheet1 and if i remove some from that table and run again, it adds those removed lines, which is nice.
But I cant get the part working, where i add new things to both data table and also NewNews sheet, to get good climpse on what was added and if i run it weekly, to send out email with those new news only.
At some point i wish to make it automatic, so it would run once a week itself,. gather only added news and send those to my email, but that is far fetched for me atm
Also another thing which i want to add, is “Summary” column, which generates summary of those news using AI and then include links and summaries in email.
If you need to only send new entries, you will have to filter them out by pubDate.
To find the date of the first day of the current week you could use the expression
{{ $now.beginningOf('week') }}
or simply {{ $now.beginningOf() }}
but I wish to basically send items which were added @execution.
So lets say I have a scenario like this:
I have 10 rss inputs and they have generated me 200 lines of news. Now i add 1 more rss and that will brin 10 new news into dataset, with dates going back 5 months etc. My idea is that this new rss + new data from existing rss’es (what were added to the main data list since last execution) are now added to sheet “NewNews”.
SO basically every execution will just update my main data sheet and then all added items will be put onto sheet “newnews” which is cleared after every execution start to show new fresh items.
EDIT: and currently my code just adds stuff to main data and nothing goes to NewNews. In node New Item, everything gets passed to False. But I wish it would check if it is in a list already, if yes then then do nothing. If not on the existing list, then add it to the list and add it to the NewNews sheet
