Google Apps ScriptTag Archive

Google Apps Script

This tutorial is about copy-paste filtered cells values. You need to create a spreadsheet named CustomSheet with two sheets named: SheetInput and Target. In the SheetInput add this data for each column A,B, C, D, E, F: A B C D E F A $1 30% AA Criteria B $1… Continue Reading Google Apps Script – copy and paste filtered cells value – part 040.

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

This tutorial is a short intro about web development and google apps script. Google apps script is a good tool and lets us use forms and sheets, also can be used with google site and any website. After you write the source code in the google apps script for web… Continue Reading Google Apps Script – annotations – part 038.

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.

Translate »