A couple of YouTube videos, some easy Google formulas and a Google spreadsheet – that’s all you would like to quickly create a YouTube playlist. it’ll be an anonymous playlist, not connected to your YouTube channel, and will be an honest way to bunch together multiple videos for simple sharing on WhatsApp, Twitter or an email newsletter.

Make YouTube Playlists with Google Sheets

How to Make YouTube Playlists with a Google Spreadsheet

To get started, open this Google Sheet and place the URLs (links) of YouTube videos in column A (one video per cell, beginning with Cell A3). As you paste the video links in cell A, the column B gets populated with the video ID whereas column C can include a video thumbnail. This helps you double-check that the video URL is truly pointing to the intended video.

After you’re done writing the video URLs, visit cell A1 and you’ll 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 are updated automatically. Simple. you’ll share the Google sheet with other people and collaborate along to build a YouTube playlist.

YouTube Playlist Generator – How It Works?

When you paste the video URL in column A, the REGEXTRACT formula uses the following regex to extract the ID of the YouTube video.

=REGEXEXTRACT(A3, “youtu(?:.*\/v\/|.*v\=|\.be\/|.*?embed\/)([A-Za-z0-9_\-]{11})”)

Once video ID is available, the IMAGE formula is used to create the video thumbnail for that YouTube video.

=IMAGE(“https://i3.ytimg.com/vi/”&B3&”/hqdefault.jpg”, 4, 80, 120)

Now comes the foremost interesting part – generating the YouTube playlist. Well, that’s an easy URL hack wherever we concatenate the video IDs with the JOIN() method and make a live link using the HYPERLINK() method.

=HYPERLINK(“https://www.youtube.com/watch_videos?video_ids=”&join(“,”,B3:B);”Link”)

These YouTube playlists, generated on-the-fly, aren’t saved in your Google account. will|you’ll|you’ll be able to} conjointly build a permanent YouTube playlist where multiple people can collaborate with a Google form and Google Scripts.