About Cooltables add-on for Sheets™

Cooltables is an innovative add-on specifically designed for Google Sheets™. 

Our primary focus is to provide you with the capability to automate your Sheets™, thereby enhancing convenience and efficiency. 

The current version of our extension is endowed with the feature of loading data effortlessly from Sheets™ to BigQuery. 

Not only is the process designed to be smooth and user-friendly, abiding by the principles of UI/UX, it also allows for repetitive data loading. 

Users can save their desired settings to the task history which can later be easily retrieved and repeated via the add-on menu. Every task is securely stored in Firestore, enabling you to handle a multitude of tasks without a hitch. Entrust your Sheets™ management to Cooltables and experience a whole new level of ease and control.

Convert your Sheets™ to BI

Cooltables allows you to get the most out of your data in multiple ways. Here's how:

1. ➕Save Data to BigQuery: With Cooltables, you can easily move your data from Sheets™ to BigQuery. The process is simplified and makes data saving an effortless task.

2. Load Tables From Multiple Sources into BigQuery.

3. Leverage Connected Sheets: Make use of the Built-in feature 'Connected Sheets' to load and query data from BigQuery directly onto your Sheets™. This is a brilliant way to create quick and sophisticated analytics.

4. ➕Reload Fresh Data: The process does not end at first use. Repeat the process as many times as you need, loading fresh data every time to keep your analysis and reports up-to-date.

5. Design Looker Studio Reports: Build comprehensive business intelligence by creating Looker Studio reports based on your BigQuery data. Create BI reporting system by ensuring that data analysis and reporting go hand-in-hand.