How to Make Saregama Carvaan Playlist from YouTube & Googlesheets

Can you believe me if I tell the way on how to make your own Saregama Carvaan from YouTube and Google Sheets? I can call Saregama Caravan as a Music Book. It is liked by many people around the world. It is a personal favorite of mine too. It has targeted the music lovers and has given the most beautiful songs. It cannot be washed away from the Music beings present everywhere.

Still, today’s world will never allow us to have a choice of picking a radio with us every time and everywhere. Old radios are really charming. Saregama caravan is ad-free and has no recurring cost.

There is something that is even cheaper than this. Just an internet connection can make all the evergreen songs to be with you all the time. For this, you have to know how to make your own Saregama Carvaan from YouTube and Google Sheets.

It has researched major music streaming sites and has compiled more than 5000 songs under the heads moods and artists. This journey of music compilation started in the year 1901. If you are a music lover, you have to know how to make your own Saregama Carvaan from YouTube and Google Sheets. It is sure that you are going to love this.

How to Make your own Saregama Carvaan from YouTube

STEP 1:  We will go with the Google Sheet. You need a list of songs to make your own Saregama Carvaan. Let us get help from the Saregama Carvaan. If you get into the website of Saregama Carvaan, you can find a PDF file.

See also:  How to Get Youtube Sponsor Button?

STEP 2: That PDF has the complete list of songs that were enrolled by Saregama. It is a PDF file of 150 pages. Import the whole list of songs into the Google sheet. Copy and paste all the information as you can use the available information to filter and find your most favorites.

How to make your own Saragame Carvaan from youtube and google sheets

SaregamaCarvaan Song Listing: PDF

 

STEP 3: You have to get the information from the YouTube. If you are good at writing Google scripts, you can go ahead and make your Google script that can read the song title from the Google Spreadsheet and finds the right song from the YouTube videos.

 

function findYouTubeVideoByKeywords() {// get the search query from Google Sheets

var sheet = SpreadsheetApp.getActiveSheet();

var data = sheet.getDataRange().getValues();

 

// iterate through all rows in the sheet

for (var d=1,l=data.length; d<l; d++) {

 

// find the top result only

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

q: data[d][0],

maxResults: 1

});

 

// was a matching video found on YouTube?

if (results.pageInfo.totalResults !== 0) {

var item = results.items[0];

var snippet = item.snippet;

var response = [

item.id.videoId,

snippet.title,

snippet.description,

new Date(snippet.publishedAt),

snippet.channelId,

snippet.channelTitle,

snippet.thumbnails[“default”][“url”],

];

// write the response to Google Sheet

sheet.getRange(d+1, 4, 1, response.length).setValues([response])

}

 

// add a sleep between calls to avoid hitting the rate limit

Utilities.sleep(1000);

}

 

// refresh the Google Spreadsheet

SpreadsheetApp.flush();

}

 

 

 

 

 

 

Use the above source code to build your YouTube database.

How to make your own Saragame Carvaan from youtube and google sheets

This will help you to have the video link, description, and a thumbnail image. You can use the below above code.

STEP 4: To add an image to a cell, highlight the cell and click F2 to enter the formula mode and then type =image (“URL”) where URL is the public web address of that image.

Make your own Saregama Carvaan from YouTube Channel

To have the same formula in all the cells, you should array formulas. This serves as a crucial step when you want to know how to make your own Saregama Carvaan from YouTube and Google Sheets.

How to make your own Saragame Carvaan from youtube and google sheets

STEP 4: Write your formula in the first row of your spreadsheet, and then point your mouse to the lower right corner of the formula cell. The pointer changes into a fill handle that you can drag to the last row of the sheet. Highlight the first cell in the column and type the formula as earlier.

Instead of specifying a single cell as a parameter, we’ll specify the entire column using the B2:B notation. It is nothing but to start from cell B2 and go all the way down to the last row of column B.

Now the spreadsheet was populated with a list of songs that are preloaded into Carvaan and their corresponding YouTube videos. And here’s the final result – a YouTube playlist with 5000 songs that come bundled with Carvaan.

STEP 5: Press the “Shuffle” icon and the songs would play in random sequence continuously. Now you have got to know how to make your own Saregama Carvaan from YouTube and Google Sheets . You can use the source code below.


function addVideoToYouTubePlaylist() {

// Read the source videos from Google Sheet

var sheet = SpreadsheetApp.getActiveSheet();

var data = sheet.getDataRange().getValues();

 

// Add your own playlist Id here

var playlistId = “PLAYLIST_ID_HERE”;

 

// iterate through all rows in the sheet

for (var d=1,l=data.length; d<l; d++) {

 

// Add the video the existing playlist

YouTube.PlaylistItems.insert({

snippet: {

playlistId: playlistId,

resourceId: {

kind: “youtube#video”,

videoId: data[d][0]

}

}

}, “snippet”);

 

// wait for a second to avoid hitting the rate limit

Utilities.sleep(1000);

}

}

 

Use the above source code to create your Playlist of songs.

 

 

 

 

This option of having one’s own favorite songs will really refresh Music Beings. The easy use of having the whole lot of songs will surely be a great experience. Happy Music for all Music Beings.

How to make your own Saragame Carvaan from youtube and google sheets

Leave a Reply