Help

Re: Formula to receive youtube thumbnail from video ID

2896 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nikita_Sidorenk
4 - Data Explorer
4 - Data Explorer

Hi!

I’m creating a base of videos from youtube.
I have an attachment column in my base and I want to put there video thumbnail.

All thumbnails have the same link but with different ID.

For example:
Link: https://www.youtube.com/watch?v=pAl9SayLzTE
ID: pAl9SayLzTE
Thumbnail link: https://i.ytimg.com/vi/pAl9SayLzTE/maxresdefault.jpg

Questions:

  1. Is there a formula that will create a link to thumbnail with a known ID from another cell?
    So I need some formula that will insert ID in a template

https://i.ytimg.com/vi/XXXXXXX/maxresdefault.jpg instead of XXXXXXX

01

  1. How can I insert the result of this formula in the Attachment field?

  2. Can I somehow receive other info about a video by the link or video ID? (I understand that is another question and big topic, but maybe you have some useful links to read)

Thanx!

3 Replies 3
Nikita_Sidorenk
4 - Data Explorer
4 - Data Explorer

So, I found myself formula

REPLACE(“https://i.ytimg.com/vi/x/maxresdefault.jpg”, 24, 1, ID)

But know I can’t find a solution for question №2.
How I can use link from the field Link To Thumbnail and insert in the field Attachement?

For #2, check out this amazing extension which does exactly what you need:

For #3, my guess is that you can do this with the YouTube API via a JavaScript using Airtable’s scripting block, but I’m not 100% sure.

mjk200
4 - Data Explorer
4 - Data Explorer

The default thumbnail image for a YouTube video can be obtained using the following URL format:

https://img.youtube.com/vi/ <video_id>/maxresdefault.jpg

Replace <video_id> with the actual ID of the YouTube video.

For example, if the video ID is "ABCDEFGHIJK", the URL for the default thumbnail image would be:

https://img.youtube.com/vi/ABCDEFGHIJK/maxresdefault.jpg 

Further: you can obtain thumbnails direct without any difficulty, use this Youtube Thumbnail Downloader Online HD

Reference: youtube video URL