How many calls a sheet uses

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

  1. List the formulas Find every IMPORTDATA formula in the sheet that points at Narwhal.
  2. Drop the repeats Two formulas with the same address and the same key are one link. Count them once.
  3. Read the number The links left are the calls the sheet uses on a day it is opened.

Examples

SheetDifferent linksCalls a dayCalls in a 30-day month
Holidays for one country1130
CPI for 5 countries55150
A dashboard with 12 tables1212360
The same dashboard, opened by 20 colleagues1212360

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,JPY is 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 .

Next steps