On Google Spreadsheet, how do you call the CIty, Country of an IP?
After some digging I've figured out how to do this.
Copy the
import_json_appsscript.js
script on https://gist.github.com/chrislkeller/5719258. This will be the script that will create theImportJSON()
function to a Google spreadsheetGo to Google spreadsheet, on the menu bar got to Tools > Script Editor
Copy paste
import_json_appsscript.js
into the Script Editor and save it, Double check that you can see theImportJSON()
function on the Select function drop down menu.On the Spreadsheet use function =ImportJSON(url, query, options), for example
=ImportJSON("http://freegeoip.net/json/75.148.30.137", "/city", "noHeaders")
to retrieveBaltimore
from the FreeGeoIP call.
Hope that helps, it certainly answers my question.