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: Before you begin, you should review information on file formats supported for import, which cause your files to fail to import or to be properly ingested and formatted. For more information, see Supported File Formats.
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.
D s product
- Creation of a dataset with parameters from Google Sheets is not supported.
Connected sheets or embedded external datasources in your Google Sheets are not supported.
Tip: If your connected sheet is linked to a table-based source, you may import that source directly into the product.
- If you have enabled Google Advanced Protection, this connection type does not work.
- A Google Sheet can contain up to 5,000,000 cells. Each cell can contain up to 50,000 characters.
supports a maximum of 25,000 characters in a cell.
D s product
- Filepath and source row number information is not available from original Sheets. These references return values from the CSV files that have been converted on the backend. For more information, see Source Metadata References.
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.