Enrichments /
Google Maps
No-Code Enrichment with
Google Maps
No code elevation data at big data scale, using Google Maps Elevation API and hte Gigasheet Custom Enrichment.
Sign Up Free

Google Maps API for Elevation

The Google Maps Platform contains a wealth of location information that allows you access to real world data and insights with maps, routes and places APIs. It can all be accessed via API and then used to create real-time experiences for your users. In this case, we are going to use the API responses to enrich our data.

This assumes you have set up a Google Cloud project (instructions here) and enabled billing. Once signed up, you will receive an API key. 

Google Maps Elevation API docs

Provider Website: https://developers.google.com/maps

Provider Enrichment Docs: https://developers.google.com/maps/documentation/elevation/overview

Endpoint: https://maps.googleapis.com/maps/api/elevation/json?locations=39.7391536%2C-104.9847034&key=YOUR_API_KEY

Token / Registration Required: Yes

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from the Google Maps Elevation API docs. Be sure to replace "YOUR_API_KEY" with your token from the Google Maps Platform portal.

Paste the Google Maps Elevation API call into Gigasheet

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the latitude and longitude. In this case, we highlight the latitude, “39.7391536”, in the input, and then select our latitude column and click +Insert Column Reference. We then repeat the same thing for longitude, replacing “39.7391536”.” In case you were wondering, “%2C” is an escape character for a comma, so we leave that untouched. Then click Next.

Customizing the Google Maps Elevation API request

The fully customized Google Maps Elevation API request

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the Google Maps Elevation API response. At this point select the fields you want to be inserted into your sheet. We recommend hitting Select All because you can always delete columns later.

 

Preview of the first 3 responses from the Google Maps Elevation API

Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet. 

Confirm running the Google Maps Elevation API

Step 5. Once completed, Gigasheet will send a completion toast and refresh the page. The result will show generation of new columns based on the Google Maps Platform Elevation API. 

The Google Maps Elevation API data in Gigasheet

Here is the elevation of each of the input coordinates.

Elevation data from the Google Maps Elevation API

Try it Out

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free Forever