title: How to append data refer by ID in Google Script Apps?
body: <p>I try using Google Script Apps for append data to Google Spreadsheet null Column <strong>&quot;rate&quot;</strong> like:</p>
  <pre><code>+----+-------+------+
  | id | name  | rate |  
  +----+-------+------+
  | 1  | Item1 |      |
  +----+-------+------+
  | 2  | Item2 |      |
  +----+-------+------+
  | 3  | Item3 |      |
  +----+-------+------+
  </code></pre>
  <p>How modification bellow code to work fine like <strong>id=1&amp;rate=good</strong> for append Column value <strong>rate</strong> with refer by call id 1,2,3 or any more and work to append value like</p>
  <pre><code>+----+-------+------+
  | id | name  | rate |  
  +----+-------+------+
  | 1  | Item1 | good |
  +----+-------+------+
  | 2  | Item2 |      |
  +----+-------+------+
  | 3  | Item3 |      |
  +----+-------+------+
  </code></pre>
  <pre><code>function doGet(e) {
    var id = e.parameter.id || 1;
    var rate = e.parameter.rate || &quot;&quot;;
    var ss = SpreadsheetApp.openByUrl(&quot;https://docs.google.com/spreadsheets/d/10S8Igzt1tpqUBgJHVKpny-2s6G3Y3-vFsLMvlZVqpkc/edit#gid=810612111&quot;);
    var sheet = ss.getSheetByName(&quot;list_film&quot;);
    return insertData(sheet, id,rate);
  }
  
  function insertData(sheet, id,rate){
    var rows = sheet.getDataRange().getDisplayValues().filter(([a]) =&gt; a == id);
    var data = rows.appendRow([rate]);
    return ContentService.createTextOutput(data).setMimeType(ContentService.MimeType.JSON);
  }
  ``
  </code></pre>