Google Sheets add-on
Geloky for Google Sheets
Geocode addresses, find the address of a point and measure distances without leaving your spreadsheet: with three formulas for a few cells, or the Geocode panel for a whole column. Every lookup is paid from the same API wallet as the Geloky API.
| Formulas | =GELOKY, =GELOKY_REVERSE, =GELOKY_DISTANCE |
|---|---|
| Panel | Extensions › Geloky › Geocode, for a whole column at once |
| Price | $0.001 per lookup, found or not, from your Geloky API wallet |
| Works in | Google Sheets on a computer. On a phone, the Sheets app shows the results but doesn’t open add-ons. |
| Countries | Addresses in every country |
B2 350 5th Ave, New York, NY 10118 C2 =GELOKY(B2)
C2 40.748377 D2 -73.984854 E2 350 5th Ave, New York, New York, 10118
Install and connect
- Install Geloky from the Google Workspace Marketplace. Google asks you to allow three things: see and edit the spreadsheets you use it in, show its panel, and connect to geloky.com (see Permissions and privacy).
- Create a free Geloky account if you don’t have one, and top up the API wallet on the API tab of your dashboard. Top-ups start at $5; your first one comes with $10 extra.
- Copy your API key from the same tab.
- The Geloky panel opens by itself after installing; later, open it from Extensions › Geloky. Paste the key and press Save key. Geloky checks it and shows the Geocode tab.
The key is kept with your Google account in the add-on, never in the spreadsheet, and works in every spreadsheet you open.
Extensions › Geloky › Geocode a whole column at once Extensions › Geloky › Formulas a short formula guide Extensions › Geloky › Account your key and wallet
Prices and caching
- $0.001 per lookup: an address, a point or a pair of points, found or not. Errors like a wrong key or an empty wallet are never charged.
- Kept for 6 hours: results are kept in the spreadsheet’s cache, so recalculating, sorting or copying formulas doesn’t charge again.
- Repeats are free: an address that appears twice in a column or a formula is looked up and paid once.
- Values that stay: the panel writes plain values, which never recalculate. To keep a formula’s results for good, copy the cells and paste values only.
The wallet is shared with the Geloky API and the MCP server for AI assistants. Set an email reminder for a low balance on the API tab of your dashboard.
500 addresses, 13 of them repeated = 487 lookups × $0.001 = $0.49
Formulas
Three formulas
Type them like any other formula. Each fills the cells to its right (and below, for a range), so leave those cells empty; otherwise Sheets shows #REF! and “Array result was not expanded”.
GELOKY
Finds the latitude, longitude and matched address of an address, in three cells side by side.
$0.001 per new address| Argument | What it does |
|---|---|
| address required | An address in a cell (B2) or in quotes. A column (B2:B100) looks up every row at once, one row of results each. Cells side by side (B2:D2: street, city, ZIP) are joined with commas into one address. Empty rows give empty results. |
| again optional | Any value. Change it to run the formula again: see Running a formula again. |
What it returns
| Cell | Holds |
|---|---|
| 1st | Latitude, a number with 6 decimals |
| 2nd | Longitude, a number with 6 decimals |
| 3rd | The address Geloky matched, or No match (the first two cells stay empty) |
- Up to 100 new addresses per formula. For a longer column use the Geocode panel.
- Street, city, postal code and country give the best match. Leave out business names and unit numbers.
=GELOKY(B2) =GELOKY(B2:B100) =GELOKY(B2:D2) =GELOKY("1 Centre St, New York, NY")
C D E 40.748377 -73.984854 350 5th Ave, … 40.71298 -74.003758 1 Centre St, … No match
GELOKY_REVERSE
Finds the nearest address to a latitude and longitude.
$0.001 per new point| Argument | What it does |
|---|---|
| latitude required | A latitude from −90 to 90 (C2 or 40.74838), a column of them (C2:C100), a two-column range of latitude and longitude (C2:D100), or text with both, like "40.74838, -73.98485". |
| longitude optional | A longitude from −180 to 180, or a column of them as long as the latitude column. Leave it out when the first argument holds both. |
| again optional | Any value; change it to run the formula again. When the first argument holds both coordinates, the second argument is this value. |
What it returns
One cell with the address, or one per row for a range. A row that isn’t a pair of coordinates says Not coordinates; a point with no address near it says No match. Up to 100 new points per formula.
=GELOKY_REVERSE(C2, D2) =GELOKY_REVERSE(40.74838, -73.98485) =GELOKY_REVERSE(C2:D100) =GELOKY_REVERSE("40.71297, -74.00412")
350 5th Ave, New York, NY, 10118, USA 1 Centre St, New York, NY, 10007, USA
GELOKY_DISTANCE
Measures the road distance and travel time between two points, in two cells side by side.
$0.001 per new pair of points| Argument | What it does |
|---|---|
| origin required | The starting point: its latitude and longitude in two cells side by side (C2:D2), or one cell or text in quotes like "40.7447, -73.9485". A range of rows (C2:D50) measures row by row. |
| destination required | The end point, in the same forms. A single point on either side is used for every row of the other: one depot and a column of stops, for example. |
| units optional · default "mi" | "mi" for miles or "km" for kilometers ("miles" and "kilometers" work too). |
| way optional · default "car" | "car", "truck" or "walk". |
| again optional | Any value; change it to run the formula again. A number in the place of units or way counts as this value. |
What it returns
| Cell | Holds |
|---|---|
| 1st | The distance, in the units asked for |
| 2nd | The travel time in minutes, or Straight line when there is no road between the points and the distance is measured as the crow flies |
A pair that can’t be measured at all says No route, and a row that isn’t a pair of coordinates says Not coordinates. Up to 50 new pairs per formula.
=GELOKY_DISTANCE(C2:D2, F2:G2) =GELOKY_DISTANCE(C2:D2, F2:G2, "km", "truck") =GELOKY_DISTANCE(A2:B2, C2:D20)
350 5th Ave → 1 Centre St, car, mi 2.926 22.28 The same by truck, km 4.746 24 New York to London 3457.45 Straight line
Running a formula again
Sheets keeps the answer of every formula, errors included, until one of its inputs changes; even reloading the spreadsheet doesn’t ask again. So a formula that showed “Add your Geloky API key” keeps saying it after you add the key.
To run it again, add one more value at the end, like , 1. Next time use , 2, and so on: any change makes Sheets ask again. Results already looked up in the last 6 hours come from the cache and cost nothing.
=GELOKY(B2, 1) =GELOKY_REVERSE(C2, D2, 1) =GELOKY_REVERSE(C2:D100, 1) =GELOKY_DISTANCE(C2:D2, F2:G2, 1)
Formula errors
A formula that can’t answer shows #ERROR!; point at the cell to read why (Sheets adds the script’s line number after it). A wrong key or an empty wallet costs nothing, and lookups that finished before an error are kept for 6 hours, so running the formula again doesn’t pay for them twice.
| Message | What it means |
|---|---|
| Add your Geloky API key in Extensions › Geloky › Account, then add , 1 at the end of this formula to run it again. | No key is saved for this spreadsheet’s owner. |
| This Geloky API key isn’t valid. … | The key was mistyped or replaced on your dashboard. Paste the current one in Account. |
| Your Geloky API wallet is empty. Top up at geloky.com/dashboard/tab/api, … | Top up, then run the formula again. |
| Up to 100 new addresses per formula. … | Split the range, or use the Geocode panel. Points have the same limit; distance formulas take 50 pairs. |
| GELOKY_REVERSE needs a latitude (−90 to 90) and a longitude (−180 to 180). | The cell isn’t a number in range, or the text isn’t “latitude, longitude”. |
| GELOKY_DISTANCE needs two points, … | A point isn’t two cells side by side or “latitude, longitude” text. |
| Both ranges need the same number of rows. | The origin and destination ranges, or the latitude and longitude columns, differ in length. |
| Units must be "mi" or "km". The way must be "car", "truck" or "walk". | A misspelt optional argument. |
| Geloky didn’t answer. … | A network problem. Run the formula again in a minute. |
Geocode panel
A whole column at once
Extensions › Geloky › Geocode looks up a whole column and writes plain values into new columns next to it, about a minute for 500 rows. Keep the panel open while it runs.
Find lat, long
Addresses to latitude and longitude.
- Press Find lat, long at the top of the panel.
- Click a cell in the address column, or select the column. For street, city and ZIP in separate columns, select them side by side (up to 6); they’re joined with commas.
- Check the panel: the range, the first address, and whether the first row is a header (tick or untick it).
- Press Geocode. The button says how many lookups it will make and what they cost.
| What you select | What Geloky reads |
|---|---|
| One cell, or whole columns | The column from the top down to the last row with data |
| A range, like B2:B200 | Exactly those rows |
| Several columns side by side | Each row’s cells, joined into one address |
- Latitude, Longitude and Matched address go into three new columns inserted after the selection, so nothing in your sheet is overwritten. With a header row they get those names.
- Running it again on the same column (with a header row) reuses those columns and looks up only the rows without a result, including rows that say “No match”, so a corrected address is looked up again.
- A repeated address is looked up once; unchanged rows from the last 6 hours come from the cache.
- Stop keeps the rows already done; Continue picks up at the first open row.
B Address 350 5th Ave, New York, NY 10118 1 Centre St, New York, NY 10007
C D E Latitude Longitude Matched address 40.748377 -73.984854 350 5th Ave, … 40.71298 -74.003758 1 Centre St, …
Find addresses
Latitude and longitude to the nearest address.
- Press Find addresses at the top of the panel.
- Select the latitude and longitude columns side by side, or one column with “latitude, longitude” in each cell. If the headers say longitude first (lon, lng, long, x), Geloky reads them that way round.
- Press Find addresses at the bottom.
The nearest address goes into a new column, Nearest address, inserted after the coordinates. Rows that aren’t coordinates say “Not coordinates”.
40.74838 -73.98485 two columns "40.74838, -73.98485" one column -73.98485 40.74838 headers Lon, Lat
Panel messages
| Message | What to do |
|---|---|
| Select up to 6 columns side by side. | Select only the address columns, 6 at most. For coordinates, 2 at most. |
| Columns C to E already hold Geloky results. Only the 40 rows without one are looked up. | Nothing: rows with a result stay as they are. |
| Every row in B2:B500 already has a result. | Nothing is left to look up in this selection. |
| Your API wallet is empty. | Top up; the panel checks again when you come back to it. |
| Your wallet covers about 120 of these 487 addresses. | Geloky stops when the wallet runs out and keeps the rows done by then. |
| 12,000 lookups take about 24 minutes here, with this panel open. | For very long sheets, upload the file to batch geocoding instead: Geloky’s servers do the work and you can close the page. |
| The wallet ran out after 120 addresses. | Top up, then press Continue: only the rows left are looked up. |
| Geloky didn’t answer. | Press Continue to try the rest again. Rows already done are kept. |
| This Geloky API key isn’t valid any more. | Paste the current key in Account, then run it again. Rows already done are kept. |
Good to know
Keys, limits and privacy
What the add-on keeps, what it may do, and how far it goes.
Your key and wallet
- Account (Extensions › Geloky › Account) shows the end of your key, the wallet and about how many lookups it pays for, with buttons to top up, change or remove the key.
- The key belongs to your Google account in this add-on: once saved, it works in every spreadsheet you open.
- Shared spreadsheets: Google runs formulas with the spreadsheet owner’s settings, so formulas use the owner’s key, paid from the owner’s wallet. The panel always uses your own key.
- If your key leaks, make a new one on the API tab of your dashboard and paste it in Account; the old one stops working at once.
Limits
| What | Limit |
|---|---|
| New addresses or points per formula | 100 (more → the Geocode panel) |
| New pairs per GELOKY_DISTANCE formula | 50 |
| Columns joined into one address | 6 |
| Results kept | 6 hours, per spreadsheet |
| Panel speed | About 500 rows a minute |
| Time a formula may run | 30 seconds, Google’s limit for custom functions |
| Google’s URL Fetch quota | 20,000 calls a day for a Google account, 100,000 with Google Workspace. The panel sends about 25 addresses per call. |
Permissions and privacy
| Google asks to | Because |
|---|---|
| See and edit the spreadsheets you use it in | To read the cells you choose and write the results. It works only in the open spreadsheet and reads no other files. |
| Show its panel | The Geocode, Formulas and Account panel. |
| Connect to an external service | To send the addresses or coordinates to geloky.com, the only place it connects to. |
The add-on sends Geloky only the cells you select or give to its formulas. Our privacy policy says how we handle them.
Stuck, or missing something? hello@geloky.com answers within a day.
API pricing