Google Sheets API Writer

Writes data into Google Drive files and spreadsheets.

Example configuration

{}

OAuth Registration

Note that this writer is using Keboola OAuth Bundle to store OAuth credentials.

1. Create application in Google Developer console.

• Enable APIs: Google Drive API, Google Sheets API
• Go to Credentials section and create new credentials of type OAuth Client ID. Use https://SYRUP_INSTANCE.keboola.com/oauth-v2/authorize/keboola.ex-google-drive/callback as redirect URI.

2. Register application in Keboola Oauth http://docs.oauthv2.apiary.io/#reference/manage/addlist-supported-api/add-new-component

{ 
    "component_id": "keboola.wr-google-sheets",
    "friendly_name": "Google Sheets Writer",
    "app_key": "XXX.apps.googleusercontent.com",
    "app_secret": "",
    "auth_url": "https://accounts.google.com/o/oauth2/v2/auth?response_type=code&redirect_uri=%%redirect_uri%%&client_id=%%client_id%%&access_type=offline&prompt=consent&scope=https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/userinfo.profile https://www.googleapis.com/auth/userinfo.email https://www.googleapis.com/auth/spreadsheets.readonly",
    "token_url": "https://www.googleapis.com/oauth2/v4/token",
    "oauth_version": "2.0"
}

Development

App is developed on localhost using TDD.

1. Clone from repository: git clone git@github.com:keboola/google-sheets-writer.git
2. Change directory: cd google-sheets-writer
3. Install dependencies: docker-compose run --rm dev composer install
4. Create .env file from template .env.dist.
5. You will need working OAuth credentials.
   • Go to Googles OAuth 2.0 Playground.
   • In the configuration (the cog wheel on the top right side) check Use your own OAuth credentials and paste your OAuth Client ID and Secret.
   • Go through the authorization flow and generate Access and Refresh tokens. Copy and paste them into the .env file.
6. Run the tests: docker-compose run --rm dev composer tests

License

MIT licensed, see LICENSE file.