Public | Automated Build

Last pushed: 3 months ago
Short Description
Driveshaft is a Sinatra application built to turn Google Spreadsheets and Google Documents into JSON
Full Description


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


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.

Heroku Quickstart

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

Clone the repository and resolve app dependencies

$ git clone
$ cd driveshaft
$ bower install
$ bundle install

Environmental Variables

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

# Native Application Client

# Web Application Client

# Service Account

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


Driveshaft settings:

DRIVESHAFT_SETTINGS_AUTH_REQUIRED="false" # true to require client-side login
DRIVESHAFT_SETTINGS_AUTH_DOMAIN="" # 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).


Run the app locally

$ puma



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.


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.

Docker Pull Command
Source Repository