Enrichments /
Open Brewery DB
No-Code Enrichment with
Open Brewery DB
Use Open Brewery DB API To Find the Closest Breweries with the List Breweries API
Sign Up Free

Use Open Brewery DB API To Find the Closest Breweries

The Open Brewery DB is a free dataset containing information on breweries, cideries, brewpubs, and bottleshops. Better yet? The Open Brewery DB API provides access to all of the data, which means it can be used to enrich a sheet in Gigasheet. The Open Brewery DB’s API List Breweries provides an endpoint that returns the closest brewery to a latitude and longitude you supply.

Open Brewery DB API

Provider Website: https://www.openbrewerydb.org/
Provider Enrichment Docs: https://www.openbrewerydb.org/documentation
Endpoint: curl https://api.openbrewerydb.org/v1/breweries?by_dist=38.8977,77.0365&per_page=3
Token / Registration Required:

How To Enrich A Spreadsheet With OpenBreweryDB:

For this example, my data is a list of latitudes and longitudes.

Data to enrich with the Open Brewery DB API

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

cURL request for the Open Brewery DB API

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, “38.8977”, in the input, and then select our Latitude column and click +Insert Column Reference. We need to to the same with “77.0365” for our Longitude column.

Customizing the request to the Open Brewery DB API
Ready to call the Open Brewery DB API

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the OpenBreweryDB response. At this point select the fields you want to be inserted into your sheet. For this example I only selected the name, latitude, and longitude of the brewery to be able to see where it is.

Sample response from the Open Brewery DB API

Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to start 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 execution of the Open Brewery DB API

Step 5. Once completed, Gigasheet will send a completion toast and refresh the page. The result will show generation of new columns. OpenBreweryDB has added the Latitude, Longitude and brewery name for each coordinate of interest. 

Open Brewery DB API data added to Gigasheet
The enriched sheet using Open Brewery DB
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