Mastodon RSS to Google Sheets, reverse ordering

[cogdog]

What is your goal?

I like to maintain a google sheet of my mastodon activity as a searchable archive.

What is the problem & what have you tried?

Having trouble getting all activity in the correct order. My first attempts where just connecting the RSS module to Google Sheets, appending the RSS feed Description, Date, and URL fields. If I run it ever 30 minutes seeking the 10 most recent items, they get appended as new rows in reverse chronological order.

So my next approach after reading posts here was to create a flow RSS → Array Aggregator → Iterator (reverse array) → Google Sheets.

Its closer to working, but I seem to be sometimes getting repeated items written. My guess was the the RSS Module would send only new items to the flow, but this seems wrong.

Should I be checking the Array option for “Stop processing after an empty aggregation”? I am not sure what is wrong here.

Create public scenario page

https://us1.make.com/public/shared-scenario/JXVIv5v2Fxy/fetch-mastodon-to-sheets

Screenshots (scenario flow, module settings, errors)

[mszymkowiak]

Hello,

Welcome to the Community!

Please right-click on the RSS module and click on “Choose where to start”

Then, select “From now on”.

Next you must set “yes” to Stop processing after an empty aggregation in Array aggregator module config:

So from this:

you will go to this:

Hope it will solve your problem
Michal