🔌Setting up a Google Sheets Connector

Google Sheets Connector

This connector is used to retrieve data from a Google spreadsheet.

Add a Google sheets connector

In the DATASOURCES tab, in the datahub section

• Select the option Add a connector

• Then search up the connector from the list and select the Google Sheets connector.

• As soon as you click on the connector icon, you will be redirected by google to sign in to your account, in order to access to your google sheet. If not click on the button GRANT AUTHORIZATION to display the window

• After logging in, you shall be redirected back to Toucan, where you will have the required attributes automatically filled by Toucan.

• Give a name to your connector to identify it

• Now, You can click on SAVE

Now your Google Sheets datasource is plugged to Toucan and you can access to your data by create datasets

Add a Google sheets datasource

On the DATASOURCES tab, in the Datahub section

• To create a dataset from a Google Sheets connector, Click on the Create a new dataset from this connector icon.

Google sheets Create a new dataset from this connector

• You will be redirected to a modal New dataset from {{datasources_name}}

• In the Edit datasource section

  • ID OF THE SPREADSHEET (mandatory): string, Fill this field with the spreadsheet id which can be found in the url to access your google spreadsheet after thehttps://docs.google.com/spreadsheets/d/ (For example if your URL is https://docs.google.com/spreadsheets/d/a98db973kwl8xp1lz94kjf0bma5pez8c then the id is a98db973kwl8xp1lz94kjf0bma5pez8c)

You can have a look at this below image to have an understanding of ‘where to find’ the required parameters for filling the data source config:

ID of a spreadsheet in Google sheets

• SHEET TITLE (optional): string, title of the sheet you want to get, once you have fill your spreadsheet id, we will get all the sheet that exist and they will be displayed in a dropdown

• HEADER ROW (optional): int, default to 0. Row of the header of the spreadsheet

• Dates as float (optional): boolean, render date as float or string from the sheet true by default

Once you have fill all the necessary fields, you can click on

• PREVIEW to see the data Toucan will get from your Google sheets

• VALIDATE, your data will be created and you will redirected to the YouPrep interface

For more info, see the dedicated section Creating datasets

After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".