Google Sheets API v4 - How to get the last row with value? : <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>
