google-drive-writer

Writes data into Goole Drive files and spreadsheets.

Example configuration

TBC

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 redirec URI.

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

{ 
    "component_id": "keboola.ex-google-drive",
    "friendly_name": "Google Drive Extractor",
    "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-drive-writer.git
2. Change directory: cd google-drive-writer
3. Install dependencies: composer install --no-interaction
4. Create tests.sh file from template tests.sh.template.
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 tests.sh file.
6. Run the tests: ./tests.sh