queryUserDevices.gs

// result is an array of objects if header row is specified, otherwise it is an array of arrays
//var result = Utils.gvizQuery(
//    "[YOUR_SPREADSHEET_ID]", 
//    "[YOUR_QUERY_STRING]", 
//    [SHEET_ID_IF_NEEDED], // can be a number (the sheetId), or the name of the sheet; if not needed, but headers are, pass in undefined
//    [RANGE], // specify range, ex: `A2:O`
//    [HEADER_ROW_INDEX_IF_NEEDED] // always a number
//);

function queryUserDevices(uname) {
  var userinfoin = uname;
  if (!userinfoin.trim()) {{var userinfo = "No user"};}
  else {{var userinfo = userinfoin}
  var qUser = "select B,A,C,D,E where C contains '" + userinfo + "'";
  var result = Utils.gvizQuery(
          "Replace with fileID of your CB_Activity spreadsheet",
    qUser,
    "Devices",
    "A2:E"
);
        } 
  Logger.log([userinfo, result]);
  return [result];
}