Hello, Is there a way inside the Glide data editor (not in GS) to automatically generate the thumbnail URL from a Youtube link, perhaps using the template and generate URL columns? i.e. I want to automatically turn [Learn To Play Kenny Garrett Happy People - Insta Jamm] into [image] …

You could probably create a basic text column, but don’t fill it with anything. So an empty column. Then create a template column that’s pointed to the url column and replaces any parts that don’t contain the video id with the empty column. The end result should be the id that can be used to buil…

Sure. Assuming you know the YouTubeID then you can create 2x template columns as follows: URL for the video: https://www.youtube.com/embed/{YTID} URL for the thumbnail: https://img.youtube.com/vi/{YTID}/0.jpg In both cases {YTID} is the YouTube ID. Hope that helps

You can use a template column replacing the video_id [image] Youtube thumbnails Feature Requests You can get a thumbnail for any YouTube video given the video ID: https://img.youtube.com/vi/VIDEO_ID/0.jpg Using the Template column, you could derive Video and Thumbnail…

Same question with a twist – if you have the video ID, how can you get at the: video duration description number of views I see in reading around the topic that you need a YouTube API key (I got that setup) which you do NOT need for the image thumbnail or the RSS feed). I would like to get at th…

You can try this. [image] Using Sheets and the YouTube API to track video analytics A walkthrough of setting up Sheets and Apps Script code to monitor the stats of a series of YouTube videos.

I’m aware of this. But as I mentioned in my original post I need to do it from the Youtube link. To be clear, the Video ID is not given. The crux of the issue is being able to extract that ID from the Youtube link inside the Glide data table.

[image] Jamm_Studios_Doha: The crux of the issue is being able to extract that ID from the Youtube link inside the Glide data table. It might be possible, but I can almost guarantee you that it won’t be pretty. Without any string manipulation functions in the GDE, any solution that succeeds …

Okay, thanks for your input! If it doesn’t make sense to achieve it in Glide then GS would be fine. I wanted to know if it was possible/easy. Could you point me to a thread, or let me know yourself if you can, of the simplest array formula that can achieve this? Thanks again!

Maybe this… [image] Using Regex in Glide with ARRAYFORMULA + YouTube thumbnails Ask for Help Just wanted to share a little tip since Glide doesn’t yet have regular expression matching, and probably a lot of people would like to generate YouTube thumbnails easily for use i…

In Google Sheets, Copy this formula to get the ID. =ARRAYFORMULA(IF(LEN(A2:A)=0, MID(A2:A,33,11))) A2:A is the youtube URL column. I’m fetching statistics of 300 Videos daily via apps script. Also, I’ve set a trigger that is running every 3 hours. It can fetch Thumbnails, Title, Description, to…

Auto-generate Youtube thumbnail URL

Ask for Help

Jamm_Studios_Doha March 29, 2021, 9:44am 6

I don’t have the Youtube ID, I have the URL.

So the solution I’m looking needs to be able to extract that prior to any of those steps.

Topic		Replies	Views
Youtube thumbnails Feature Requests	11	1483	February 18, 2021
Using Regex in Glide with ARRAYFORMULA + YouTube thumbnails Ask for Help	0	823	December 1, 2020
Importing YouTube Thumbnails, User ID, Title, Description and Views Ask for Help	3	676	November 9, 2020
Image of link question Feature Requests	18	631	April 23, 2020
Glide pages questions Ask for Help	4	668	July 17, 2022

Auto-generate Youtube thumbnail URL

Related topics