Ulenza kanjani uhlu lwadlalwayo lwe-YouTube usebenzisa i-Google Spreadsheet
Dala kalula Uhlu lwadlalwayo lwe-YouTube Esebenzisa I-Google Spreadsheet Ngomhlahlandlela olula nolula ozokusiza ukuthi udale kalula iqoqo lemidiya oyikhonzile ngokuchofoza okukodwa. Ngakho landela umhlahlandlela ongezansi ukuze uqhubeke.
Uma uku-inthanethi ngakho-ke ngokuqinisekile uke wasebenzisa i-YouTube futhi futhi uma ujwayele ukusebenzisa i-youtube khona-ke kukhona umsebenzi owodwa we-youtube ongakha ngawo uhlu lwakho lwadlalwayo ukuze amavidiyo akho owathandayo agcinwe kuwo. Manje ukulungisa uhlu lwadlalwayo lwe-youtube kungaba lula kakhulu, vele udlule kwezinye izinketho ku-akhawunti yakho bese uzenzela olwakho uhlu lokudlalayo. Kodwa kuthiwani uma ufuna ukuyidala nge-Google AmaSpredishithi? Lokhu kungase kuzwakale kuwubuwula ngoba i-Google AmaSpredishithi iwuhlobo oluhluke ngokuphelele lohlelo lwekhompyutha olungahlanganise lutho ne-youtube, kodwa ukulinda kungenziwa ngempela. Lapha kulesi sihloko, sixoxe ngendlela eyingqayizivele ongakha ngayo uhlu lwadlalwayo lwe-YouTube usebenzisa Uhlu lwadlalwayo lwe-Google! Vele ufunde yonke indatshana ukuze ufunde ngale ndlela. Indlela ezosebenza nokuhlelwa kwe-URL iyinhlanganisela elula yama-URL futhi ungakwazi ukudala kalula futhi usebenzise izinhla zokudlalayo ozifunayo ngokuqondile ku-Google Spreadsheet. Ngakho bheka umhlahlandlela ophelele okuxoxwe ngawo ngezansi ukuze uqhubeke.
Ulwakha kanjani uhlu lwadlalwayo lwe-YouTube nge-Google Spreadsheet
Ngezansi umhlahlandlela ophelele wesinyathelo ngesinyathelo okudingeka uwulandele ozokusiza ukuthi udale uhlu lwadlalwayo lwe-youtube usebenzisa i-Google Spreadsheet. Ngakho bheka izinyathelo ezingezansi.
Izinyathelo Zokudala Uhlu Lwadlalwayo Lwe-YouTube Usebenzisa I-Google Spreadsheet:
1. Okokuqala, vula uhlelo lokusebenza lwesipredishithi kukhompyutha yakho bese udala isipredishithi esisha ku-Google bese ufaka i-URL yevidiyo ye-youtube oyifunayo kukholomu A (ividiyo eyodwa ngeseli ngayinye bese uqala ngekholomu A3 yeshidi ). ngemva kokungena I-URL yevidiyo Kuseli A, ikholomu B izobonisa i-ID yevidiyo futhi ikholomu C izokubonisa isithonjana sevidiyo.
2. Manje faka kumaseli i-URL yevidiyo yamavidiyo owafunayo futhi ongathanda ukuwabonisa ohlwini lwakho lwadlalwayo lwe-youtube bese uzobona ukuthi uhlu lwadlalwayo olusha lwe-youtube luzobuyekezwa ku-akhawunti. Ungakwazi ukwabelana ngespredishithi sakho se-Google nama-URL kunoma ubani ukuze ajoyine ngokuhlanganyela uhlu lwakho lwadlalwayo.
3. Manje mhlawumbe ucabanga ukuthi lokhu kungenzeka kanjani? Indaba ukuthi ifomula yespredishithi i-REGEXTRACT isetshenziswa ukukhipha umazisi wevidiyo ye-youtube ku-url oyinamathisele kumaseli bese kuthi uma ubunikazi bevidiyo butholakala kusetshenziswa amafomethi wesithombe ukuze kutholwe isithonjana sevidiyo.
REGEXTRACT Formula: =REGEXTRACT(A3,”yotu(?:.*VvVI *v=I.beVI.*?embedV)([A-Za-z0-9_\-]{11})”)
Ifomula Yesithombe: +IMAGE(“https://i3.ytimg.com/vi/”&B3&”/hqdefault.jpg”,4, 80, 120)
4. Okokugcina, amafomula adala kufikela ohlwini lwadlalwayo lwe-YouTube futhi enze isixhumanisi esiqondile ne-YouTube:
+HYPERLINK(“https://www.youtube.com/watch_videos?video_ids=”&join(“,”,B3:B);”Isixhumanisi”)
Qaphela: Amavidiyo e-YouTube owafaka ohlwini lwakho lwadlalwayo ngeke avunyelaniswe ku-akhawunti yakho ye-Google ngokusebenzisa i-Google AmaSpredishithi, ngakho udinga ukuwabuyekeza ngokwakho uma ufuna ukuvumelanisa izifunzo zamavidiyo abukhoma kusipredishithi sakho.
Manje usuqedile ukuthi ungadala kanjani uhlu lwadlalwayo lwe-youtube usebenzisa i-Google Spreadsheet. Nokho, le nto ingase ibonakale ingavamile kuwe futhi ungase ungakholelwa kukho konke, kodwa iqiniso liwukuthi ungakwenza. Ukuze uqiniseke ngale ndlela, kufanele uzame ukuyisebenzisa ngokwakho futhi udale uhlu lwadlalwayo lwe-youtube usebenzisa i-Google AmaSpredishithi. Ngithemba ukuthi uyawuthanda umhlahlandlela, wabelane ngawo nabanye futhi ushiye amazwana ngezansi uma unemibuzo ehlobene nalokhu, ithimba le-techviral lizohlala likhona ukukusiza ngezinkinga zakho.
