saregama-carvaan.png

Saregama Carvaan, a digital music participant that appears like an old school transistor radio and targets the non-millennial era, has grow to be an enormous hit in India. The corporate analysed information from on-line music streaming websites like Saavn, Gaana and YouTube, got here up with a listing of 5000+ “biggest” Hindi film songs and pre-loaded them into Carvaan, categorised by artists and moods.

Like a radio station, Saregama Carvaan mixes nostalgia with a component of shock – the participant’s algorithm performs music in a random sequence so the listener would by no means know which music is developing subsequent. Can the Carvaan expertise be recreated with YouTube? Let’s discover out.

1. The Songs Record

A fast Google search on the Saregama web site led me to this PDF doc – it accommodates an entire record of each music that’s bundled into the Carvaan participant. I imported the songs PDF right into a Google Spreadsheet so the info may very well be simply filtered by film names or artistes.

2. The YouTube Database

The YouTube API allows you to question the video database by key phrases. I wrote a easy Google Script that reads the music titles from the Google Spreadsheet and finds the corresponding video on YouTube. The YouTube API returns the video hyperlink, the outline, the channel of the video uploader and the thumbnail picture (supply code).

youtube-api-video.png

three. The Spreadsheet Formulae

Google Spreadsheet offers the IMAGE components that helped me embed the YouTube thumbnail URLs as pictures into the spreadsheet cells. I used Array Formulation to use the identical components to the whole column within the spreadsheet.

The YouTube video IDs have been transformed to the YouTube URLs once more with the assistance of a easy array components.

=ArrayFormula(CONCAT("https://youtu.be/",D2:D))

four. The YouTube Playlist

Now the spreadsheet was populated with a listing of songs which can be preloaded into Carvaan and their corresponding YouTube movies.

The following activity was to create a YouTube playlist with all of the movies. I had earlier constructed a software for copying YouTube playlists and the identical API was used right here for constructing the playlist contained in the spreadsheet (supply code).

youtube-playlist.png

The Ultimate Outcome

And right here’s the ultimate end result – a YouTube playlist with 5000 songs that come bundled with Carvaan. Press the “Shuffle” icon and the songs would play in random sequence constantly.

saregama-carvaan-youtube-playlist.jpg

Helpful Hyperlinks