function getData() {
 
// related with Sheet "Sheet_1"
 
 
//  1. Create headers
// https://zapier.com/blog/google-apps-script-tutorial/
// * * * * * * * * * * * * * * * * * * * * *
 
// Create headers
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Sheet_1');
 
 
  // Set the headers values
  var values = [
    ["COMMON", "BOTANICAL", "ZONE", "LIGHT", "PRICE", "AVAILABILITY"]
  ];
 
  // Set the range of cells
  var range = sheet.getRange("A1:F1");
 
  // Call the setValues method on range and pass in our values
  range.setValues(values);
 
 
 
//  2. Import data
// * * * * * * * * * * * * * * * * * * * 
// If .XML file => use semicolon  -> plant_catalog.xml"; "//COMMON"
// If xml generated with .PHP file => use comma -> plant_catalog.xml", "//COMMON"
// * * * * * * * * * * * * * * * * * * * 
 
var importCommon = '=IMPORTXML("https://www.xmlfiles.com/examples/plant_catalog.xml"; "//COMMON")';
var importBotanical = '=IMPORTXML("https://www.xmlfiles.com/examples/plant_catalog.xml"; "//BOTANICAL")';
var importZone = '=IMPORTXML("https://www.xmlfiles.com/examples/plant_catalog.xml"; "//ZONE")';
var importLight = '=IMPORTXML("https://www.xmlfiles.com/examples/plant_catalog.xml"; "//LIGHT")';
var importPrice = '=IMPORTXML("https://www.xmlfiles.com/examples/plant_catalog.xml"; "//PRICE")';
var importAvailability = '=IMPORTXML("https://www.xmlfiles.com/examples/plant_catalog.xml"; "//AVAILABILITY")';
 
 
SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet_1').getRange('A2').setValue(importCommon);
SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet_1').getRange('B2').setValue(importBotanical);
SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet_1').getRange('C2').setValue(importZone);
SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet_1').getRange('D2').setValue(importLight);
SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet_1').getRange('E2').setValue(importPrice);
SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet_1').getRange('F2').setValue(importAvailability);
 
}