function writeRawResultsToImportSheet(queryData,writeSheet,columnNames) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
 
  // Grab a handle to the existing spreadsheet holding the SalesForce import data
  var sheet = ss.getSheetByName(writeSheet)
  var contentRange = sheet.getRange(1,1,sheet.getMaxRows(),columnNames.length);
  contentRange.clearContent();
 
  // Set the header titles for the columns
  var headersRange = sheet.getRange(1, 1, 1, columnNames.length);
  headersRange.setValues([columnNames]);
  headersRange.setFontWeight("bold");
 
  // Calls the setRowsData function to actually populate the sheet
  setRowsData(sheet, queryData);
}
 
 
// setRowsData fills in one row of data per object defined in the objects Array.
// For every Column, it checks if data objects define a value for it.
// Arguments:
//   - sheet: the Sheet Object where the data will be written
//   - objects: an Array of Objects, each of which contains data for a row
//   - optHeadersRange: a Range of cells where the column headers are defined. This
//     defaults to the entire first row in sheet.
//   - optFirstDataRowIndex: index of the first row where data should be written. This
//     defaults to the row immediately below the headers.
function setRowsData(sheet, objects, optHeadersRange, optFirstDataRowIndex) {
  var headersRange = optHeadersRange || sheet.getRange(1, 1, 1, objects[0].length);
  var firstDataRowIndex = optFirstDataRowIndex || headersRange.getRowIndex() + 1;
  var headers = headersRange.getValues()[0];
 
  var destinationRange = sheet.getRange(firstDataRowIndex, headersRange.getColumnIndex(),
                                        objects.length, headers.length);
 
  destinationRange.setValues(objects);
 
}

ZnVuY3Rpb24gd3JpdGVSYXdSZXN1bHRzVG9JbXBvcnRTaGVldChxdWVyeURhdGEsd3JpdGVTaGVldCxjb2x1bW5OYW1lcykgewogIHZhciBzcyA9IFNwcmVhZHNoZWV0QXBwLmdldEFjdGl2ZVNwcmVhZHNoZWV0KCk7CiAgICAKICAvLyBHcmFiIGEgaGFuZGxlIHRvIHRoZSBleGlzdGluZyBzcHJlYWRzaGVldCBob2xkaW5nIHRoZSBTYWxlc0ZvcmNlIGltcG9ydCBkYXRhCiAgdmFyIHNoZWV0ID0gc3MuZ2V0U2hlZXRCeU5hbWUod3JpdGVTaGVldCkKICB2YXIgY29udGVudFJhbmdlID0gc2hlZXQuZ2V0UmFuZ2UoMSwxLHNoZWV0LmdldE1heFJvd3MoKSxjb2x1bW5OYW1lcy5sZW5ndGgpOwogIGNvbnRlbnRSYW5nZS5jbGVhckNvbnRlbnQoKTsKICAKICAvLyBTZXQgdGhlIGhlYWRlciB0aXRsZXMgZm9yIHRoZSBjb2x1bW5zCiAgdmFyIGhlYWRlcnNSYW5nZSA9IHNoZWV0LmdldFJhbmdlKDEsIDEsIDEsIGNvbHVtbk5hbWVzLmxlbmd0aCk7CiAgaGVhZGVyc1JhbmdlLnNldFZhbHVlcyhbY29sdW1uTmFtZXNdKTsKICBoZWFkZXJzUmFuZ2Uuc2V0Rm9udFdlaWdodCgiYm9sZCIpOwogIAogIC8vIENhbGxzIHRoZSBzZXRSb3dzRGF0YSBmdW5jdGlvbiB0byBhY3R1YWxseSBwb3B1bGF0ZSB0aGUgc2hlZXQKICBzZXRSb3dzRGF0YShzaGVldCwgcXVlcnlEYXRhKTsKfQoKCi8vIHNldFJvd3NEYXRhIGZpbGxzIGluIG9uZSByb3cgb2YgZGF0YSBwZXIgb2JqZWN0IGRlZmluZWQgaW4gdGhlIG9iamVjdHMgQXJyYXkuCi8vIEZvciBldmVyeSBDb2x1bW4sIGl0IGNoZWNrcyBpZiBkYXRhIG9iamVjdHMgZGVmaW5lIGEgdmFsdWUgZm9yIGl0LgovLyBBcmd1bWVudHM6Ci8vICAgLSBzaGVldDogdGhlIFNoZWV0IE9iamVjdCB3aGVyZSB0aGUgZGF0YSB3aWxsIGJlIHdyaXR0ZW4KLy8gICAtIG9iamVjdHM6IGFuIEFycmF5IG9mIE9iamVjdHMsIGVhY2ggb2Ygd2hpY2ggY29udGFpbnMgZGF0YSBmb3IgYSByb3cKLy8gICAtIG9wdEhlYWRlcnNSYW5nZTogYSBSYW5nZSBvZiBjZWxscyB3aGVyZSB0aGUgY29sdW1uIGhlYWRlcnMgYXJlIGRlZmluZWQuIFRoaXMKLy8gICAgIGRlZmF1bHRzIHRvIHRoZSBlbnRpcmUgZmlyc3Qgcm93IGluIHNoZWV0LgovLyAgIC0gb3B0Rmlyc3REYXRhUm93SW5kZXg6IGluZGV4IG9mIHRoZSBmaXJzdCByb3cgd2hlcmUgZGF0YSBzaG91bGQgYmUgd3JpdHRlbi4gVGhpcwovLyAgICAgZGVmYXVsdHMgdG8gdGhlIHJvdyBpbW1lZGlhdGVseSBiZWxvdyB0aGUgaGVhZGVycy4KZnVuY3Rpb24gc2V0Um93c0RhdGEoc2hlZXQsIG9iamVjdHMsIG9wdEhlYWRlcnNSYW5nZSwgb3B0Rmlyc3REYXRhUm93SW5kZXgpIHsKICB2YXIgaGVhZGVyc1JhbmdlID0gb3B0SGVhZGVyc1JhbmdlIHx8IHNoZWV0LmdldFJhbmdlKDEsIDEsIDEsIG9iamVjdHNbMF0ubGVuZ3RoKTsKICB2YXIgZmlyc3REYXRhUm93SW5kZXggPSBvcHRGaXJzdERhdGFSb3dJbmRleCB8fCBoZWFkZXJzUmFuZ2UuZ2V0Um93SW5kZXgoKSArIDE7CiAgdmFyIGhlYWRlcnMgPSBoZWFkZXJzUmFuZ2UuZ2V0VmFsdWVzKClbMF07CgogIHZhciBkZXN0aW5hdGlvblJhbmdlID0gc2hlZXQuZ2V0UmFuZ2UoZmlyc3REYXRhUm93SW5kZXgsIGhlYWRlcnNSYW5nZS5nZXRDb2x1bW5JbmRleCgpLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgb2JqZWN0cy5sZW5ndGgsIGhlYWRlcnMubGVuZ3RoKTsKICAKICBkZXN0aW5hdGlvblJhbmdlLnNldFZhbHVlcyhvYmplY3RzKTsKIAp9