NEW Geloky now works inside Claude, ChatGPT and Cursor. See how Geloky inside Claude & ChatGPT →

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
PanelExtensions › Geloky › Geocode, for a whole column at once
Price$0.001 per lookup, found or not, from your Geloky API wallet
Works inGoogle Sheets on a computer. On a phone, the Sheets app shows the results but doesn’t open add-ons.
CountriesAddresses in every country
Your first formula
B2  350 5th Ave, New York, NY 10118
C2  =GELOKY(B2)
Fills three cells
C2  40.748377
D2  -73.984854
E2  350 5th Ave, New York,
    New York, 10118

Install and connect

  1. 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).
  2. 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.
  3. Copy your API key from the same tab.
  4. 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.

Where everything is
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.

What a column costs
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

=GELOKY(address, [again])

Finds the latitude, longitude and matched address of an address, in three cells side by side.

$0.001 per new address
ArgumentWhat 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

CellHolds
1stLatitude, a number with 6 decimals
2ndLongitude, a number with 6 decimals
3rdThe 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.
Formulas
=GELOKY(B2)
=GELOKY(B2:B100)
=GELOKY(B2:D2)
=GELOKY("1 Centre St, New York, NY")
=GELOKY(B2:B4) in C2
C          D           E
40.748377  -73.984854  350 5th Ave, …
40.71298   -74.003758  1 Centre St, …
                       No match

GELOKY_REVERSE

=GELOKY_REVERSE(latitude, [longitude], [again])

Finds the nearest address to a latitude and longitude.

$0.001 per new point
ArgumentWhat 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.

Formulas
=GELOKY_REVERSE(C2, D2)
=GELOKY_REVERSE(40.74838, -73.98485)
=GELOKY_REVERSE(C2:D100)
=GELOKY_REVERSE("40.71297, -74.00412")
=GELOKY_REVERSE(C2:D3)
350 5th Ave, New York, NY, 10118, USA
1 Centre St, New York, NY, 10007, USA

GELOKY_DISTANCE

=GELOKY_DISTANCE(origin, destination, [units], [way], [again])

Measures the road distance and travel time between two points, in two cells side by side.

$0.001 per new pair of points
ArgumentWhat 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

CellHolds
1stThe distance, in the units asked for
2ndThe 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.

Formulas
=GELOKY_DISTANCE(C2:D2, F2:G2)
=GELOKY_DISTANCE(C2:D2, F2:G2,
  "km", "truck")
=GELOKY_DISTANCE(A2:B2, C2:D20)
Results
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.

Run again
=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.

MessageWhat 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.

  1. Press Find lat, long at the top of the panel.
  2. 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.
  3. Check the panel: the range, the first address, and whether the first row is a header (tick or untick it).
  4. Press Geocode. The button says how many lookups it will make and what they cost.
What you selectWhat Geloky reads
One cell, or whole columnsThe column from the top down to the last row with data
A range, like B2:B200Exactly those rows
Several columns side by sideEach 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.
Before
B
Address
350 5th Ave, New York, NY 10118
1 Centre St, New York, NY 10007
After: three new columns
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.

  1. Press Find addresses at the top of the panel.
  2. 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.
  3. 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”.

Accepted coordinates
40.74838   -73.98485   two columns
"40.74838, -73.98485"  one column
-73.98485  40.74838    headers Lon, Lat

Panel messages

MessageWhat 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

WhatLimit
New addresses or points per formula100 (more → the Geocode panel)
New pairs per GELOKY_DISTANCE formula50
Columns joined into one address6
Results kept6 hours, per spreadsheet
Panel speedAbout 500 rows a minute
Time a formula may run30 seconds, Google’s limit for custom functions
Google’s URL Fetch quota20,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 toBecause
See and edit the spreadsheets you use it inTo read the cells you choose and write the results. It works only in the open spreadsheet and reads no other files.
Show its panelThe Geocode, Formulas and Account panel.
Connect to an external serviceTo 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