javascript
function postToBlogger() {
var blogId = "7056421326112681707"; // înlocuiește cu ID-ul tău
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Amazon");
var data = sheet.getDataRange().getValues();
for (var i = 1; i < data.length; i++) {
var title = data[i][0];
var descriere = data[i][1];
var image = data[i][2];
var pret = data[i][3];
var link = data[i][4];
var content = "![](" + image + ")
" +
"
" + title + "
" + "" + descriere + "
" + "Preț: " + pret + "
" + "Cumpără acum"; var options = { method: "post", contentType: "application/json", headers: { Authorization: "Bearer " + ScriptApp.getOAuthToken() }, payload: JSON.stringify({ kind: "blogger#post", blog: { id: blogId }, title: title, content: content }), muteHttpExceptions: true }; var response = UrlFetchApp.fetch( "https://www.googleapis.com/blogger/v3/blogs/" + blogId + "/posts/", options ); Logger.log(response.getContentText()); Utilities.sleep(1000); } }
Comentarii
Trimiteți un comentariu