Count the different links in your sheet. That is how many calls it uses a day. Google reloading a formula every hour does not add to it. New here? Create a free account and you get a Sheets key and starting credit to try this.
The rule
A link is the address with your key. The first time a link loads on a day it costs what that call normally costs. Every other load of the same link that day is free. Days change at midnight UTC.
Count your sheet
- List the formulas Find every
IMPORTDATAformula in the sheet that points at Narwhal. - Drop the repeats Two formulas with the same address and the same key are one link. Count them once.
- Read the number The links left are the calls the sheet uses on a day it is opened.
Examples
| Sheet | Different links | Calls a day | Calls in a 30-day month |
|---|---|---|---|
| Holidays for one country | 1 | 1 | 30 |
| CPI for 5 countries | 5 | 5 | 150 |
| A dashboard with 12 tables | 12 | 12 | 360 |
| The same dashboard, opened by 20 colleagues | 12 | 12 | 360 |
A sheet nobody opens on a day makes no calls that day.
What makes a new link
- A different country, date, currency or any other part of the address.
- A different Sheets key.
- The same parameters in a different order do not make a new link.
A formula that builds dates from TODAY() makes a new link each time the dates change. A "this week" formula changes once a week, so it still costs once a day.
Keep the count low
- Ask for a list in one link where the route takes one.
currencies=EUR,IDR,JPYis one link; three formulas are three. - Load history once with a wide
start, then use sheet formulas on it. Do not load one link per month. - Point other tabs at the loaded table. Do not paste the same formula with small changes.
See what a sheet used
Open Requests in your dashboard. Each call is listed there with the start of the key that made it.
What does one call cost?
The same as the JSON call for that route. See pricing.
What happens when credit runs out?
The cell shows "Narwhal: out of credit. Add credit at https://narwhalapi.com/dashboard and refresh this sheet." Nothing is charged past zero. A link that already loaded that day keeps loading for the rest of the day.
Published .