ColorSum: Count & Sum Colored Cells by Color — Privacy Policy
Last updated: 16 November 2026
ColorSum is an add-on for Google Sheets™ that counts and sums the cells of a spreadsheet by color. This policy says what it does with data, including the Google user data it receives.
What Google user data ColorSum accesses
- The spreadsheet you use it in (scope
spreadsheets.currentonly). ColorSum reads the values and colors of the cells you select or name in its formulas, writes the formulas you ask for into the cell you select, and rewrites its own formulas to refresh them. From version 18, with the refresh ticked, it also reads the spreadsheet’s conditional-formatting rules, to find the formulas a rule’s colors affect. ColorSum reads its own formulas and the ranges they name in the open spreadsheet to show you which ones need Pro in your sidebar and in a notice on your screen, and does not store or send them. It has no access to your other spreadsheets or files. - Your email address (scope
userinfo.email). It is how your purchase or existing subscription is found: ColorSum looks up the Stripe customer with this email and, when you start a checkout, creates one. It is also shown in ColorSum so you can check which Google account is used for your selected cells, allowance and billing. Google’s installation screen may also say the add-on can ‘associate you with your personal info on Google’. That is Google’s standard sign-in association; ColorSum does not request, read or store your profile information. - Sidebars and menus (scope
script.container.ui), to show ColorSum inside Sheets™. - A trigger in that spreadsheet (scope
script.scriptapp), only if you tick “Refresh them when a color changes”: it refreshes ColorSum’s formulas when a format changes there, or, from version 18, after an edit when a rule that reads other cells may have changed the colors they count. From version 18, it keeps only a marker that an edit happened, with no content from the spreadsheet, for up to 10 minutes. It is deleted when you untick the box. - Connections to outside services (scope
script.external_request), to exactly one: Stripe (api.stripe.com), to check purchases and existing subscriptions, and sell one-time unlocks.
How ColorSum uses that data
- Your cells are read inside Google’s Apps Script and the results are written back to your spreadsheet. They are not sent anywhere else and not stored by ColorSum outside your spreadsheet.
- Your settings (your plan status, your free allowance and usage, and your Stripe customer number) are kept in your own Google account’s storage for the add-on. A spreadsheet where Pro is checked keeps dates until which its formulas work: the existing subscription date with its three-day grace, or 30 days from a successful one-time-purchase check. These dates contain no email or cell contents. Expiry does not delete them. From version 17, a spreadsheet opened by an account with the total allowance keeps a note of its free formula size (a number of cells); it contains no email or cell contents and does not expire.
- Free allowance records in your Google account’s add-on storage keep which allowance applies, why, and its usage. The latest Count adds a random identifier, a one-way fingerprint of the selected source and options, reserved and confirmed counts, and status to avoid counting a retry twice. No cell values, colors or calculated results are stored in these account records.
- A count of your runs: once ColorSum is on the Marketplace, the same storage counts the runs that did their job, so that after the third it can ask you, once, whether you would review it. It is used for nothing else.
- Payments are made on Stripe’s checkout page. Stripe receives your email, card and billing address; ColorSum never sees your card. We can see in Stripe your email, your billing country and your purchase or existing subscription, which we need to provide the service and to account for tax. Stripe’s Privacy Policy applies.
ColorSum uses Google user data only for the features above. It does not sell or rent it, does not use it for advertising, and passes it to no one except as those features need: your email to Stripe. ColorSum has no servers of its own. The contents of your spreadsheets are never sent to us or to anyone else. ColorSum uses no analytics service; it counts in its own error log how many accounts reach each usage step described below.
ColorSum does not use Google user data, including data received from Google Workspace™ APIs, to develop, improve or train AI or machine-learning models, generalized or personalized.
ColorSum’s use and transfer of information received from Google APIs adheres to the Google API Services User Data Policy, including the Limited Use requirements.
Who ColorSum shares Google user data with
ColorSum shares, transfers or discloses Google user data only to these, and only for the purposes given:
- Stripe (our payment processor, Privacy Policy) receives your email address, to find your plan and, when you buy, to create your customer record and take the payment. Stripe receives nothing else of your Google user data: no spreadsheet content.
- Your cells never leave Google’s services: ColorSum reads them and writes its results back to your spreadsheet inside Google’s Apps Script.
Nothing else is shared, transferred or disclosed: ColorSum does not sell, rent or trade Google user data, and does not give it to advertisers, data brokers, analytics providers or any other third party. We would disclose it only if the law required us to, and only what it required.
How ColorSum protects that data
- Encryption in transit. Everything ColorSum sends or receives travels over HTTPS (TLS): between your browser and Google, and from Apps Script to Stripe.
- Encryption at rest. Your spreadsheet, ColorSum’s settings and its error log are stored by Google, which encrypts the data it stores. Your customer record is stored by Stripe, which encrypts it too.
- Access controls. ColorSum runs inside Google’s Apps Script, as you, with only the scopes above and only in the spreadsheet you open it in. We have no access to your spreadsheets or to your settings; only ColorSum, running as you, reads them. Your customer record sits in our Stripe account, which only we can sign in to. ColorSum reaches Stripe with a restricted key that stays on Google’s servers and never reaches your browser.
- Never stored: the contents of your spreadsheet outside it, your card details, and your Google password or sign-in tokens.
- Errors: when something fails, its error message (such as a Stripe error, or the name of a sheet it could not find) goes to ColorSum’s error log in Google Cloud™, which only we can read.
- Usage steps: each of these steps adds one line to the same error log, naming only ColorSum and the step: the sidebar opens, it opens on the Pro offer, Unlock Pro is chosen, a Count runs, a Count stops at the free allowance or its size. The line holds no spreadsheet content, color, email address or file name. Google adds to every line in the log its own key for the account, which does not name you, is used only by ColorSum and changes every 30 days. We use it only to count how many accounts reach each step, and never link it to payments, email addresses or other records.
Keeping and deleting
- The error log, usage steps included, is deleted after 30 days.
- Free allowance records have no automatic expiry. A completed request record can be replaced by the next Count without resetting the total used. An uncertain request keeps its reservation; it is not automatically retried or refunded.
- Your settings and free allowance records stay in your Google account’s storage for ColorSum; they contain no cell contents. Uninstalling ColorSum (Extensions > Add-ons > Manage add-ons) stops it; removing it at https://myaccount.google.com/connections also ends its access to your account and its trigger, after which nothing reads them. The formulas’ dates kept in a spreadsheet stay in it and are deleted with it.
- To have your data at Stripe deleted, write to us and we delete your Stripe customer. The records of your payments are kept for five years after the end of the financial year they belong to, as Danish bookkeeping law requires, and deleted after that.
Contact
Questions about this policy or your data: spyridwn.pd@gmail.com.