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.
Overview
Authentication
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
None.
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.
Schema
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.
- On Integrate, click on "Add..." to search for Google Sheets and select it.
- Name your integration.
- Click Authorize and log into your Google account.
- After authentication, you are good to go, open file picker and start importing your tables.
- 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.