​
URL Fetch Limit

Google limits plug-in users to 20,000 data pulls per day. If you run into this limit, you will observe the following error: Service invoked too many times for one day: urlfetch.

Each ART and ARTRANGE call counts as 1 data pull, which is why we recommend using ARTRANGE whenever pulling large amounts of historical data. Syntax for ARTRANGE is listed in:

Syntax and Formulas

​
Sharing Sheets

When sharing sheets, be advised that the URL Fetch Limit counts towards the owner of the sheet. Therefore if you share a sheet, it is recommended you share it in View Only mode in order to reduce data pulls counted towards yourself.

Additionally, the credentials of a sheet are always read from the owner of the sheet. Therefore, if the owner of the sheet churns from their Artemis subscription, the sheet will no longer be functional until the viewer of the sheet makes a copy on their own account and thereby becomes the owner.

​
Performance

Google Sheets has a few performance limitations that ultimately reduce the quality of offering we can provide. Namely,

  • Only 30 functions can run simultaneously. If more than 30 functions are requested, the remaining functions are queued and will wait until up-stream functions are finished.
  • The functions take >400ms to start running. This means for each function, we do not have control of execution until at least 400ms have passed.

Recommendations:

  1. Use our Excel plug-in whenever possible - neither of these performance limitations are imposed.
  2. If not possible to use Excel, use ARTRANGE instead of ART - this will reduce the burden of the listed performance limitations.
  3. Share sheets in View Only mode.