title: Google script: how to set Array Value on google sheet to specific rows/column
body: <p>So far I have a code to get files from folder on Google Drive and create a list on Google sheet as</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>function getFiles() {
  
    //get value from A1 of every sheet
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheetsCount = ss.getNumSheets();
    var sheets = ss.getSheets();
    var rangeHeader = [];
    var range = [];
    var value = [];
    var files = [];
  
    // for every sheet
    for (var i = 1; i &lt; sheetsCount; i++) {
  
      value.push(sheets[i].getRange("A1").getValue()); //get cell A1
  
    }
  
    // Get files from folder
    for (var i = 0; i &lt; value.length; i++) { // For all the id on the main sheet
  
      if (value[i] != "") {
        sheets[i + 1].appendRow(["File Name", "URL", "Last Updated", "File Type", "Description"]);
        files = DriveApp.getFolderById(value[i]).getFiles();
        while (files.hasNext()) { // While there is files
          var file = files.next(); // Look on the next file
          var Name = file.getName();
          var url = file.getUrl();
          var date = file.getLastUpdated();
          var type = file.getMimeType();
          var des = file.getDescription();
  
          sheet[i + 1].appendRow(Name, url, date, type, des);
        }
      }
    }
  
  }</code></pre>
  </div>
  </div>
  </p>
  
  <p>I got a result perfectly on the sheet like this</p>
  
  <p><a href="https://i.stack.imgur.com/T7g6b.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/T7g6b.png" alt="enter image description here"></a></p>
  
  <p>and then I create a function to update a list by <strong>delete a value on column A:E and run getFiles function again</strong></p>
  
  <p><strong>BUT</strong> when I add value to another column like this</p>
  
  <p><a href="https://i.stack.imgur.com/qYrNt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qYrNt.png" alt="enter image description here"></a></p>
  
  <p>the header row[File Name,url,Last updated,..] move to the 4th row of the sheet,but I want it to append on the 2nd row everytime I run the function.</p>
  
  <p>and I added the value to that column because it could have another information that I'll add it manually in the future.</p>
  
  <p><strong>So,I would like to ask how can I set value or appendRow to the specific row(2nd row) /column A to E on my script?</strong> thanks.</p>