Flatware provides a tiny S3 buffer between you and Google Spreadsheets, protecting you from downtime, lag and the terrifying caprice of Mountain View.
git clone firstname.lastname@example.org:jsoma/flatware.git cd flatware heroku create git push heroku master
Then you'll need to add in your Amazon Web Services keys and the bucket you'd like to drop the content in.
heroku config:add AWS_ACCESS_KEY_ID=xxx AWS_SECRET_ACCESS_KEY=yyy AWS_BUCKET=zzz
When you're using Tabletop.js, just pass
and as long as you've synced you'll be golden.
Easy-peasy. Over on the right you add either a spreadsheet key or a full URL like, so either of the below would work.
The easy way right now is to click "Sync all spreadsheets" over on the right-hand column
But you should probably run the rake task
rake flatware:process instead, which loops through all spreadsheets and tries to get them up on S3. On Heroku that would be
heroku run rake flatware:process
If you're using Heroku, you can use Scheduler to run
rake flatware:process every X minutes.
They docs for scheduling a task are kind of buried, you can find them here.
I made Flatware in like an afternoon so please please contribute to the repo on github.