Momwe Mungapangire Sewero la YouTube Pogwiritsa Ntchito Google Spreadsheet
Pangani mosavuta YouTube Playlist Pogwiritsa Ntchito Google Spreadsheet Ndi kalozera wosavuta komanso wosavuta womwe ungakuthandizeni kupanga mndandanda wazomwe mumakonda pakudina kamodzi. Choncho tsatirani kalozera pansipa kuti mupitirize.
Ngati muli pa intaneti ndiye kuti mwagwiritsanso ntchito YouTube ndipo ngati mumakonda kugwiritsa ntchito youtube ndiye kuti pali ntchito imodzi ya YouTube yomwe mungapange kupanga playlist yanu kuti mumaikonda mavidiyo asungidwe momwemo. Tsopano kukonza playlist youtube kungakhale kophweka, ingodutsani zina mu akaunti yanu ndiyeno pangani playlist yanu. Koma bwanji ngati mukufuna kupanga ndi Google Mapepala? Izi zitha kumveka zopusa chifukwa Google Mapepala ndi mtundu wosiyana kwambiri wamapulogalamu apakompyuta omwe alibe chochita ndi youtube, koma dikirani kuti zitha kuchitika. Pano m'nkhaniyi, takambirana njira yapadera imene mungathe kulenga YouTube playlist ntchito Google Playlist! Ingowerengani nkhani yonseyi kuti mudziwe za njirayi. Njira yomwe ingagwire ntchito ndi zosintha za ulalo ndizosavuta kuphatikiza ma URL ndipo mutha kupanga mosavuta ndikugwiritsa ntchito mndandanda wamasewera omwe mukufuna kuchokera ku Google Spreadsheet. Chifukwa chake yang'anani kalozera wathunthu womwe wafotokozedwa pansipa kuti mupitilize.
Momwe Mungapangire Mndandanda Wosewerera pa YouTube Ndi Google Spreadsheet
M'munsimu ndi wathunthu sitepe ndi sitepe kalozera kuti muyenera kutsatira zimene zingakuthandizeni kulenga YouTube playlist ntchito Google Spreadsheet. Choncho yang'anani njira pansipa.
Njira Zopangira YouTube Playlist Pogwiritsa Ntchito Google Spreadsheet:
1. Choyamba, tsegulani pulogalamu ya spreadsheet pa kompyuta yanu ndikupanga spreadsheet yatsopano mu Google ndiyeno ikani ulalo wa kanema wa youtube womwe mukufuna mu gawo A (kanema imodzi pa selo ndikuyamba ndi gawo A3 la pepala ). atalowa Ulalo wamakanema Ku cell A, gawo B liwonetsa ID ya kanema ndipo gawo C likuwonetsani chithunzithunzi cha kanemayo.
2. Tsopano ikani m'maselo kanema ulalo wa mavidiyo mukufuna ndi zimene mukufuna kusonyeza wanu YouTube playlist ndiye mudzaona kuti latsopano YouTube playlist adzakhala kusinthidwa kwa nkhani. Mutha kugawana nawo Google Spreadsheet ndi ma URL kwa aliyense kuti agwirizane nawo pamndandanda wanu.
3. Tsopano mwina mukuganiza momwe izi zingachitikire? Chowonadi ndichakuti fomula ya spreadsheet REGEXTRACT imagwiritsidwa ntchito pochotsa id ya kanema ya youtube mu ulalo womwe mudayika m'maselo ndiyeno id ya kanema ikapezeka mawonekedwe azithunzi amayikidwa kuti apeze chithunzithunzi cha kanemayo.
REGEXTRACT Fomula: =REGEXTRACT(A3,”yotu(?:.*VvVI *v=I.beVI.*?embedV)([A-Za-z0-9_\-]{11})”)
Kapangidwe ka Zithunzi: +IMAGE(“https://i3.ytimg.com/vi/”&B3&”/hqdefault.jpg”,4, 80, 120)
4. Pomaliza, mafomu omwe amapanga mndandanda wazosewerera wa YouTube komanso kupanga ulalo wachindunji ndi Youtube:
+HYPERLINK(“https://www.youtube.com/watch_videos?video_ids=”&join(“,”,B3:B);”Ulalo”)
Zindikirani: Makanema a YouTube omwe mumayika pamndandanda wanu sangasinthidwe ku akaunti yanu ya Google pogwiritsa ntchito Mapepala a Google, chifukwa chake muyenera kuwasintha pamanja ngati mukufuna kulunzanitsa mavidiyo amoyo pamasamba anu.
Tsopano mwachita ndi momwe mungathere kulenga YouTube playlist ntchito Google Spreadsheet. Komabe, chinthu ichi chikhoza kuwoneka chachilendo kwa inu ndipo simungakhulupirire zonse, koma chowonadi ndi chakuti mukhoza kuchita. Kuti mutsimikize njirayo, muyenera kuyesa kuigwiritsa ntchito nokha ndikupanga playlist ya YouTube kudzera pa Google Mapepala. Ndikukhulupirira kuti mumakonda kalozera, gawananinso ndi ena ndikusiya ndemanga pansipa ngati muli ndi mafunso okhudzana ndi izi, gulu la techviral lidzakhalapo kukuthandizani pamavuto anu.
