You created an RSS reader application in Chapter 6, Creating Feed Reader and Translator Applications. Now, you can create an application to publish an RSS feed. Put the RSS data in a Sheet as shown here:
Also, edit/enter the following doGet function:
function doGet() {
/*
* There is no active spreadsheet, so you should open by id.
* Use the id of the spreadsheet in which your script resides.
*
*/
var ss = SpreadsheetApp.openById([[ this spreadsheet id ]]);
var SheetRss = ss.getSheetByName("RSS Data");
var rssData = SheetRss.getDataRange().getValues();
// Remove header.
rssData.shift();
var strRss = '<?xml version="1.0" encoding="UTF-8"?>';
// Root element.
strRss += '<rss>';
// Open channel element.
strRss += '<channel>';
// Add description and language elements.
strRss += '<description>A brief description of the channel</description>';
strRss += '<language>...