URGENT: RSS Feed - Check if already stored in Google Sheets

Questions
, ,
1

Hi guys,

would be really glad if anyone can help me. Tried out many things but it doesn’t seem to work. The workflow is pretty straight forward. I have multiple RSS Feeds which I split in Batches and in theory I want to check the latest article if that’s already stored in my Google Sheets - if Yes then take on the next Batch (next RSS Feed) - if Not then append the article to the sheets and then take on the next Batch.

Does not take the latest articles even though I selected “execute only once” - it randomly took 2 articles from the middle of the RSS Feed Return. Don’t get that.

Any help is highly appreciated.

  • n8n version: 1.69.2
  • Database (default: SQLite): QLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own, main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): self-hosted in google cloud
  • Operating system: Windows10
2

Is this still a thing? What about putting a Limit node behind the RSS feed with 1 - this gets you the latest one. I just noted in the append your attributes don’t match the article object and I don’t have the sheet setup so couldn’t run it through.

1 Like
3

Hey @Kiremit Look at this workflow it works for me.

1 Like
4

Hi @Ruslan_Yanyshyn @jksr

"Limit node behind the RSS feed with 1 - " could you elaborate on that?
Cause my solution now starts inserting every single return which makes it quite time consuming with regards to the needed wait times.

The rest works:

The only problem is that apparently the 60 read/write limits from the Google SHeets API counts per column/value which means the wait times need to be adjusted.

5

In your OP you wrote

Does not take the latest articles even though I selected “execute only once”

I thought if you place a Limit node with a limit of 1 right after the feed, you will get 1 and the latest entry. But that would mean you already have the history of RSS in the sheet. So it will only solve part of the issue

6

Well, I mean it depends. These sites release articles every couple of days which means that running this scenario every couple of hours with the limit of one would definitely do it (just as an example). Still not sure if I get what you are referring to

7

OK let’s try to simplify maybe before we run in circles if I can’t explain. Have you thought about doing upserts in sheets? This would simplify it quite a bit, no?

2 Likes
8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.