Enrichments /
No-Code Enrichment with
Use Ziptastic API to Reverse Geocode coordinates from Latitude and Longitude into Readable Locale Information
Sign Up Free

Use Ziptastic to Reverse Geocode Coordinates To Locale Information

The Ziptastic API provides an endpoint that can convert longitude and latitude coordinates into a readable locale, also known as Reverse Geocoding. This frictionless access to accurate geographic data allows you to bring more understanding to your data in Gigasheet.

Create your free Gigasheet account here.

Ziptastic Reverse Geocoding API

Provider Website: https://www.getziptastic.com

Provider Enrichment Docs: https://www.getziptastic.com/documentation

curl https://zip.getziptastic.com/v3/reverse/43.00/-84.17/5000 -H "x-key: 84bf2a17eaad4dd088503f9ccdb2d257ffdc45fb"

Token / Registration Required: Yes

How To Enrich A Spreadsheet With Ziptastic:

For this example, my data looks like this. It is a list of restaurant locations with only Latitude and Longitude coordinates.

Sample data to use Ziptastic API on

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from Ziptastic.

use Ziptastic API for Reverse Geocoding

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight the latitude, “43.00”, in the input, and then select our Latitude column and click +Insert Column Reference. Repeat the process for Longitude, replacing “-84.17”. We also need to highlight the “123examplekey456” and paste our real key from Ziptastic. Then click Next.

Customizing Ziptastic API for reverse geocoding

Ready to use Ziptastic API for Reverse Geocoding

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the Ziptastic response. At this point select the fields you want to be inserted into your sheet. We recommend hitting Select All since you can easily delete columns in Gigasheet.

Results from Ziptastic 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 use Ziptastic 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 Ziptastic Reverse Geocoding API.

Ziptastic has added the City, County, State, Country and other locale information for each set of coordinates. 

use Ziptastic API with Gigasheet

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