Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula to receive youtube thumbnail from video ID

Topic Labels: Formulas
5480 3
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