Skip to main content

Formula to receive youtube thumbnail from video ID


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





  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

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?


ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8705 replies
  • June 21, 2020
Nikita_Sidorenk wrote:

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.


  • New Participant
  • 2 replies
  • February 2, 2023

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


Reply