Geo coordinates generation

What is Geo Coordinates?

A Geo coordinates system is a coordinate system that enables every location on Earth to be specified by a set of numbers, letters or symbols.

Why Geo Coordinates need to be generated?

Geo coordinates contains latitude and longitude. Google Maps require Geo coordinates to plot the map.

If your Google sheet records have address fields, but there is no Geo coordinates for those records, Google Map cannot directly plot your records on the map. So, Map my sheet will generate Geo coordinates before plotting your data on Google Map.

How to Manage Geo Coordinates Generation

Geo coordinates generation need to be managed well to present Google Sheet data on the Google Map.

Is it a big deal to generate Geo coordinates?

Not really, but you need to be cautious of the following

  • Google Maps has a quota limitation of per second and per day access to the Geo Coordinates generation API

  • Also, there is execution time limitation.

We need to manage these well to work with Google Maps platform smoothly

While generating Geo Coordinates you may get following problems,

  • Exceeded Execution Time. - 6 minutes limit enforced by Google

  • Service invoked too many times for one day: Geo code. - Refer Google's daily quota for the details

Don't worry, every problem has solution.

Problem 1 : Exceeded Execution Time.

Solution : Just click save button and and you will get a popup with actual information about total records and out of that how many records has Geo coordinates, then click generate again.

Problem 2 : Service invoked too many times for one day: Geo code.

It has 2 solutions.

  • You can wait for one day and try it the next day

  • Use another account to generate Geo coordinates.

If you use another account you have to give Google sheet access to that new account and generate Geo coordinates. After that go back to your initial account and view your map.