Tag Archives: Google Apps Script

Google Apps Script

Google Apps Script – emails to spreadsheet by a given pattern – part 041.

In this tutorial, I will show you how you can add emails from your Gmail account into a spreadsheet by a given pattern. First, you need to create a spreadsheet and use the Google Apps Script editor from the main menu Extensions – Apps Script. The script will need to run with the onOpen function… Read More »

Google Apps Script – annotations – part 039.

This is a simple example with Google Apps Script and geocode feature.

JavaScript
1
2
3
4
5
6
7
8
9
10
11
12
13
14
function geoCodeAddress(address){
/*
https://developers.google.com/apps-script/reference/maps/geocoder#geocode(String)
*/
  var address = "Fălticeni";
  if(address !== ""){
  var response = Maps.newGeocoder().geocode(address);
    for (var i = 0; i < response.results.length; i++) {
      var result = response.results[i];
    }
  }
  Logger.log(result.geometry.location.lat + "," +result.geometry.location.lng)
return result.geometry.location.lat + "," +result.geometry.location.lng;
}

The result is this:

1
2
3
12:46:19 AM Notice Execution started
12:46:19 AM Info 47.4615626,26.3015288
12:46:19 AM Notice Execution completed

Google Apps Script – annotations – part 037.

In brief: JSDoc is a markup language used to annotate JavaScript source code files. Using comments containing JSDoc, programmers can add documentation describing the application programming interface of the code they’re creating. This is then processed, by various tools, to produce documentation in accessible formats like HTML and Rich Text Format. The JSDoc specification is… Read More »

Google Apps Script – send mail with map address – part 036.

Open a Spreadsheet and rename the Sheet to test001. Use the next source code:

1
2
3
4
5
6
7
function sendMap() {
  //var sheet = SpreadsheetApp.getActiveSheet();
  var sheet = SpreadsheetApp.getActive().getSheetByName('test001')
  var address = sheet.getRange('A1').getValue();
  var map = Maps.newStaticMap().addMarker(address);
  GmailApp.sendEmail('catafest@yahoo.com', 'Map', 'See below.', {attachments:[map]});
}

This will send a mail to my email address with a map from the address in column A1.

Google Apps Script – RSS reader – part 035.

This is a simple Google Apps Script for read a atom RSS file type. This not work with any rss file type , just with this type:

1
xmlns:atom="http://www.w3.org/2005/Atom"

This is the script:

JavaScript
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
function RSSRead()
{
  var sheet = SpreadsheetApp.getActiveSheet();
  var item, date, title, link, desc;
 
  var txt = UrlFetchApp.fetch("http://free-tutorials.org/feed/").getContentText();
  var document = XmlService.parse(txt);
  var root = document.getRootElement();
  var entries = root.getChildren('channel');
  Logger.log(entries);
  for (var i = 0; i < entries.length; i++) {
    var link = entries[i].getValue();
    for (var j = 0; j < link.length; j++) {
      var link = entries[j].getValue();
    Logger.log(link);
    }
}

Google Apps Script – get all your liked videos – part 034.

In this tutorial, I will show you how to get the first 76 videos from youtube that you clicked on the like button. The dimension parameter is also displayed and its value is returned.

JavaScript
1
2
3
4
5
6
7
8
9
10
function retrieve_youtube_videos_likes() {
  var results = YouTube.Videos.list('snippet, contentDetails', {mine: true, myRating: 'like', maxResults: 76});
  for(var i in results.items)
  {
    var item = results.items[i];
    var id_like_title = item.snippet.title;
    var id_dimension = item.contentDetails.dimension;
    Logger.log('Title:[%s] dimension:[%s]',id_like_title, id_dimension);
  }
}

The result looks like this:

1
2
3
4
11:33:47 PM Info Title:[Rainbow Six Extraction: Sprawl Teaser] dimension:[2d]
11:33:47 PM Info Title:[WIN A FREE Pomera E INK Keyboard by KING JIM- REAL] dimension:[2d]
11:33:47 PM Info Title:[Adafruit Macropad RP2040 bring-up test] dimension:[2d]
11:33:47 PM Info Title:[Boeing MQ-25 Becomes First Unmanned Aircraft to Refuel Another Aircraft] dimension:[2d]