Google Apps Script – reading and store feeds from feedly website – part 055.
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:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 | 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); } } |