Google Drive is a cloud-based spreadsheet application developed by Google. It is a web-based alternative to traditional spreadsheet software such as Microsoft Excel, and is part of the Google Workspace suite of productivity applications. The Toric Google Drive connector allows users to quickly login to a Google account and get direct access to spreadsheets. With ingestion features like Automations, users can ensure their CSV, XLS, or Google Sheets files are always up to date in the Toric system.

With the Google Drive connector, Toric users can:

• Use their CSV, XLS, or Google Sheets data in our no-code workspace for engineering and visualizations.
• Cleanup and transform data in a non-destructive way.
• Reuse your data transformations for new versions and projects with reusable data flows.
• Access version history to compare and analyze differences and changes over time.
• Blend your files with other sources with a few clicks.

Configuration Guide

Setup time: 45 seconds

Requirements:

• Google Account
• Web Browser (Safari, Chrome, Edge, Firefox)

1. Navigate to the Connectors

To find connectors in Toric, you must be signed in to your account. On the left side panel of your Workflow, click on "Integrations".

2. Select the Google Drive Connector

Under the ‘Standard Connector’ header, navigate to the ‘Google Drive’ thumbnail and click on ‘Setup Integration’.

3. Click on Create a Connection

4. Fill in the required information

Enter a Configuration Name and use your Google credentials to log in to Google Drive.

5. Click on Validate Configuration

Now that you have all Configuration details filled in, click on Validate Configuration.

If the information entered is valid, a Validation Successful message will appear.

- Invalid fields will be highlighted in red and a successful validation will show in green.

6. Click “Add Configuration” to finalize your configuration

Data Access

Toric supports the following files types in the Google Drive connector:

Don't see what you’e looking for? We're always happy to explore new access. Contact us here!

Security and Permissions

Toric requires user authorization to access private data from built-in Google services. Users can connects to both personal and shared drives.

Integration Capabilities Supported by the Connector

Toric support Google Drive as an ingestion source, and we currently support ingesting the following file types:

• Google Sheet
• XLSX
• CSV

Related Articles

https://www.toric.com/support/configure-google-drive

https://www.toric.com/blog/how-to-get-started-with-torics-standard-sources

Questions?

W‍e're very happy to help answer any questions you may have. Contact support here or send us an email at support@toric.com.