read Sheet Gdrive Cse.gs

function myFunction() {
  var url = 'https://docs.google.com/spreadsheets/d/...';
  try {
    // https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#openByUrl(String)
    var ss = SpreadsheetApp.openByUrl(url);
    var sheet = ss.getSheets()[0];
    var numRows = sheet.getLastRow();
    var range = sheet.getRange(1, 2, numRows, 1);
    var values = range.getValues();        
    var now = new Date();
    var nSs = SpreadsheetApp.create('_PaC_Sheet ' +now.getHours()+ now.getMinutes()+ now.getSeconds());    
    var nSheet = nSs.getSheets()[0];
    var arr
    for (var row in values) {      
      // Logger.log(values[row][0]);
      arr = values[row][0].split(",");
      if (arr.length > 3) {        
        nSheet.appendRow([arr[1], arr[3], arr[0], arr[2]]);                  
      }      
    }        
  } catch(e) {
    Logger.log(e);     
  }
}

https://pac.eojji.com/