Privacy Policy

Privacy Policy

Effective Date: May 1st, 2025

Last Updated: May 1st, 2025

1. Introduction

Welcome to Event Registration Ranker ("the Add-on"), a Google Sheets™ add-on provided by Mind Storm Software ("we," "us," or "our"). We are committed to protecting your privacy. This Privacy Policy explains how we collect, use, disclose, and safeguard your information when you use our Add-on. Please read this privacy policy carefully. If you do not agree with the terms of this privacy policy, please do not install or use the Add-on.

2. Information We Collect

The Event Registration Ranker Add-on is designed to operate directly within your Google Sheets environment.

• Google Sheets Data: The Add-on accesses and processes data that you have in the Google Sheet where the Add-on is active. This includes the content of the cells in your "Target Data Sheet" that you configure for scoring, specifically the columns you select as criteria and their corresponding values for each row (registrant).

• Configuration Data: To function, the Add-on stores configuration settings you create through its sidebar interface. This includes:

  • Application Settings: The name of your target Google Sheet and your preference for sorting results.

  • Scoring Criteria: The rules you define for scoring (column names, evaluation types, values to match, points, weights, and case-sensitivity preferences).
    This configuration data is stored using Google Apps Script's PropertiesService (specifically, UserProperties, which are tied to your Google account and the specific script, or DocumentProperties, tied to the specific spreadsheet document).

• Google User Information (Implicit):

  • To save settings using UserProperties, the Add-on operates under your Google account's authority after you grant permissions. We do not directly collect or store your Google account email address or personal profile information on external servers. The PropertiesService is a Google-provided storage mechanism within your Google environment.

  • The Add-on requires standard Google OAuth scopes to function, such as https://www.googleapis.com/auth/script.container.ui (to display the sidebar) and https://www.googleapis.com/auth/spreadsheets.currentonly (to read data from and write scores to your active spreadsheet) and https://www.googleapis.com/auth/script.storage (to save your configuration).

• We DO NOT collect or store on any external servers:

• The content of your Google Sheets.

• Your specific scoring criteria configurations (these are stored within your Google account's PropertiesService).

• Any personal information about you or your registrants, beyond what is necessary for the Add-on to perform its functions within your Google environment.

3. How We Use Your Information

The information accessed and processed by the Add-on is used solely for the following purposes:

• To Provide Add-on Functionality: To read your configured data sheet, apply your defined scoring criteria to the rows in that sheet, calculate weighted scores, and display these scores and breakdowns within your Google Sheet.

• To Save Your Configuration: To store your application settings and scoring criteria using Google's PropertiesService so they persist between sessions and for your future use within the Add-on.

• To Improve User Experience: We may analyze anonymized usage patterns (e.g., which features are used, errors encountered within the script execution logs visible to us as the developer via Google Cloud Platform logging if enabled for the project) to improve the Add-on's functionality and stability. This does not include accessing the content of your sheets or personal data.

4. How Your Information Is Stored

• Spreadsheet Data: Remains within your Google Sheet, under your Google account's control. The Add-on reads from it and writes results back to it.

• Configuration Settings: Stored within your Google account's associated storage using Google Apps Script PropertiesService. This data is not accessible to us externally.

5. Disclosure of Your Information

We do not sell, trade, rent, or otherwise transfer your personally identifiable information or the content of your Google Sheets to outside parties. All processing and storage (for configuration) occurs within your Google environment, facilitated by Google Apps Script.

The Add-on's script code is executed by Google's servers as part of the Google Workspace environment. Google's handling of data is governed by Google's Privacy Policy and Terms of Service.

6. Security of Your Information

We use administrative, technical, and physical security measures provided by the Google Cloud Platform and Google Apps Script environment to help protect your information. While we have taken reasonable steps to secure the information you provide to us or that the Add-on processes, please be aware that despite our efforts, no security measures are perfect or impenetrable, and no method of data transmission can be guaranteed against any interception or other type of misuse.

The security of your spreadsheet data is primarily managed by your own Google account security and sharing settings for your Google Sheet.

7. Your Control and Choices

• Data in Sheets: You have full control over the data in your Google Sheets.

• Configuration: You can view, modify, and clear your scoring criteria and application settings through the Add-on's sidebar interface. Clearing criteria and app settings and saving will remove them from PropertiesService.

• Uninstalling the Add-on: You can uninstall the Add-on at any time via "Extensions" > "Add-ons" > "Manage add-ons" in Google Sheets. Uninstalling will prevent the Add-on from running further. Configuration data stored in PropertiesService might persist but will become inaccessible if the script ID changes or the script is deleted (though UserProperties are generally tied to the user and script ID).

• Revoking Permissions: You can revoke the Add-on's permissions to your Google Account at any time by visiting your Google Account permissions page: https://myaccount.google.com/permissions.

8. Changes to This Privacy Policy

We may update this Privacy Policy from time to time. We will notify you of any changes by posting the new Privacy Policy on this page and updating the "Last Updated" date. You are advised to review this Privacy Policy periodically for any changes. Changes to this Privacy Policy are effective when they are posted on this page.

9. Contact Us

If you have any questions or concerns about this Privacy Policy or the Add-on's practices, please contact us at: admin@mindstormsoftware.com