Use this function to read data from a spreadsheet and filter out empty rows.
```javascript
const SSID = '<spreadsheet-id>';
const SHEETNAME = 'data';
var ss = SpreadsheetApp.openById(SSID);
var ws = ss.getSheetByName(SHEETNAME);
var data = ws.getRange(1, 1, ws.getLastRow(), ws.getLastColumn()).getValues();
// remove blank and N/A rows
data = data.filter(row => row[0] !== '' && row[0] !== "#N/A");
```