Video Component

Ask for Help
4

Here is a workaround to display video thumbnail in list/tile component:

  • setup your sheet to take the info you want to display in the tile e.g. a column for video name and youtube url.
  • then add column to extract the youtube video code from the url and apply the formula to the entire column. The formula looks like this: =ArrayFormula(iferror(REGEXEXTRACT(B2:B, “youtu(?:.*/v/|.v=|.be/|.?embed/)([A-Za-z0-9_-]{11})”), “”))
  • then add column to extract a thumbnail from the youtube video code and again, apply the formula to the entire column. The formula looks like this: =ArrayFormula(if(C2:C = “”, “”, IMAGE(REPLACE(“https://i3.ytimg.com/vi/IMG/hqdefault.jpg”,25,3,C2:C), 4, 80, 120)))
  • then add column to extract a url to the thumbnail, apply the formula to the entire column: =ArrayFormula(if(C2:C = “”, “”, (REPLACE(“https://i3.ytimg.com/vi/IMG/hqdefault.jpg”,25,3,C2:C))))
  • you might want to hide the first row of each column that contains the formula.
  • you can now keep adding youtube video links to new rows and the formulas will automatically generate a thumbnail you can point your tile component to, which then link to the video url.

Example:

Hope this helps.

1 Like