A couple of YouTube videos, some simple Google formulas and a Google Spreadsheet - thats all you need to quickly create a YouTube playlist. It will be an anonymous playlist, not connected to your YouTube channel, and may be a good way to bunch together multiplevideos for easy sharing on WhatsApp, Twitter or an email newsletter.
Make YouTube Playlists with Google Sheets
To get started, open this Google Sheet and put the URLs [links] of YouTube videos in column A [one video per cell, starting with Cell A3]. As you paste the video links in cell A, the column B getspopulated with the video ID while column C will include a video thumbnail. This helps you double-check that the video URL is actually pointing to the intended video.
After you are done writing the video URLs, go to cell A1 [see tutorial] and youll find a link to your YouTube playlist ready for sharing with the world. If you add or remove videos from column A, the playlist link will be updated automatically. Simple. You can share the Google sheet with other people and collaborate together to build a YouTube playlist.
//twitter.com/labnol/status/783566790286639104
YouTube Playlist Generator - How It Works?
When you paste the video URL in column A, the REGEXTRACTformulauses the following regex to extract the ID of the YouTube video.
Once video ID is available, the IMAGE formula is used to create the video thumbnail for that YouTube video.
Now comes the most interesting part - generating the YouTube playlist. Well, thats a simple URL hack where we concatenate the video IDs with the JOIN[] method and make a live link using the HYPERLINK[] method. `
Also see:How to Copy YouTubePlaylists
TheseYouTube playlists, generated on-the-fly, arenot saved in your Google account. You can also build a permanent YouTube playlist where multiple people can collaborate with a Google Form and Google Scripts. Check out this project written by Martin Hawksey. Thank you Tor Halvor Solheim for the idea.