Google Apps ScriptTag Archive

Google Apps Script

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… Continue Reading Google Apps Script – annotations – part 037.

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.

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

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]

This tutorial contains a function that can be included in your Google Apps Script and will help you monitor likes based on the youtube channel you liked. The function returns the Youtube channel you liked in the order from the last like to the first.

JavaScript
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
function retrieve_youtube_channels_likes() {
  var results = YouTube.Channels.list('snippet, contentDetails', {mine: true});
  for(var i in results.items)
  {
    var item = results.items[i];
    var playlistId = item.contentDetails.relatedPlaylists.likes;
    var nextPageToken = '';
 
    while (nextPageToken != null) {
      var playlistResponse = YouTube.PlaylistItems.list('snippet',
      {
        playlistId: playlistId,
        maxResults: 25,
        pageToken: nextPageToken
              });
      for (var j = 0; j < playlistResponse.items.length; j++) {
        var playlistItem = playlistResponse.items[j];
        Logger.log('Title:[%s] Id:[%s]', playlistItem.snippet.videoOwnerChannelTitle,
        playlistItem.snippet.videoOwnerChannelId);
      }
      nextPageToken = playlistResponse.nextPageToken;
    }
  }
}

The output results in… Continue Reading Google Apps Script – get all channels with your likes – part 033.

In this tutorial, I will show you the differences between getValue and getDisplayValue in Google Apps Script. I used a default project with a default spreadsheet document with my birthday 1976-03-07 into A1 cell and format text as year-month-day. I add Apps Script API to my project. On the spreadsheet,… Continue Reading Google Apps Script – getValue or getDisplayValue – part 032.

The tutorial for today is about toast message into a spreadsheet. Use script editor, run the next code source it with authorization:

JavaScript
1
2
3
4
5
function myFunction() {
  var ss = SpreadsheetApp.getActive();
  ws = ss.getSheetByName("Sheet1");
  ss.toast("This is a toast message!");
}

You will see a message toast in the bottom right area of the spreadsheet with this text: This is a toast message!

Today I will present briefly Class GmailThread. It can be used to retrieve data from incoming electronic mail received by Gmail. Let’s see a simple example. First, open a spreadsheet, and from Tools open the Script editor to run this source code:

1
2
3
4
5
6
7
function getGmailData() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var threads = GmailApp.search("is:unread in:inbox", 0, 7);
  for (var t=0; t<threads.length; t++) {
    sheet.appendRow([threads[t], threads[t].getId(), threads[t].getLabels(),threads[t].getFirstMessageSubject()])
  }
}

. Add and run with authorization for Gmail… Continue Reading Google Apps Script – about Class GmailThread – part 030.

Translate »