readStack

Personal Reading List Page With Google Sheet Integration Using Google AppScript.

Screenshots

Google AppScript Code

  //Edit Sheetname in argument on below function if different (Sheet1 is default) 
  var sheetName = 'Sheet1'
  var scriptProp = PropertiesService.getScriptProperties()

  function intialSetup () {
  	var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet()
  	scriptProp.setProperty('key', activeSpreadsheet.getId())
  }

  function doPost (e) {
  	var lock = LockService.getScriptLock()
  	lock.tryLock(10000)

  	try {
  		var doc = SpreadsheetApp.openById(scriptProp.getProperty('key'))
  		var sheet = doc.getSheetByName(sheetName)

  		var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0]
  		var nextRow = sheet.getLastRow() + 1

  		var newRow = headers.map(function(header) {
  		return header === 'timestamp' ? new Date() : e.parameter[header]
  		})

  		sheet.getRange(nextRow, 1, 1, newRow.length).setValues([newRow])

  		return ContentService
  		  .createTextOutput(JSON.stringify({ 'result': 'success', 'row': nextRow }))
  		  .setMimeType(ContentService.MimeType.JSON)
  }

  	  catch (e) {
  		return ContentService
  		  .createTextOutput(JSON.stringify({ 'result': 'error', 'error': e }))
  		  .setMimeType(ContentService.MimeType.JSON)
  	  }

  	  finally {
  		lock.releaseLock()
  	  }
  	}
          

  function doGet(e){
  
   //Change SpeadSheet Link Below
   var ss = SpreadsheetApp.openByUrl("YOUR SHARED GOOGLE SHEET LINK HERE");
  
    //Edit Sheetname in argument on below function if different (Sheet1 is default) 
    var sheet = ss.getSheetByName("Sheet1");
    
   return getLinks(sheet); 
    
  }


  function getLinks(sheet){
    var jo = {};
    var dataArray = [];
  
  // collecting data from 2nd Row , 1st column to last row and last column.
    var rows = sheet.getRange(2,1,sheet.getLastRow()-1, sheet.getLastColumn()).getValues();
    
    for(var i = 0, l= rows.length; i<l ; i++){
      var dataRow = rows[i];
      var record = {};
      //Edit records based on your requirement. 
      record['title'] = dataRow[0];
      record['link'] = dataRow[1];
      record['author'] = dataRow[2];
      
      dataArray.push(record);
      
    }  
    
    jo.user = dataArray;
    
    var result = JSON.stringify(jo);
    
    return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JSON);

  }  

Technology Stack

• Google AppsScript
• Google Sheets

Support

If you like this repo or find it useful, please consider (★) starring it.

License

GNU General Public License v3.0