title: Google sheets API 4: How to append to the end of the row
body: <p>Able to update the row by providing the range, here is the code:</p>
  
  <pre><code>$range = "A1:B1";
  $valueRange= new Google_Service_Sheets_ValueRange();
  $valueRange-&gt;setValues(["values" =&gt; ["a", "b"]]); 
  $conf = ["valueInputOption" =&gt; "RAW"];
  $service-&gt;spreadsheets_values-&gt;update($spreadsheetId, $range, $valueRange, $conf);
  </code></pre>
  
  <p>Considering I don't know the range, how can I insert the row to the end of the sheet.</p>