can directly import Google® Sheets® spreadsheets.
The sheets of a spreadsheets can be imported as:
A single dataset
NOTE: This integration provides access to all Google Sheets in the connecting user's account. Access includes spreadsheets with disabled options for download, print, or copy as well as hidden sheets within spreadsheets.
NOTE: After you import a Google Sheet into , renaming the source Google Sheet or a tab in it can break your datasets and flows. Details are below.
Source Sheets files with cells bracketed by single double quotes may not be properly ingested if any terminating quotes are missing.
Tip: You can check the data quality bars for mismatched values or, for strings, the data histogram bars for anomalous values to see if the above issue is present. If so, deselect Detect Structure on import. Then, use a Split rows transformation applied to the affected column to break up the column as needed.
A spreadsheet can be read directly from your Google Drive.
NOTE: When you first use the Google Sheets connector, you must enable to read all of your Google Drive data. When the connector is used, it locates only the Google Sheets data, including any Sheets that have been shared with you. All other data in Google Drive, including any Microsoft® Workbooks®, is ignored. You can then select the Sheet or Sheets you wish to import.
In the Library page, click Import Data. Select the Google Sheets connection.
Tip: You can paste links that you gather from Google to select spreadsheets. To access a Google Sheet, edit the path and paste the link. Use this method for publicly available Google Sheets, too.
See Import Data Page.
Import Google Sheets spreadsheet
After you select the spreadsheet, it is uploaded and converted to CSV format and stored by the platform. Depending on the size of the spreadsheet, this process may take a while.
By default, all sheets in the spreadsheet are imported as individual datasets. To change how the data is imported, click Edit in the right panel.
Import settings for Google Sheets datasets
Selected sheets into 1 dataset: All selected sheets in the spreadsheet are combined and imported as a single dataset.
NOTE: The schemas of each dataset must match. Columns must be listed in the same order in each dataset. The column headers are taken from the first selected dataset.
All and future sheets into 1 dataset: If the spreadsheet is updated periodically with new sheets that you would like to add in the future, select this option. After initial selection of sheets, all sheets that are added to the spreadsheet in the future are automatically added as part of the imported dataset.
You can select the sheets to import.
NOTE: Special characters in sheet names are filtered out.
To preview the data of an individual sheet, mouse over a dataset and click Jump to.
After you have imported the Google Sheet, you should avoid renaming the Google Sheet or any tab in it that is part of the imported datasets. If you rename a datasource, you can see one or more of the following issues in :
Creating the Dataflow job failed unexpectedly.