Geocode with Mapzen search and Google Spreadsheets

How to set up a quick geocoding system on google spreadsheets.

1. Create a new spreadsheet
2. Open the Scripts editor and paste the script attached
3. Use on your spreadsheet this new formula

   =searchMapzen(place_cell,mapzen_api_key)

So you need to register at Mapzen developers site and get your own search API Key. Take this as an exercise, you can interact with the search API in many ways.

Enjoy!