Creating the key is free. Google requires a Cloud billing account with a card on the project, and bills your use of the Maps APIs to that account. Google gives every billing account a free monthly allowance for each API, and most PinPop use stays inside it. What is free and what Google charges beyond that is on Google’s pricing page, which is the only up-to-date source.
A PinPop license covers PinPop only. Google bills its APIs to your own Google Cloud project, never through me.
Which PinPop actions use which API #
| Google API | Used when |
|---|---|
| Maps JavaScript API | A map frame loads: when you insert a map, open a workbook with a map, or restart the add-in. One load per frame; edits, filters, colors, zooming and panning do not load a new map. |
| Geocoding API | An address is looked up: once per new or changed address, with duplicates looked up once, plus one lookup in each key test. Rows with coordinates need no lookup. |
| Maps Static API | A picture is made: Download PNG, Place picture in sheet, the picture saved in the workbook (at most every few minutes, only when the view or the data changed) and the key test. |
Why the usage stays low #
- Coordinates are written into your table, so an unchanged row is never looked up again, not even on another device.
- Recent lookups are also kept on your device for 30 days, so Undo or adding a row back costs nothing.
- Above 500 new lookups, PinPop asks before it starts.
- The free version looks up at most the 50 rows it shows.
- Lists that already have latitude and longitude need no lookups at all.
Stay in control #
- Set a budget alert in Google Cloud, so Google emails you at an amount you choose: budgets and budget alerts.
- Cap the requests per day for each API under APIs & Services > Quotas in the Google Cloud console. PinPop stops at the cap and says so; nothing is charged beyond it.
- Check your usage under Google Maps Platform > Metrics in the console.
Setting up the key step by step: Get a Google Maps API key.
