Google Spreadsheets in Impure
From Impure Wiki
Impure allows you to load Google Spreadsheets as data source for your projects. This is very convenient since:
- Google Docs are free to create and use
- Anyone with a Google account can create and use it
- Spreadsheets can be made public very easily, to anyone, anytime
- The user interface is already very advanced and usable, very similar to MS Excel, Numbers, OpenOffice, etc...
1. create a document
One you’re logged-in Google with your Google account, point your browser to google.com or gmail.com. Then click in the “Documents” link on the upper-left menu (it may be hidden under the “more” drop-down menu.
You’ll be redirected to the Google Docs main screen. There, use the “Create new / Spreadsheet” option in the left-side menu to create a new Spreadsheet (of course you can also open an existing one if you wish).
You’ll be presented with a blank spreadsheet, that you can fill as you normally do with similar applications. Remember to give your new document a title, by clicking the “Unsaved spreadsheet” text.
2. sharing the document
Once you’re done with filling your data, you can make the document public by clicking the “Publish as a web page” option under the “Share” menu, on the right side of your screen.
This will pop-up a simple form where you should check the only check-box available there (titled “Automatically republish...”) and click the “Start publishing” button.
After that you can just close the form clicking the “Close” button.
And that’s it, all you need now in order to load this spreadsheet in Impure is the document key (a unique id), which you can copy from your browser URL field. It’s the text beetween “key=” and the first ampersand, “&”:
3. reading your spreadsheet in impure
All you need in order to use your Google spreadsheets in impure is add a GoogleSpreadsheetLoader module (under the APIs tab, tagged as “tables”, “loader” and “google”) and provide it with a valid Google Spreadsheets key, like the one you just copied in the previous step. This module will load the remote spreadsheet and convert it into a native Table object within impure.
