Enrichments /
Walk Score
No-Code Enrichment with
Walk Score
How To Use the Walk Score API to Look Up The Walkability Score of Addresses in Gigasheet
Sign Up Free

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. 

Walk Score API Docs

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.

Gigasheet Sheet to enrich using the Walk Score API

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

Paste the Walk Score API request into Gigasheet

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.

Customizing the request to the Walk Score API
Ready to execute the Walk Score API
Repeat the process to customize the Walk Score API

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.

Preview of the response from the Walk Score 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 execution of the Walk Score API

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. 

Gigasheet enriched with data from the Walk Score 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