The Google Sheets integration enables you to use your Google Spreadsheets as tables in your Cooladata project, and query them directly from your Cooladata project.
Connected spreadsheets are always updated and reflect the exact data your sheet contains.
When connecting a Google Spreadsheets to your Cooladata project you have several configuration options:
- Integration name: any name you’d like that helps you identify the integration.
- Table name: the name of the table in the project that you will then use in queries. Must comply with table name standards: no special chars or spaces, no reserved names.
- Sheet URL: the link to the Google Spreadsheet you wish to connect. Note that only the first sheet for the spreadsheet is used for the integration.
- Email notification: any email address you’d like to be notified on in case of failure to connect to the Google Spreadsheet.
- Notification level: select whether you’d like to be notified only on failure to connect or on all issues.
- Header rows to skip: we assume your spreadsheet contains one row of column headers by default, and skip that row in the data. If your sheet doesn’t contain header, or if you’d like to skip more than 1 header row, change the number of rows to skip here.
- Table schema: the Google Sheets integration automatically recognizes the column header and type of data in each of your columns. However, you can also manually set it up, which might be useful when a column is wrongly classified, or if your sheet does not contain headers. Note that when you make changes to the table schema, i.e. add/remove/replace any columns, or change a column name, you can update the schema by running the integration – either click “Update” on the integration settings, or from the row options, choose “Run now”.
The new table will be added to your project Schema, under Integration Tables, in the Table Name you selected. Query it by using the following syntax: