Geocoding and reverse geocoding with Google Maps APIs

Geocoding is to convert an address into a pair of coordinates.
Reverse geocoding is to convert coordinates into an address.
If you want to geocode or reverse geocode locations, dashdash can help you!

It takes only 3 simple steps:

  1. Grab a key
  2. Send the request for geocoding with GET
  3. Parse the request with PARSE
    (4. Then reverse geocode)

Here’s how the app looks like:

Grab a key

Follow our documentation here to get your Google API key.

Send the request

A2: “Empire State Building, NYC” (an address)

A2 is the address you’re looking for. B2 is the request itself, clean as a whistle.

Parse the request

C2: =PARSE(B2,"lat")
D2: =PARSE(B2,"lng")

C2 is that latitude and D2 is the longitude.

Lets reverse geocode now!


E2 now contains the nicely formatted address that google has on its database.

Know more

About Google Maps Web Service API

  • Rate limiting: 50 requests per second.
  • Free quota per account (key): 2500 free requests per day.

You can do the same without our integration, i.e. by directly calling the Google Geocoding API with our GET function. In this case, you need to store your API key, e.g. in H1:

B2: =GET(""&H1&"&address="&A2)
C2: =PARSE(B2,"results[0]")
D2: =PARSE(B2,"results[0].geometry.location.lng")
E2: =PARSE(GET(""&H1&"&latlng="&C2&","&D2),"results[0].formatted_address")

Hello! The documentation link to google api on this page is broken …

1 Like

Hey @Sommer_GsbR :wave:t4: thanks for reaching out and letting know. Looks like the article was accidentally deleted. I’ve restored it now and you should be able to view it.

To avoid the hassle of managing the API keys from your end, you could make use of our Maps and Places instant integration so all your focus goes into building those spreadsheets :innocent:

Should there be anything else we can help with, please don’t hesitate to write back.