Google Sheets Tap

This is a Singer.io compliant (not yet) tap to stream data from Google Sheets to a Singer target.

Running it locally

Create a file called config.json in your working directory, following config.sample.json.

(originally found in the Google API docs)

Create a project here
Add the Google Sheets and Google Drive services from the library to the project
In the credentials section, add OAUTH credentials, and select "web application" as the application type.
Download the client id and secret and add them to the config.json file.
Navigate to the Google Oauth 2.0 playground
In the gear dropdown, choose "offline", and tick off the Use your own credentials
Select the Drive Readonly API, and make sure that the Sheets API is selected also. Then click Authorize APIs
Once you've logged in with a google account, click the Exhange authorization code for tokens button. Take the refresh token and place it into your config.json file.

Run python3 setup.py develop, this will install the tap
Run tap-sheets --discover --config config.json > properties.json, this will show the names and ids of your spreadsheets available. Use some of these to populate the properties.json file
Run tap-sheets --config config.json --properties properties.json, this will run the tap and give the current, non-singer compliant output.