http.get to Google Spreadsheet

Well I did find a work around. Its not perfect but it works well enough.
On google script use the following function. It can then be called by a Google script project trigger. You can expand the code to insert the data into the spreadsheet as a database.

function myFunction() {
  var response = UrlFetchApp.fetch("IP Address");
  Logger.log(response.getContentText());
}

I used the "Hello World" server example from the CC3000 page. I then set port forwarding on my router for the espruino server address through port 80. When called the Logger reports "Hello World"!!