A couple of YouTube videos, some simple Google formulas and a Google Spreadsheet – that’s 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 multiple videos 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 gets populated 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 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 will be updated automatically. Simple. You can share the Google sheet with other people and collaborate together to build a YouTube playlist.
Once video ID is available, the IMAGE formula is used to create the video thumbnail for that YouTube video.
=IMAGE(“http://ift.tt/2dso38y;, 4, 80, 120)
Now comes the most interesting part – generating the YouTube playlist. Well, that’s a simple URL hack where we concatenate the video IDs with the JOIN() method and make a live link using the HYPERLINK() method.
These YouTube playlists, generated on-the-fly, are not 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.
Google has a new hardware division and Rick Osterloh, the former Motorola chief, is in charge. This hardware division merges Google's disparate hardware projects to bring more cohesive products that work well together.
Google announced a lot of products today and all of them are made by Google. Nexus phones have been replaced by Pixel phones, Daydream View is a comfortable VR headset that works with Pixel phones, Google Home brings Google Assistant to a smart speaker, Google WiFi is a new router that promises better range and Chromecast Ultra supports 4K and has an Ethernet port. That's quite a lot.
Pixel phones are actually made by HTC, but there's no HTC branding. Pixel and Pixel XL are designed by Google and HTC is only the OEM. The two phones share the same premium hardware (aluminum/glass unibody, Snapdragon 821, 4GB RAM, 32/128GB of storage, AMOLED screens, 12MP camera with OIS), but have different screen sizes (5 inch vs 5.5 inch), resolutions (1920 x 1080 vs 2560 x 1440) and batteries (2770 mAh vs 3450 mAh). They have an impressive camera that scores 89 in the DxOMark Mobile test, which is the highest score for a mobile phone. The camera has a fast f/2.0 lens, hybrid autofocus powered by laser detection and phase detection, zero lag HDR+, powerful stabilization.
Pixel and Pixel XL ship with Android Nougat and they're the first phones that come with Google Assistant, the upgraded voice assistant with a more natural voice, more comprehensive answers and better integration with other services.
"Pixel is available for pre-order today starting at $649 in the U.S., U.K., Canada, Germany and Australia," mentions Google. Pixel XL costs $120 more, while the 128GB options adds $100 to the price, exactly like the iPhone. Google partnered with a few carriers: Verizon, Roger/Telus/Bell in Canada, EE in the UK, Deutsche Telekom in Germany, Telstra in Australia, as well as a few stores like Best Buy and Flipkart.
Daydream View brings virtual reality to everyone (who has a Daydream compatible phone). "Powered by Android 7.0 Nougat, Daydream-ready phones are built with high-resolution displays, powerful mobile processors and high-fidelity sensors—all tuned to support great VR experiences. Google’s newest Pixel and Pixel XL are the first Daydream-ready phones, and there are a lot more on the way from leading Android smartphone makers," informs Google. Daydream View is a VR headset and controller that costs $79 and it's comfortable and easy to use. For now, it's mainly a Google Pixel accessory and it will be available in November in the US, Canada, Germany, UK and Australia from the Google Store and all the other carriers and stores that sell Google's phones.
Google Home is a smart wireless speaker with integrated Google Assistant, powerful microphones and noise cancelling technology. It's always listening to "OK Google" (you can quickly disable this feature from the mute button), it has touch controls, far-field voice recognition, Hi-Fi speakers, multi-room support if you buy multiple devices. It also has customizable bases you can buy from the Google Store. Google Home is a clever voice interface for Google, but also for your other smart devices like Chromecast, Nest, Philips Hue and more. IFTTT will make Google Home automation even more powerful.
"Google Home will be available in stores starting in November or you can pre-order yours today for $129 from the Google Store, Best Buy, Target and Walmart," informs Google.
After launching OnHub routers manufactured by TP-Link and Asus, Google came up with its own simplified WiFi router. It's designed to cover a small house or an apartment and you can use multiple Google routers for a larger house. "Network Assist is intelligent software built into Google Wifi to provide you with the fastest possible speed. Behind the scenes, Network Assist automatically helps you avoid Wi-Fi congestion, and transitions you to the closest Wi-Fi point for the best signal." Google's new router has a mobile app that lets you quickly change settings and check stats. For example, you can pause Wi-Fi on a device or prioritize a device.
"Google Wifi will be available for pre-order in the U.S. in November. It will retail for $129 for a single pack, and $299 for a three-pack at the Google Store, Amazon, Best Buy and Walmart."
Chromecast Ultra brings 4K and HDR support, a more powerful hardware and a different charger with Ethernet port. "Chromecast Ultra supports 4K, HDR and Dolby Vision, so you'll get a crisper picture with higher resolution and more vibrant colors. At first, you'll be able to stream 4K content from Netflix, YouTube and Vudu, and we're working to bring more 4K and HDR content on board. Later this year, Google Play Movies & TV will be rolling out 4K content. Chromecast Ultra loads videos 1.8 times faster than other Chromecast devices and includes major Wi-Fi improvements to support streams from full HD to Ultra HD without a hitch," explains Google. "Chromecast Ultra will be available in November for $69 from Best Buy, the Google Store, Target, and Walmart in the U.S., as well as from international retailers in 15 more countries."
