gappsscript.js

site = SitesApp.getSite("myrp.edu.sg", "sitesdemo"); // domain and site's name (url)
list = site.getListPages(); //get all ListPages and store inside an array

function updateList(){
    var sheet = SpreadsheetApp.getActiveSheet(); //get the Spreadsheet that the script is executed from
    var startRow = 2; 
    var numRows = sheet.getLastRow()-1;  //get number of rows to fetch data
    var dataRange = sheet.getRange(startRow,1,numRows,3); //range based on A1 notation
    var data = dataRange.getValues();
    var columns = ["Name","Email"]; //column names in the ListPage

    for (var i = 0; i < data.length; ++i) {    
        var row = data[i];
        var name = row[0]
        var email = row[1];
        var status = row[2];
        var values = [name,email];
        if (status != "Processed") {  //making sure not to add those that has already been added before
            var ann = site.createListItem("New member: "+name,columns,values,list[0]);     
            sheet.getRange(startRow + i, 3).setValue("Processed");
            SpreadsheetApp.flush();  
        }        
    }
}