Tag Archives: Google Apps Script

Google Apps Script

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:

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);

}

Google Apps Script – get notification from GitHub account – part 054.

Today I will show you a Google Apps Script that resizes all images from a Google document up to 16 cm. Create a new document add some images, and from the main menu select the script editor and add this script with your google_document_id and the size of the images in cm.

function resizeImagesInGoogleDoc() {
  // Replace this with the ID of your Google Docs document
  var docId = "google_document_id";
  
  var doc = DocumentApp.openById(docId);
  var body = doc.getBody();
  var images = body.getImages();
  
  for (var i = 0; i < images.length; i++) {
    var image = images[i];
    var width = image.getWidth();
    var height = image.getHeight();
    var ratio = height / width;
    var newWidthInCm = 16.0; // Set the new width of the image in centimeters
    var newWidthInPixels = Math.round(newWidthInCm * 28.3465); // Convert centimeters to pixels using the DPI of Google Docs
    
    image.setWidth(newWidthInPixels);
    image.setHeight(Math.round(newWidthInPixels * ratio));
  }
}

function resizeImagesInGoogleDoc() {

// Replace this with the ID of your Google Docs document

var docId = "google_document_id";

var doc = DocumentApp.openById(docId);

var body = doc.getBody();

var images = body.getImages();

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

var image = images[i];

var width = image.getWidth();

var height = image.getHeight();

var ratio = height / width;

var newWidthInCm = 16.0; // Set the new width of the image in centimeters

var newWidthInPixels = Math.round(newWidthInCm * 28.3465); // Convert centimeters to pixels using the DPI of Google Docs

image.setWidth(newWidthInPixels);

image.setHeight(Math.round(newWidthInPixels * ratio));

}

Google Apps Script – get notification from GitHub account – part 053.

You need to have a GitHub account. Create a new token by following these steps: Go to your GitHub settings. Click on “Developer settings”. Click on “Personal access tokens”. Click on “Generate new token”. Select the scopes you want the token to have (in this case, make sure to select the “notifications” scope). Click on… Read More »

Google Apps Script – search File ID with custom open dialog – part 052.

This Google Apps Script new script shows a dialog with : a label with the text: “Enter the file name to search for:” ; an edit box for the name of the file; the Ok button to run the script; The script will search the file ID and will show you a dialog message like… Read More »

Google Apps Script – search YouTube by query and date – part 051.

This simple example tutorial shows how to get a list of videos from youtube based on a query search. The query is defined like this with the q for word of search, a published after date, and more …

{
    q: 'python',
    type: 'video',
    eventType: 'completed',
    maxResults: 25,
    order: 'date',
    publishedAfter: '2022-07-10T00:00:00Z'
  }

{

q: 'python',

type: 'video',

eventType: 'completed',

maxResults: 25,

order: 'date',

publishedAfter: '2022-07-10T00:00:00Z'

}

This is the source code:

function search_query(id) {
 var results = YouTube.Search.list('id,snippet', {
    q: 'python',
    type: 'video',
    eventType: 'completed',
    maxResults: 25,
    order: 'date',
    publishedAfter: '2022-07-10T00:00:00Z'
  });

  var data = [];
  for(var i = 0; i < results.items.length; i++) {
    Logger.log(results.items[i].snippet.title);
  }
}

function search_query(id) {

var results = YouTube.Search.list('id,snippet', {

q: 'python',

type: 'video',

eventType: 'completed',

maxResults: 25,

order: 'date',

publishedAfter: '2022-07-10T00:00:00Z'

});

var data = [];

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

Logger.log(results.items[i].snippet.title);

}

This is the result of running my source code:… Read More »

Google Apps Script – Google Analytics API usage limit error – part 051.

GoogleJsonResponseException: API call to youtube.channels.list failed with error: 
The request cannot be completed because you have exceeded your 
<a href="/youtube/v3/getting-started#quota">quota</a>.

GoogleJsonResponseException: API call to youtube.channels.list failed with error:

The request cannot be completed because you have exceeded your

<a href="/youtube/v3/getting-started#quota">quota</a>.

… indicating that you have reached the usage limit for the YouTube API. for each A.P.I. comes a different limit of usage, on the case of YouTube API, each user is assigned a set of quota units per day, which can be used to make requests to the A.P.I. and once the usage limit… Read More »

Google Apps Script – Google Analytics API service – part 050.

This is a simple example with Google Analytics API service settings. You need to add the Analytics service version 3.

function getAnalytics() {
  // get data with Google Analytics API service settings version 3
  var viewId = "ga:YOUR_views_number";
  var metrics = [{expression: "ga:sessions"}];
  var dimensions = [{name: "ga:date"}];
  var startDate = "2022-01-01";
  var endDate = "2022-01-31";
  var results = Analytics.Data.Ga.get(
    viewId,
    startDate,
    endDate,
    'ga:visitors,ga:visits,ga:pageviews',
    {dimensions: "ga:date"});
  Logger.log(results);
}

function getAnalytics() {

// get data with Google Analytics API service settings version 3

var viewId = "ga:YOUR_views_number";

var metrics = [{expression: "ga:sessions"}];

var dimensions = [{name: "ga:date"}];

var startDate = "2022-01-01";

var endDate = "2022-01-31";

var results = Analytics.Data.Ga.get(

viewId,

startDate,

endDate,

'ga:visitors,ga:visits,ga:pageviews',

{dimensions: "ga:date"});

Logger.log(results);

}

The result is shown in the Google Apps Script editor with Logger.log :

{kind=analytics#gaData, id=https://www.googleapis.com/analytics/v3/data/ga?ids=ga:
YOUR_views_number&dimensions=ga:date&metrics=ga:visitors,ga:visits,ga:
pageviews&start-date=2022-01-01&end-date=2022-01-31, columnHeaders=[{name=ga:date, 
dataType=STRING, columnType=DIMENSION}, {columnType=METRIC, name=ga:visitors, 
dataType=INTEGER}, {name=ga:visits, dataType=INTEGER, columnType=METRIC}, 
{dataType=INTEGER, columnType=METRIC, name=ga:pageviews}], totalResults=31.0, rows=
[[20220101, 33, 33, 41], 
...

{kind=analytics#gaData, id=https://www.googleapis.com/analytics/v3/data/ga?ids=ga:

YOUR_views_number&dimensions=ga:date&metrics=ga:visitors,ga:visits,ga:

pageviews&start-date=2022-01-01&end-date=2022-01-31, columnHeaders=[{name=ga:date,

dataType=STRING, columnType=DIMENSION}, {columnType=METRIC, name=ga:visitors,

dataType=INTEGER}, {name=ga:visits, dataType=INTEGER, columnType=METRIC},

{dataType=INTEGER, columnType=METRIC, name=ga:pageviews}], totalResults=31.0, rows=

[[20220101, 33, 33, 41],

...

Google Apps Script – check terms and conditions – part 049.

Check before running scripts like Google Apps script, maybe you should check the validity of the terms and conditions.