googlevisionml

googlevisionml.gs

function onChange(e) {
  var sSht = e.source;
	var sht = sSht.getActiveSheet();
	var shtName = sht.getName();
  var activeRng = sht.getActiveRange();
		var activeRow = activeRng.getRow();
  var image = sht.getRange(activeRow,4).getValue();
  var folder = DriveApp.getFolderById("APPSHEET FOLDER ID WHERE IMAGES WERE UPLOADED");
    var blob = folder.getFilesByName(image.split("/")[1]).next().getBlob();
    
      var mlRequest = {payload: {
    image: {
      imageBytes: Utilities.base64Encode(blob.getBytes())
    }
  }
}
    var mlUrl = "https://YOURAPIGEEORGNAME.apigee.net/ml-use?apikey=YOURAPIGEEAPIKEY";
      var responseML = UrlFetchApp.fetch(mlUrl, {
            method : 'POST',
            contentType: 'application/json',
            payload : JSON.stringify(mlRequest)
        });
    var mlPayload = responseML.getContentText();
  var pparsed = JSON.parse(mlPayload);
  var result = pparsed.payload[0].displayName;
sht.getRange(activeRow,5).setValue(result);
}