Chartio’s Google Sheets connection allows you to automatically import Google Sheets from your account and use them like you would any other data source: a spreadsheet corresponds to a database and worksheets correspond to tables. Any updates made to rows in your Sheets data will be immediately queryable in Chartio.
Preparing your Google Sheet
- Remove extra headers and footers.
- Each worksheet should be in a tabular format, starting in the top-left cell, with all data arranged in columns and one header row with no empty header cells.
- The header row should contain no special characters (including newlines). Headers should contain only numbers, letters, and/or underscores.
- Use the Google Sheets Format menu to correctly specify the format of a column.
Connecting a Google Sheet
If you’re already signed into the Google account you want to associate Chartio with, you’ll be prompted with a simple permissions request to allow access. If you’re not, you’ll need to sign in to your Google account before access is allowed.
Google Sheets Limitations
Renaming the spreadsheet, a worksheet or a column is currently not supported. This will be treated as a deletion and addition and will cause errors with any charts currently using a renamed object. Moving a column or worksheet is supported.
The user that initially added the data source will need to remain as authorized and maintain access to the spreadsheet. If you’d like to change the authorizing user or re-authorize, this can be done from the Connection tab within the specific Google Sheet’s settings.
Any column named “Id” will be renamed to “Id1”. This is due to Google Sheets returning the row ID as “Id” which will show as a hidden column in your schema.
Google Sheets SQL Mode syntax
- Strings must be quoted using single quotes (e.g., ‘John Doe’).
- Use Oracle’s syntax for date formatting using the FORMAT() function.