Google Sheets Plugin

This plugin provides a read and write connector to interact in your Dataiku DSS projects with Google Sheets documents, that are commonly named spreadsheets.

A simple connector to read a sheet from a Google Sheets document

Retrieving a spreadsheet in DSS.

Plugin information

AuthorDataiku (Jérémy Grèze)
Last updated2017-02-20
LicenseApache Software License
Source codeGithub
Reporting issuesGithub

How to use

You need to install the dependencies of the plugin. Go to the Administration > Plugins page to get the command-line to install dependencies

To use this plugin, you need to have a Service Account. You can create a Service Account from the Google Developers Console with Drive API enabled.

You will need to download the service account private key as JSON. When requested, paste the contents of the JSON file in the dataset configuration

To actually read a spreadsheet, don't forget that you need to share the spreadsheet with the email of the service account (in the form [email protected])

More information about this plugin is available here