Pehea e hana ai i kahi papa inoa YouTube me ka hoʻohana ʻana i kahi Google Spreadsheet
Hana maʻalahi Youtube Playlist e hoʻohana ana i ka Google Spreadsheet Me kahi alakaʻi maʻalahi a maʻalahi e kōkua iā ʻoe e hana maʻalahi i kahi hōʻiliʻili o kāu media punahele i hoʻokahi kaomi. No laila e hahai i ke alakaʻi ma lalo nei e hoʻomau.
Inā ʻoe ma ka pūnaewele a laila ʻoiaʻiʻo ua hoʻohana paha ʻoe iā YouTube a inā maʻa ʻoe i ka hoʻohana ʻana iā youtube a laila aia kahi hana o youtube e hiki ai iā ʻoe ke hana i kāu playlist ponoʻī i hiki ke mālama ʻia kāu mau wikiō punahele i loko. I kēia manawa hiki ke maʻalahi ka hoʻonohonoho ʻana i ka playlist youtube, e hele wale i kekahi mau koho i kāu moʻokāki a laila hana i kāu playlist ponoʻī. Akā pehea inā makemake ʻoe e hana me Google Sheets? He naʻaupō paha kēia no ka mea he ʻano polokalamu kamepiula ʻē aʻe ʻo Google Sheets ʻaʻohe mea pili me youtube, akā e kali hiki ke hana maoli ʻia. Ma kēia ʻatikala, ua kūkākūkā mākou i kahi ala kūʻokoʻa e hiki ai iā ʻoe ke hana i kahi playlist Youtube me ka hoʻohana ʻana iā Google Playlist! E heluhelu wale i ke koena o ka ʻatikala e aʻo ai e pili ana i kēia ʻano. ʻO ke ala e hana ai me nā hoʻoponopono URL he hui maʻalahi o nā URL a hiki iā ʻoe ke hana maʻalahi a hoʻohana i nā papa inoa āu e makemake ai mai kāu Google Spreadsheet. No laila e nānā i ke alakaʻi piha i kūkākūkā ʻia ma lalo nei e hoʻomau.
Pehea e hana ai i ka papa inoa YouTube me ka Google Spreadsheet
Ma lalo iho nei ka papa kuhikuhi aʻe i kēlā me kēia ʻanuʻu e pono ai ʻoe e hahai e kōkua iā ʻoe e hana youtube playlist me ka hoʻohana ʻana i ka Google Spreadsheet. No laila e nānā i nā ʻanuʻu ma lalo nei.
Nā ʻanuʻu e hana i ka papa inoa mele Youtube me ka hoʻohana ʻana i ka Google Spreadsheet:
1. ʻO ka mea mua, e wehe i ka app spreadsheet ma kāu kamepiula a hana i kahi pāpalapala hou ma Google a laila e hoʻokomo i ka URL o ka wikiō youtube āu e makemake ai ma ke kolamu A (hoʻokahi wikiō ma ke kelepona a hoʻomaka me ke kolamu A3 o ka pepa). mahope o ke komo ana HKH wikiō I ke kelepona A, e hōʻike ka kolamu B i ka ID wikiō a e hōʻike ke kolamu C iā ʻoe i ka liʻiliʻi o ka wikiō.
2. I kēia manawa e hoʻokomo i loko o nā keena i ka URL wikiō o nā wikiō āu e makemake ai e hōʻike i kāu playlist youtube a laila e ʻike ʻoe e hoʻonui ʻia ka papa inoa youtube hou i ka mooolelo. Hiki iā ʻoe ke kaʻana like i kāu Google Spreadsheet me nā URL i kekahi i hiki iā lākou ke hui pū me kāu playlist.
3. I kēia manawa ke noʻonoʻo nei paha ʻoe pehea e hiki ai kēia? ʻO ka mea, hoʻohana ʻia ka palapala palapala REGEXTRACT e unuhi i ka id wikiō youtube mai ka url āu i hoʻopili ai i loko o nā keena a laila i ka manawa e loaʻa ai ka wikiō id ua noi ʻia nā ʻano kiʻi e ʻimi i ka liʻiliʻi o ke wikiō.
REGEXTRACT Formula: =REGEXTRACT(A3,”yotu(?:.*VvVI *v=I.beVI.*?embedV)([A-Za-z0-9_\-]{11})”)
Huina Kiʻi: +IMAGE(“https://i3.ytimg.com/vi/”&B3&”/hqdefault.jpg”,4, 80, 120)
4. ʻO ka mea hope loa, ʻo nā kumu hoʻohālike e hana ai i kahi papa inoa Youtube a me ka hana ʻana i kahi loulou pololei me Youtube:
+HYPERLINK(“https://www.youtube.com/watch_videos?video_ids=”&join(“,”,B3:B);”Lihoiho”)
'Ōlelo Aʻo: ʻAʻole e hoʻopili ʻia nā wikiō Youtube āu i hoʻokomo ai i kāu moʻokāki Google ma o ka hoʻohana ʻana iā Google Sheets, no laila pono ʻoe e hoʻohou iā lākou me ka lima inā makemake ʻoe e hoʻopaʻa i nā wikiō wikiō ola i kāu pālahalaha.
I kēia manawa ua pau ʻoe me pehea e hiki ai iā ʻoe ke hana maoli i ka playlist YouTube me ka hoʻohana ʻana iā Google Spreadsheet. Eia naʻe, he mea maʻamau paha kēia iā ʻoe a ʻaʻole paha ʻoe e manaʻoʻiʻo i ia mea a pau, akā ʻo ka ʻoiaʻiʻo hiki iā ʻoe ke hana. I mea e maopopo ai i ke ala, pono ʻoe e hoʻāʻo e hoʻokō iā ʻoe iho a hana i kahi papa inoa youtube ma o Google Sheets. Manaʻo wau makemake ʻoe i ke alakaʻi, e kaʻana like me nā poʻe ʻē aʻe a waiho i kahi manaʻo ma lalo inā loaʻa iā ʻoe kekahi mau nīnau e pili ana i kēia, aia mau ka hui techviral e kōkua iā ʻoe i kāu mau pilikia.
