Privacy Policy
SmartBQ'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.
Google Workspace APIs are not used to develop, improve, or train generalized AI and/or ML models.
Our code can only access your data while you're accessing the add-on. We don't sync your data to our own servers and we don't have any direct access to your data.
We use GoogleTM's PropertyService which allows us to attach limited data (such as saved API requests) to the spreadsheet itself and to the user, on GoogleTM servers. We then use Google Apps ScriptTM which runs exclusively on GoogleTM servers. The only data that syncs to our servers is the data entered and sent to PayPal (our payment processor) during the subscription process. When you install the add-on, we also collect your email address and name for licence and email marketing purposes.
We at SmartBQ do not have access to view any of the information stored in your Google SheetsTM. An example of the data collected is that a user with name John Doe and with email john.doe@gmail.com installed the addon on 17.09.2023.

Every app that GoogleTM approves must go through a strict security & privacy approval process, including ours. Google CloudTM Platform/API Trust & Safety Team has approved the SmartBQ add-on for the following scopes, which you can see on the OAuth screen in the screenshot above:
SmartBQ does not share any of your data with our api service.
See, edit, create and delete all your Google SheetsTM
spreadsheets
Scope:
https://www.googleapis.com/auth/spreadsheets
This permission allows the add-on
to read from and write data to Google SpreadsheetsTM
Connect to an external service
Scope:
https://www.googleapis.com/auth/script.external_request
This permission allows the
add-on
the following:
Display and run third-party web content in prompts and sidebars inside
Google applications
Scope: https://www.googleapis.com/auth/script.container.ui.
This permission
allows the add-on to be inserted into the menu of Google Sheets TM so you can
open
the add-on in a sidebar or dialog and set your sync between Google SheetsTM and BigQueryTM and make API requests.
View your data across Google Cloud services and see the email address of your Google Account
Scope: https://www.googleapis.com/auth/cloud-platform.read-only
This permission allows the addon to retrieve the cloud projects list.
View and manage your data in Google BigQuery and see the email address for your Google Account
Scope: https://www.googleapis.com/auth/bigquery
This permission allows the addon to retrieve data from BigQueryTM tables as well as create new BigQueryTM tables and upload data.
See and download any calendar that you can access using your Google Calendar
Scope: https://www.googleapis.com/auth/calendar.readonly
This permission allows the addon to retrieve the primary's Calendar timezone for a proper date formatting.
Send email on your behalf
Scope: https://www.googleapis.com/auth/gmail.send
This permission allows the addon to send you email notifications when scheduled queries encounter errors.
Manage your Cloud Platform projects
Scope: https://www.googleapis.com/auth/cloudplatformprojects
This permission allows the addon to access your cloud projects.
Allow this application to run when you are not present
Scope: https://www.googleapis.com/auth/script.scriptapp
This permission allows the addon to set triggers that will donwload or upload data in your absence.
When you install and open the add-on for the first time, GoogleTM will ask you to allow access for the permissions listed above.
We do not have access to view any of the information stored in your Sheets, Cloud or BigQueryTM. All of your drive/spreadsheet information is stored by GoogleTM and we don't have access to it.
None of your folders or spreadsheets information is synced to our servers.
Your payments and credit card information is stored by PayPal.
We also store your email address and name when you install the app for licence and email marketing purposes. We do not share your name or email address with any third-parties. You can unsubscribe from our emails at any time.
Security
The protection of your data is important to us. We are striving to use, to the best of our knowledge, available means of protection. However, please be aware that no method of transmission over the internet, or method of electronic storage is 100% secure or reliable, and we cannot guarantee the absolute security of the Service.
Data Sharing
We will share the data we collected about you for any legal obligations and rights. We may disclose your personal information in these circumstances: In connection with the establishment, exercise or defense of legal claims; to comply with laws or to respond to lawful requests or legal process; for fraud or security monitoring purposes (e.g., to detect and prevent cyberattacks); to protect our rights or our employees rights; or as otherwise permitted by applicable law.
Retention of Data
We may retain your personal information data as long as is necessary to fulfill the purposes for which it was collected and in accordance with applicable law.
Deletion of Data
Your data is saved to your GoogleTM Properties Service. To delete your data, uninstall SmartBQ.
Changes to this Privacy Statement
We may update our Privacy statement from time to time. Thus, you are advised to review this page periodically for any changes. These changes are effective immediately after they are posted on this page.