Google Sheets Integration

In this article, we’ll integrate a Google Sheets data source with Y42.

Google Sheets integration will generate tables containing data from the individual sheets within a spreadsheet.



Authentication: OAuth
Settings: None
Schema type: Fixed
Update Type: Full import


OAuth doesn’t share password data but instead uses authorization tokens to prove an identity between you and the service provider. OAuth is an authentication protocol that allows you to approve one application interacting with another on your behalf without giving away your password. For instance, when you tell tell Facebook that it’s OK for another application or website to access your profile. To sum up, you only need to have an existing account to authorize the access.


Import Settings


Note: Only the user who has connected their Google Accounts during the integration process is able to open File Picker to re-import the files or import new ones. Otherwise, Google will give you a warning saying you must sign in to your Google account in order to select the files.



Each sheet from your Google Sheets file is imported as a separated table.
Note: If none of your rows have numeric values, the column names from Google Sheets will not be imported as heading onto the Google BigQuery. However, if there's a number in any of the columns data, then the import will successfully take the first row as column headers.

Updating your data

For this source only a full import is possible. You have the option of scheduling updates by the month, weeks, days, and even by the hour.

Google Sheets Setup Guide:

Note: In order to connect Google Sheets with Y42, you will need to have a Google Account.

  1. On Integrate, click on "Add..." to search for Google Sheets and select it.

  2. Name your integration.

  3. Click Authorize and log into your Google account.

  4. After authentication, you are good to go, open file picker and start importing your tables.

  5. Select the tables you need and click import. You can start accessing the tables once the status is “Ready”.

Note: You can always import and reimport other tables as well, or delete them.

Was this article helpful?
0 out of 0 found this helpful