🔌Setting up a Google Sheets Connector

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

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

This connector does not support Excel files (.xls, .xlsx, etc.) saved on Google Drive.

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.

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:

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".

Last updated 3 months ago