Google Sheets

This plugin provides a custom connector to get the contents of a worksheet in a Google Sheets document into your DSS project

Retrieving a spreadsheet in DSS.

Plugin information

AuthorDataiku (Jérémy Grèze)
Last updated2015/11/12
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

More information about this plugin is available here