title: using isBlank() in google apps script to mark column
body: <p>How exactly do you use isBlank() in a google apps script function?</p>
  
  <pre><code>function pushGeo()
  {
  var ssA = SpreadsheetApp.openById('###')
  var ss = ssA.getSheetByName('mySheet');
  var lastRow = ss.getLastRow();
    var data = ss.getRange('G2:G'+lastRow);
    for(var row=2;row&lt;=lastRow;row++) 
    {  
      ss.getRange('G'+row+':G'+row).isblank(); // not working
      if(isblank(data),'0','G'+row); // not working
    }
  }
  </code></pre>
  
  <p>I want to check a column 'G' for blank cells. If the cell is blank, I want to set its value to '0'. Ultimately, I want to take the column 'G' that was just checked for empty cells and compare it to another column 'N'. If the row in column 'G' is NOT empty (now with value '0') then push the value of column 'G' into column 'N'. Wanted to change the empty cells to '0' so that I can "see" the code better, easier comparison, etc.</p>