Google Apps Script – reading and store feeds from feedly website – part 055. – free-tutorials.org news free tutorials source code development scripts

You need to have an account with feeds on feedly.com and create a on this website.
Open your google drive , create a new spreadsheet and open the Google Apps Script editor.
This will allow to use this source code and the result of the running will be add into your spreadsheet:

function getFeedlyFeeds() {
  // your User ID-ul 
  var userId = ""; 
  // your Access Token-ul
  var accessToken = ""; 

  var apiUrl = "https://cloud.feedly.com/v3/"; // URL for API Feedly

  //GET all feeds
  var response = UrlFetchApp.fetch(apiUrl + "streams/contents?streamId=user/" + userId + "/category/global.all", {
    headers: {
      Authorization: "Bearer " + accessToken
    },
    muteHttpExceptions: true
  });

  // check HTTP answer
  var statusCode = response.getResponseCode();
  if (statusCode === 200) {
    var responseData = JSON.parse(response.getContentText());
    // store data into items
    var items = responseData.items;

    // sorting
    items.sort(function(a, b) {
      var dateA = new Date(a.published);
      var dateB = new Date(b.published);
      return dateA - dateB;
    });

    // iterations for feeds 
    for (var i = 0; i < items.length; i++) {
      var item = items[i];
      var title = item.title;
      var url = item.canonicalUrl || item.originId; 
      var published = new Date(item.published);

      // create sheet name
      var sheetName = published.toISOString().split("T")[0];

      // get sheet
      var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);

      // if sheet is not exist then create it 
      if (!sheet) {
        sheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet(sheetName);
        sheet.getRange("A1").setValue("Feed Title");
        sheet.getRange("B1").setValue("Feed URL");
        sheet.getRange("C1").setValue("Published Date");
      }

      // add feeds
      var lastRow = sheet.getLastRow();
      sheet.getRange(lastRow + 1, 1).setValue(title);
      sheet.getRange(lastRow + 1, 2).setValue(url);
      sheet.getRange(lastRow + 1, 3).setValue(published);
    }
  } else {
    Logger.log("Error HTTP: " + statusCode);
  }
}

function getFeedlyFeeds() {

// your User ID-ul

var userId = "";

// your Access Token-ul

var accessToken = "";

var apiUrl = "https://cloud.feedly.com/v3/"; // URL for API Feedly

//GET all feeds

var response = UrlFetchApp.fetch(apiUrl + "streams/contents?streamId=user/" + userId + "/category/global.all", {

headers: {

Authorization: "Bearer " + accessToken

muteHttpExceptions: true

});

// check HTTP answer

var statusCode = response.getResponseCode();

if (statusCode === 200) {

var responseData = JSON.parse(response.getContentText());

// store data into items

var items = responseData.items;

// sorting

items.sort(function(a, b) {

var dateA = new Date(a.published);

var dateB = new Date(b.published);

return dateA - dateB;

});

// iterations for feeds

for (var i = 0; i < items.length; i++) {

var item = items[i];

var title = item.title;

var url = item.canonicalUrl || item.originId;

var published = new Date(item.published);

// create sheet name

var sheetName = published.toISOString().split("T")[0];

// get sheet

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);

// if sheet is not exist then create it

if (!sheet) {

sheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet(sheetName);

sheet.getRange("A1").setValue("Feed Title");

sheet.getRange("B1").setValue("Feed URL");

sheet.getRange("C1").setValue("Published Date");

}

// add feeds

var lastRow = sheet.getLastRow();

sheet.getRange(lastRow + 1, 1).setValue(title);

sheet.getRange(lastRow + 1, 2).setValue(url);

sheet.getRange(lastRow + 1, 3).setValue(published);

}

} else {

Logger.log("Error HTTP: " + statusCode);

}

Leave a Reply Cancel reply