Why did you get disabled?

👉 What to do if you get an email like this:

"We have detected a large amount of error requests in your account, and, as a precautionary measure, have disabled your account. If you believe this to be an error, please contact
support@cryptosheets.com for assistance. Sincerely, The Cryptosheets team"

  1. Don't worry - most often it's an accident but it's often something small like the syntax of a formula that just needs adjusting
  2. Read below for more information actions to take

😦 Here are some of the potential reasons:

  • You went over your allowed quota limits for your subscription tier
  • You were receiving a large amount of errors as a percentage (%) relative to your overall quota

    Example scenarios that could trigger auto disable:
    1) You have 1,000 requests per month and 200 errors or 20% of your requests are errors = disabled
    2) You have very little request activity and suddenly have an increase of more than 3-500% = disabled
    3) You suddenly start sending hundreds or thousands of requests per second = disabled
    4) You are continuously sending multiple requests per second but your free forever subscription has a maximum request concurrency of 1 per second = disabled
    5) You are automatically backing up your Google Sheet (to Google Drive) on a regular basis so although your sheet wasn't open in the browser, it could have still been refreshing the data in the background every time Google was opening it to save the backup copies. Once you uninstall the app from the backup sheet, everything should return to behaving as expected.

❓ What happened?

  • When you combine API data with the power of spreadsheet formulas sometimes formulas can 'go wrong' or accidentally trigger.
  • Sometimes having multiple linked sheets, workbooks or tabs can set off multiple cascading triggers you may not realize
  • You may have lost track of your quota usage and simply surpassed your limit

    Example causes that could trigger auto disable:
    1) You have multiple Cryptosheets functions that are directly or indirectly linked to cells with volatile functions like =NOW(), =TODAY() =BNOW()
    2) You are repeatedly sending incorrect symbol, or exchange asset pairs (which result in errors)
    3) You are repeatedly using incorrect parameters with custom functions (ie using time or exchange for =CS.EXRATE when those aren't valid parameters)
    4) You have existing VBA macros, custom Google App Scripts or similar programmatic triggers setup
    5) You are using a custom function that that your subscription tier doesn't have access to (ie =CS.TIME)

➡️ Next Steps:

  1. Make sure you understand what caused the auto disable first
    --> change or adjust any formulas that need it or you will simply be disabled again
  2. Explore our extensive help center and docs portal resources for more information
  3. You are responsible for tracking your own quota usage 👉 you can do that anytime and in real time from within the add-in side panel
    (tutorial here: https://intercom.help/cryptosheets/en/articles/3712846-see-your-subscription-usage-in-real-time)
  4. Upgrade your subscription to raise your quota limit and avoid being disabled or wait until the monthly period has rolled over
  5. You can upgrade from the settings > billing section inside the add-in
    (tutorial here: https://intercom.help/cryptosheets/en/articles/1769408-how-can-i-upgrade-my-subscription-plan )
  6. You can also upgrade from the webapp or directly from the website here https://cryptosheets.com/pricing
  7. Contact us via email or chat support

Additional Resources:


Cryptosheets Docs Portal

Providers 👉 https://docs.cryptosheets.com/providers
Endpoints 👉 https://docs.cryptosheets.com/providers/cryptocompare (or any provider)
Functions 👉 https://docs.cryptosheets.com/functions
Templates 👉 https://docs.cryptosheets.com/templates
Resources 👉 https://docs.cryptosheets.com/resources

Exchanges (core functions) 👉 https://docs.cryptosheets.com/metadata/exchanges
Assets (core functions) 👉 https://docs.cryptosheets.com/metadata/assets

Help Center 👉 https://intercom.help/cryptosheets/en/

Cryptosheets - Resource List

Website: https://cryptosheets.com
Web App: https://app.cryptosheets.com
Docs Portal: https://docs.cryptosheets.com
Help Center: https://intercom.help/cryptosheets/en/

Microsoft Excel: https://appsource.microsoft.com/en-us/product/office/WA104381695
GoogleSheets: https://gsuite.google.com/marketplace/app/cryptosheets/898843532532

Medium: https://medium.com/cryptosheets
Twitter: https://twitter.com/Cryptosheets_RT, https://twitter.com/1k_experiment
YouTube: https://www.youtube.com/channel/UCReKkrBSlgKgNJlWHLASiPQ

TAGS: disabled, enable, exhaust, error, subscription, quota, exhausted, error, disabled, excessive, usage, detected a large amount of error requests in your account, precautionary measure, have disabled your account, #NAME, subscription level, billing, account, queries, errors, deleted, destroyed, upgrade, downgrade, support@cryptosheets.com, help, wtf, error, timeout, support

Did this answer your question?