title: Google Sheets API v4 - How to get the last row with value?
body: <p>How to get the last row with value in the new Google Sheets API v4 ?</p>
  
  <p>i use this to get a range from a sheet:</p>
  
  <pre><code>mService.spreadsheets().values().get("ID_SHEET", "Sheet1!A2:B50").execute();
  </code></pre>
  
  <p>how to detect the last row with value in the sheet ?</p>