Google Apps Script – search videos by channel – part 023.

Posted on: 02/07/2019 12/11/2020
Categories: All, Google Apps Script, JavaScript, Programming
Tags: 2019, Google Apps Script, programming, scripting, source code, tutorial, tutorials

This Google Apps Script tutorial will show you how to search for videos from YouTube.
First, you need to run this script with and YouTube Data A.P.I. and one Spreadsheet.
The script will get the title and id of the first 50 videos info and the result is put into the Shee1.
This is the script:

function Search_YouTube_videos_ByChannel() {
  var results = YouTube.Search.list('id,snippet', {
    channelId:'UCz75RVbH8q2jdBJ4SnwuZZQ',
    maxResults: 50
  });
    var title = "";
    var id = "";
    var last_row = 0;
    var spread_active = SpreadsheetApp.getActiveSpreadsheet();
    var sheet1 = spread_active.getSheetByName("Sheet1");
    for (var i = 0; i < results.items.length; i++) {
        var item = results.items[i];
        title = item.snippet.title;
        id = item.id.videoId;
        last_row = sheet1.getLastRow() + 1;
        sheet1.getRange(last_row, 1).setValue(title);
        sheet1.getRange(last_row, 2).setValue(id);
        last_row++;
    }
}

function Search_YouTube_videos_ByChannel() {

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

channelId:'UCz75RVbH8q2jdBJ4SnwuZZQ',

maxResults: 50

});

var title = "";

var id = "";

var last_row = 0;

var spread_active = SpreadsheetApp.getActiveSpreadsheet();

var sheet1 = spread_active.getSheetByName("Sheet1");

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

var item = results.items[i];

title = item.snippet.title;

id = item.id.videoId;

last_row = sheet1.getLastRow() + 1;

sheet1.getRange(last_row, 1).setValue(title);

sheet1.getRange(last_row, 2).setValue(id);

last_row++;

}

admin

born 1976, Falticeni , Suceava , Romania

673

admin

Leave a Reply Cancel reply