Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have a google spreadsheet 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 & historic data in the google 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 todays 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?

Im open to suggestions if this question can be phrased/improved in a better way.

share|improve this question
    
Just saw this question: google.com/support/forum/p/Google%20Docs/…. Its exactly what I am looking for - last answer seems a little vague though. –  mozami Mar 11 '11 at 22:48
    
did you find the solution? I am in need of same functionality, but haven't been able to figure out how. –  user12125 Jul 13 '11 at 10:43

2 Answers 2

Write a script that archives your data and set it as time-driven.

share|improve this answer

=ImportFeed(URL; [feedQuery | itemQuery]; [headers]; [numItems]).

This function imports an RSS or ATOM feed, just as you can in Google Reader.

For more information on this go to : Functions for external Data : Functions - Google Docs help

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.