Use the Walk Score API To Look Up The Walkability of Any Address

A Walk Score (walkscore.com, a subsidiary of Redfin.com) is an attempt to measure how walkable any given address is. With so many people looking to live a more car-free life, the ability to walk to schools, restaurants, entertainment venues, parks, stores, etc is something that significantly enhances a location’s value. Higher walk scores have also been correlated with higher property values[1] and lower mortgage default risk. 

‍

Provider Website: https://walkscore.com/
‍Provider Enrichment Docs: https://www.walkscore.com/professional/api.php 
‍Endpoint: https://api.walkscore.com/score?format=json&address=1119%8th%20Avenue%20Seattle%20WA%2098101&lat=47.6085&lon=-122.3295&transit=1&bike=1&wsapikey=<YOUR-WSAPIKEY>
‍Token / Registration Required: Yes

‍

How To Enrich A Spreadsheet With Walk Score:

For this example, my data is a simple list of addresses. Let’s use the Walk Score API to retrieve information about the addresses.

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

‍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 address, latitude, and longitude in the input, respectively, and then select our relevant columns for each, clicking +Insert Column Reference. We also need to highlight the “YOUR_KEY” and paste our real key from Walk Score. Then click Next.

‍Step 3. On this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the Walk Score 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.

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

‍Step 5. Once completed, Gigasheet will add new columns based on the Walk Score API. Walk Score has added walkability information for each of the addresses. We now have a metric supplementing the data in our sheet that tells us how walkable the address in question is.