Common Problems w/ Google Sheets
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:
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 least400ms
have passed.
Recommendations:
Use our Excel plug-in whenever possible - neither of these performance limitations are imposed.
If not possible to use Excel, use
ARTRANGE
instead ofART
- this will reduce the burden of the listed performance limitations.Share sheets in View Only mode.
Last updated