AppScript Code Version 3

function doGet() {
// Gather all the data from the spreadsheet and set to variables
	var ss = SpreadsheetApp.openByUrl(
		 'https://docs.google.com/spreadsheets/d/1lPOwiYGBK0kSJXXU9kaQjG7WNHjnNuxy25WCUudE5sk/edit');
	SpreadsheetApp.setActiveSpreadsheet(ss);
	SpreadsheetApp.setActiveSheet(ss.getSheets()[0]);
	var title = ss.getSheets()[0].getRange("A1:A").getValues();
		var titles = [];
	var link = ss.getSheets()[0].getRange("B1:B").getValues();
		var links = [];
	var pubdate = ss.getSheets()[0].getRange("C1:C").getValues();
		var pubdates = [];
	var description = ss.getSheets()[0].getRange("D1:D").getValues();
		var descriptions = [];
	var author = ss.getSheets()[0].getRange("E1:E").getValues();
		var authors = [];
//Create loop to modifiy all variables with their xml tags for RSS
	for (i = 0; i < title.length; i++) {
		titles += "<item>" + "<title>" + title[i] + "</title>" + "\n";
	}
	for (i = 0; i < link.length; i++) {
		links += "<link>" + link[i] + "</link>" + "\n";
	}
	for (i = 0; i < pubdate.length; i++) {
		pubdates += "<pubdate>" + pubdate[i] + "</pubdate>" + "\n";
	}
	for (i = 0; i < description.length; i++) {
		descriptions += "<description>" + description[i] + "</description>" + "\n";
	}
	for (i = 0; i < author.length; i++) {
		authors += "<author>" + author[i] + "</author>" + "\n" + "</item>" + "\n";
	}

//Combine the variables to desired pattern output

//var all = [titles,links,descriptions,pubdates,authors];
	var mix = [];
	// after running the above loop mix will have the following contents:


  for(var n=0;n<titles.length;n++){
    mix.push(titles[n],links[n],descriptions[n],pubdates[n],authors[n]);
  }

//Print data and set mimetype
    return ContentService.createTextOutput(mix)
	.setMimeType(ContentService.MimeType.RSS);
}