Privacy Policy

Our privacy policy explains how we use the data we access, collection, storage, usage, and disclosure of your information when you use our Cooltables add-on for Sheets™.

Disclosure

App’s use and transfer to any other app of information received from Google APIs will adhere to Google API Services User Data Policy, including the Limited Use requirements.

Consent Screen Breakdown

1. ➡️Display and run third-party web content in prompts and sidebars inside Google applications.

https://www.googleapis.com/auth/script.container.ui

This authorization allows us to display a sidebar interface within your Sheets™. This is solely used for providing an interactive user experience, enabling users to navigate through different features and services provided by the add-on. Your data isn't accessed or manipulated through this scope.

2. 🔵See, edit, create, and delete all your Google Sheets spreadsheets.

https://www.googleapis.com/auth/spreadsheets

This scope is sensitive, as it provides us with access to your Google Sheets to function properly. This access is needed to automate and manage your Sheets™, including reading, updating, and moving data from your Sheets™ to BigQuery. The data you access using our add-on will only be used within the context of the application to provide you with the intended service. It will neither be shared nor sold to any third parties.

3. ➡️Access and Manage BigQuery Data

https://www.googleapis.com/auth/bigquery

Another sensitive scope that gives us the ability to read, write, and update your BigQuery data. This is essential for loading your Sheets™ data to BigQuery. Your data is only used to provide you with the services of this add-on and is not used for any other purposes or shared with third parties.

4. ➡️Connect to an external service. 

https://www.googleapis.com/auth/script.external_request

To ensure the add-on functions effectively, we use this scope to make network requests to external services or APIs. Specifically, it's used to save your tasks securely to Firestore. Your task data is used only to provide you with the intended service and is not shared or disclosed in any way that goes beyond this purpose.

Data Collection and Use

Cooltables collects and accesses certain Google user data solely to provide and improve the functionalities of the add-on. The types of data we collect, or process on behalf of our users, are as follows:

• Google Sheets Data: We access and process data within your Google Sheets™ to enable features such as loading data to BigQuery, saving task histories, and other functionalities provided by the Cooltables add-on.

• Google Account Information: We may access basic account information, such as your email address, to authenticate your access to Cooltables and manage your preferences within the add-on.

Purpose of Data Collection

The data collected is used to provide the following services:

• Task Automation: To facilitate the creation, management, and repetition of tasks within Google Sheets™.

• Data Transfer: To securely transfer data from Google Sheets™ to BigQuery and other supported data sources.

• User Experience: To enhance the user experience by saving your task settings and history for easy retrieval and repetition.

• Analytics and Reporting: To enable the creation of reports and other analysis tools using your Google Sheets™ and BigQuery data.

Security Measures

We take the security of your data seriously and implement various measures to ensure its protection:

• Confidentiality: Security procedures are in place to protect the confidentiality of your data. Only authorized personnel have access to user data, and this access is subject to strict controls.

• Encryption: All data transmissions between your Google Sheets™ and Firestore are encrypted using industry-standard encryption protocols (e.g., HTTPS) to secure your information from unauthorized access or interception.

• Data Storage: Your tasks and settings are securely stored in Firestore, a NoSQL database service by Google, which ensures high availability and reliability of your data. Firestore complies with stringent security measures provided by the Google Cloud Platform.

Data Retention and Deletion

Data Retention

Cooltables is committed to responsible data management and retention practices:

• Retention Period: We will retain your personal information for the length of time needed to fulfill the purposes outlined in this privacy policy, unless a longer retention period is required or permitted by law.

• Extended Retention: In some circumstances, we may retain certain information for a longer period if it is required for legal obligations, dispute resolution, enforcement of our agreements, or to protect our legal rights.

Data Deletion

We respect your privacy and provide mechanisms for you to request the deletion of your data:

• User Requests: You may request the deletion of your data at any time through the support options available within the add-on. Upon receiving your request, we will review and process it promptly, taking the necessary steps to delete or anonymize your data where possible.

• Automatic Deletion: When the data retention period for a given type of data expires, we will delete or anonymize the data in a secure manner.

We value your privacy and strive to maintain the confidentiality of your data by using reliable and secure methods to store and use your information. Our add-on always operates within the boundaries of the terms and conditions outlined. We encourage you to review the Privacy Policy periodically to stay informed about the approaches we use to protect your information.

By using Cooltables, you agree to the collection and use of information in accordance with this policy.