title: How to insert row after the last row with value?
body: <p>I am inserting data into a spreadsheet with the new Google Sheets API v4, the code works perfect and the data it is inserted well in the sheet.</p>
  
  <p>But how to find out the last row with data to add the data after this ?</p>
  
  <pre><code>List&lt;List&lt;Object&gt;&gt; arrData = getData();
  
  ValueRange oRange = new ValueRange();
  oRange.setRange("Pedidos!AXXXXXXX"); // I NEED THE NUMBER OF THE LAST ROW
  oRange.setValues(arrData);
  
  List&lt;ValueRange&gt; oList = new ArrayList&lt;&gt;();
  oList.add(oRange);
  
  BatchUpdateValuesRequest oRequest = new BatchUpdateValuesRequest();
  oRequest.setValueInputOption("RAW");
  oRequest.setData(oList);
  
  BatchUpdateValuesResponse oResp1 = mService.spreadsheets().values().batchUpdate("ID_SPREADSHEET", oRequest).execute();
  </code></pre>
  
  <p>Is there some trick in the A1 notation for this? </p>
  
  <p>I need an equivalent to <code>.getLastRow</code> from Google Apps Script.</p>