google-sheetsgoogle-sheets-formula

Import Data into Spreadsheet - Refresh Automatically

I would like to import data into a Google Sheets each day automatically without having to do it manually. I have about 50 numbers I need to import, each from a different page. One looks like this: http://www.alexa.com/siteinfo/sweatingthebigstuff.com

I want the 244,604 imported into my document and to refresh automatically. Once I get the code for doing it once, I'll be able to repeat it for the other information too.

Any ideas?

Solution

  • Google Spreadsheets has developer APIs for .NET, Java, PHP and Python. So just screen-scrape the Alexa page and update the document via the API, in the language of your choice.