I have a Google Sheets that fetches some data via RSS. The RSS feed is updated once a day, everyday.
Is it possible for me to keep archive of all the new and historic data in the spreadsheet?
The data itself is not a lot, i.e. one new entry is added into the RSS feed per day. So far, I have it working fine but it only displays today's RSS feed, and not what was displayed yesterday or the day before. I would like to keep historical a record of all the data that has been displayed in the feed. So the spreadsheet would have to add one new entry per day, and perhaps shift the old one down (or append the new entry to the bottom of the sheet).
I cannot publish my spreadsheet here but as an example, I have set up a public spreadsheet with a Twitter RSS feed.
My spreadsheet is very similar to the one above and I would like to retain a copy of every new item that is added once a day.
Is there any way to do this?