> ## Documentation Index
> Fetch the complete documentation index at: https://artemis.ai/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Common Problems with Google Sheets

> Troubleshooting common issues with Artemis Sheets in Google Sheets including URL fetch limits and other known problems.

### URL Fetch Limit

Google limits plug-in users to [20,000 data pulls per day](https://developers.google.com/apps-script/guides/services/quotas). 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](/artemis-sheets/metrics/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](https://developers.google.com/apps-script/guides/services/quotas#current_limitations). 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.