Driveshaft is a Sinatra application built to turn Google Spreadsheets and Google Documents into JSON with the click of a button.

• Quickstart
• Documentation
• Contribute

For the full user guide, please refer to the documentation. Or, if you're somewhat familiar with Ruby applications and Google Authentication / S3, use this quickstart guide to get up and running.

Deploy instantly with Heroku.

Be sure to have the following system dependencies installed:

# Git, Ruby, Node
$ brew install git node ruby

# Bower
$ npm install -g bower

# Bundler
$ gem install bundler

$ git clone [email protected]:newsdev/driveshaft.git
$ cd driveshaft
$ bower install
$ bundle install

Driveshaft uses environmental variables for configuration. Set the following variables either at runtime on the commandline, or in your /~.bash_profile.

Set at least one, or several, of the following to authenticate against the Google API. You will need to set up a Google Developers Project with the Drive API enabled. Then create a set of credentials. Public API Keys, and any of the three OAuth2 mechanisms, are supported.

To use an API Key, set GOOGLE_APICLIENT_KEY to the key. For any type of OAuth certificate, set the variable to a path to the certificate file, or the contents of the certificate itself.

# Public API Key
GOOGLE_APICLIENT_KEY="***"

# Native Application Client
GOOGLE_APICLIENT_CLIENTSECRETS_INSTALLED="***"

# Web Application Client
GOOGLE_APICLIENT_CLIENTSECRETS_WEB="***"

# Service Account
GOOGLE_APICLIENT_CLIENTSECRETS_SERVICEACCOUNT="***"

Required for S3 access. Use credentials that have access to any S3 buckets you wish to use.

AWS_ACCESS_KEY_ID="****"
AWS_SECRET_ACCESS_KEY="****"
AWS_REGION="us-east-1"

Driveshaft settings:

DRIVESHAFT_SETTINGS_AUTH_REQUIRED="false" # true to require client-side login
DRIVESHAFT_SETTINGS_AUTH_DOMAIN="nytimes.com" # restrict login to a single domain
DRIVESHAFT_SETTINGS_MAX_VERSIONS="5" # set to a maximum number of previous file versions to keep on S3

Optional drive key and s3 destination for a Google Spreadsheet to use to power the index page. It should follow the format of this spreadhseet (you can copy the spreadsheet into a new one to start).

DRIVESHAFT_SETTINGS_INDEX_DESTINATION="s3://BUCKET/PATH.json"
DRIVESHAFT_SETTINGS_INDEX_KEY="DRIVE_KEY"

$ puma

http://localhost:9292/

Documentation is available on the gh-pages branch. To view or contribute to the docs, checkout that branch, and run the following to start the documentation server:

gem install jekyll
jekyll server

Questions / comments / feature requests / concerns? Please use the Issues page.

• Michael Strickland
• Scott Blumenthal

Released at the OpenNews Code Convening at the 2015 Write The Docs conference, with the support of the Knight Foundation and The Mozilla Foundation.

The documentation and code are licensed under the Apache License, Version 2.0.

Copyright 2015 The New York Times Company.