Maitiro ekugadzira YouTube Playlist Uchishandisa Google Spreadsheet
Gadzira zviri nyore Youtube Playlist Uchishandisa Google Spreadsheet Negwara rakapfava uye riri nyore iro rinokubatsira iwe nyore kugadzira muunganidzwa wemidhiya yako yaunofarira nekudzvanya kumwe chete. Saka tevera gwara riri pazasi kuti uenderere mberi.
Kana iwe uri pawebhusaiti saka pamwe wakashandisawo YouTube uye kana wakajaira kushandisa youtube saka pane rimwe basa reyoutube raunogona kugadzira yako yega playlist kuitira kuti ako aunofarira mavhidhiyo anogona kuchengetwa mariri. Ikozvino kugadzirisa youtube playlist kunogona kuve nyore kwazvo, ingopfuura nedzimwe sarudzo muakaundi yako wobva wagadzira yako yekutamba. Asi ko kana iwe uchida kuigadzira neGoogle Sheets? Izvi zvingaite sehupenzi nekuti Google Sheets rudzi rwakasiyana zvachose rwekombuta application iyo isina chekuita neyoutube, asi mirira inogona kuitwa. Pano mune ino chinyorwa, takakurukura yakasarudzika nzira yaunogona kugadzira iyo YouTube playlist uchishandisa Google Playlist! Ingoverenga zvimwe zvese kuti udzidze nezve nzira iyi. Maitiro anozoshanda ne URL edits ari nyore kusanganisa maURL uye unogona kugadzira nyore uye kushandisa playlists aunoda zvakananga kubva kuGoogle Spreadsheet yako. Saka tarisa gwara rakazara rinokurukurwa pazasi kuti uenderere mberi.
Maitiro ekugadzira YouTube Playlist neGoogle Spreadsheet
Pazasi pane yakazara nhanho nhanho gwara raunofanirwa kutevedzera iro richakubatsira iwe kugadzira youtube playlist uchishandisa Google Spreadsheet. Saka tarisa matanho ari pasi apa.
Matanho ekugadzira Youtube Playlist Uchishandisa Google Spreadsheet:
1. Chokutanga pane zvose, vhura purogiramu yespredishiti pakombiyuta yako uye gadzira shanduro itsva muGoogle uye woisa URL yevhidhiyo yeyoutube yaunoda muchikamu A (vhidhiyo imwe pasero uye tanga nekoromo A3 yepepa). mushure mekupinda Vhidhiyo URL Kusero A, koramu B icharatidza vhidhiyo ID uye koramu C inokuratidza pikicha yevhidhiyo.
2. Zvino isa mumasero iyo URL yevhidhiyo yemavhidhiyo aunoda uye ayo aungade kuratidza mune yako youtube playlist ipapo uchaona kuti itsva youtube playlist ichagadziridzwa kuaccount. Iwe unogona ipapo kugovera Google Spreadsheet yako nemaURL kune chero munhu kuti vagone kubatana kujoina yako playlist.
3. Iye zvino unenge uri kufunga kuti izvi zvingaitika sei? Chinhu ndechekuti spreadsheet REGEXTRACT formula inoshandiswa kubvisa iyo youtube vhidhiyo id kubva kune url yawakaisa mumaseru uyezve kana vhidhiyo id yavepo mafomati emifananidzo anoiswa kuti awane chigunwe chevhidhiyo.
REGEXTRACT Formula: =REGEXTRACT(A3,”yotu(?:.*VvVI *v=I.beVI.*?embedV)([A-Za-z0-9_\-]{11})”)
Mufananidzo Formula: +IMAGE(“https://i3.ytimg.com/vi/”&B3&”/hqdefault.jpg”,4, 80, 120)
4. Chekupedzisira, mafomula anogadzira kusvika kuYouTube playlist pamwe nekuita chinongedzo chakananga neYouTube:
+HYPERLINK(“https://www.youtube.com/watch_videos?video_ids=”&join(“,”,B3:B);”Link”)
Ongorora: Mavhidhiyo eYouTube aunoisa mune yako yekutamba haazowirirani neakaundi yako yeGoogle kuburikidza nekushandisa Google Sheets, saka unofanirwa kuagadziridza iwe pachako kana iwe uchida kuyananisa mhenyu vhidhiyo feed muspredishiti rako.
Iye zvino wapedza nemabatiro aungaita youtube playlist uchishandisa Google Spreadsheet. Nekudaro, chinhu ichi chingaite sechisina kujairika kwauri uye ungasatenda mazviri zvese, asi chokwadi ndechekuti unogona kuzviita. Kuti uve nechokwadi cheiyo nzira, iwe unofanirwa kuedza kuishandisa iwe pachako uye kugadzira youtube playlist kuburikidza neGoogle Sheets. Ndinovimba iwe unofarira gwara, rigovane nevamwe uye wosiya mhinduro pazasi kana uine chero mibvunzo ine chekuita neizvi, techviral timu inogara iripo kuti ikubatsire nezvinetso zvako.
