Skip to main content

Google Sheets Connections

Note

This feature may not be available in all product editions. For more information on available features, see Compare Editions.

Google Sheets provides a spreadsheet interface for cloud-based data stored in Google Drive. It allows multiple users to edit and format files in real-time. For more information, see https://www.google.com/sheets/about/.

You can create connections to your Google Sheets instance from the Dataprep by Trifacta platform. This connection is automatically created in your project and accesses Google Sheets based on the authenticated user of the Google Cloud Platform.

Test and Use

Steps:

  1. You can import datasets from Google Sheets through the Import Data page. For more information, see Import Data Page.

  2. Perform a few simple transformations to the data. Run the job. For more information, see Transformer Page.

  3. Verify the results.

In this section: