Shodan macro for Google Spreadsheets. To use this go to Tools -> Script Editor, then copy/ paste the code. In the spreadsheet you can then do =SHODAN("cisco-ios")

gistfile1.js

/**
 * Search the Shodan database using the given query. Returns the number of matches.
 */
function SHODAN(query) {
  var API_KEY = 'YOUR API KEY';
  
  var url = 'http://www.shodanhq.com/api/count?key=' + API_KEY + '&q=' + query;
  var response = UrlFetchApp.fetch(url);
  var data = Utilities.jsonParse(response.getContentText());
  
  return data.total;
};