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.

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: No

‍

How To Enrich A Spreadsheet With OpenBreweryDB:

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

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

‍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.

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.

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. 

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.