🔌Setting up a Google Sheets connector

Google Sheets Connector

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

Add a Google sheets connection

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

• fill the fields necessary

Field	Format / Type	Description	Example
Name (mandatory)	String	Use it to identify your connection	MyGoogleSheetsConnection
Retry Policy (optional)	Boolean	Boolean allows to configure a retry policy if the connection is flaky. max attempts: maximum number of retries before giving up max_delay: in seconds, above the connection is dropped wait_time: time in seconds between each retry
Slow Queries' Cache Expiration Time (optional)	Integer	Slow queries' cache expiration time in seconds

• Now, click on the SAVE button

After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab

Create a dataset from a Google sheets connection

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

• 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)

Find a spreadsheet ID of a google sheets

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 Create a new dataset from a dataset

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