How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets? [closed]Scrape YouTube Channel ID in to Google Sheets?Import cell value from google sheets to website?Automate the Import Function from Google SheetsTrying to paste a lowest price from G2A onto google sheetsImport multiple ranges from one Google Sheet into anotherImporting editable HTML into Google SheetsHow to connect google sheet with power bi?Importing multiple CSV files to google sheets with Google ScriptImport Amazon product Price and Title into Google SheetsImport Score from myanimelist.net into google sheetsGoogle Sheets YouTube Link and Name

Where in the Bible does the greeting ("Dominus Vobiscum") used at Mass come from?

Why does John Bercow say “unlock” after reading out the results of a vote?

Student evaluations of teaching assistants

Is a roofing delivery truck likely to crack my driveway slab?

How do I define a right arrow with bar in LaTeX?

Lay out the Carpet

What would happen if the UK refused to take part in EU Parliamentary elections?

Applicability of Single Responsibility Principle

The baby cries all morning

apt-get update is failing in debian

Tiptoe or tiphoof? Adjusting words to better fit fantasy races

when is out of tune ok?

Was the picture area of a CRT a parallelogram (instead of a true rectangle)?

Why "be dealt cards" rather than "be dealing cards"?

Implement the Thanos sorting algorithm

is this a spam?

What is the oldest known work of fiction?

Are there any comparative studies done between Ashtavakra Gita and Buddhim?

There is only s̶i̶x̶t̶y one place he can be

Hide Select Output from T-SQL

Is there a good way to store credentials outside of a password manager?

What't the meaning of this extra silence?

Opposite of a diet

Teaching indefinite integrals that require special-casing



How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets? [closed]


Scrape YouTube Channel ID in to Google Sheets?Import cell value from google sheets to website?Automate the Import Function from Google SheetsTrying to paste a lowest price from G2A onto google sheetsImport multiple ranges from one Google Sheet into anotherImporting editable HTML into Google SheetsHow to connect google sheet with power bi?Importing multiple CSV files to google sheets with Google ScriptImport Amazon product Price and Title into Google SheetsImport Score from myanimelist.net into google sheetsGoogle Sheets YouTube Link and Name













-1















How would I import YouTube likes and dislikes from a video onto Google Sheets?










share|improve this question















closed as too broad by tehhowch, arnt, Andy Brown, thewaywewere, Mark Rotteveel Mar 8 at 16:44


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


















  • This is much too broad of a question. stackoverflow.com/help/how-to-ask

    – tehhowch
    Mar 8 at 13:56















-1















How would I import YouTube likes and dislikes from a video onto Google Sheets?










share|improve this question















closed as too broad by tehhowch, arnt, Andy Brown, thewaywewere, Mark Rotteveel Mar 8 at 16:44


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


















  • This is much too broad of a question. stackoverflow.com/help/how-to-ask

    – tehhowch
    Mar 8 at 13:56













-1












-1








-1








How would I import YouTube likes and dislikes from a video onto Google Sheets?










share|improve this question
















How would I import YouTube likes and dislikes from a video onto Google Sheets?







google-sheets google-sheets-importxml






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Mar 8 at 13:55









player0

1




1










asked Mar 8 at 9:35









DuckDujDuckDuj

146




146




closed as too broad by tehhowch, arnt, Andy Brown, thewaywewere, Mark Rotteveel Mar 8 at 16:44


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.









closed as too broad by tehhowch, arnt, Andy Brown, thewaywewere, Mark Rotteveel Mar 8 at 16:44


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.














  • This is much too broad of a question. stackoverflow.com/help/how-to-ask

    – tehhowch
    Mar 8 at 13:56

















  • This is much too broad of a question. stackoverflow.com/help/how-to-ask

    – tehhowch
    Mar 8 at 13:56
















This is much too broad of a question. stackoverflow.com/help/how-to-ask

– tehhowch
Mar 8 at 13:56





This is much too broad of a question. stackoverflow.com/help/how-to-ask

– tehhowch
Mar 8 at 13:56












1 Answer
1






active

oldest

votes


















0














TITLE:



=IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","//*[@id='eow-title']")


VIEWS:



=VALUE(REGEXREPLACE(TEXT(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo",
"//*[contains(@class, 'watch-view-count')]"),0)," view(s)?",""))


DURATION:



=SUBSTITUTE(REGEXREPLACE(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","//*[@itemprop='duration']/@content"),"PT|S",""),"M",":")


LIKES:



=IF(ISNA(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-like-button')])[1]"))=TRUE,0,
IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-like-button')])[1]"))


DISLIKES:



=IF(ISNA(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-dislike-button')])[1]"))=TRUE,0,
IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-dislike-button')])[1]"))


UPLOADED:



=REGEXREPLACE(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo",
"//*[contains(@class, 'watch-time-text')]"),"((Uploaded)|(Published)|(Streamed live)) on ","")


SUBSCRIPTIONS:



=IFERROR(MID(QUERY(IMPORTXML("https://www.youtube.com/channel/"&A1,
"//div[@class='primary-header-actions']"), "select Col1"), 31, 20), )


6



CHANNEL NAME:



=INDEX(IMPORTHTML("https://www.youtube.com/channel/UC7_gcs09iThXybpVgjHZ_7g","list",1),1,1)


CHANNEL ID:



=ARRAYFORMULA(REGEXREPLACE(QUERY(SUBSTITUTE(ARRAY_CONSTRAIN(
IMPORTDATA(https://www.youtube.com/watch?v=rckrnYw5sOA), 3000, 1), """", ""),
"where Col1 contains '<meta itemprop=channelId content='"),
"<meta itemprop=channelId content=|>", ""))





share|improve this answer

























  • Awesome, would you be able to get the number of comments too

    – DuckDuj
    Mar 8 at 14:45

















1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









0














TITLE:



=IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","//*[@id='eow-title']")


VIEWS:



=VALUE(REGEXREPLACE(TEXT(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo",
"//*[contains(@class, 'watch-view-count')]"),0)," view(s)?",""))


DURATION:



=SUBSTITUTE(REGEXREPLACE(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","//*[@itemprop='duration']/@content"),"PT|S",""),"M",":")


LIKES:



=IF(ISNA(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-like-button')])[1]"))=TRUE,0,
IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-like-button')])[1]"))


DISLIKES:



=IF(ISNA(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-dislike-button')])[1]"))=TRUE,0,
IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-dislike-button')])[1]"))


UPLOADED:



=REGEXREPLACE(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo",
"//*[contains(@class, 'watch-time-text')]"),"((Uploaded)|(Published)|(Streamed live)) on ","")


SUBSCRIPTIONS:



=IFERROR(MID(QUERY(IMPORTXML("https://www.youtube.com/channel/"&A1,
"//div[@class='primary-header-actions']"), "select Col1"), 31, 20), )


6



CHANNEL NAME:



=INDEX(IMPORTHTML("https://www.youtube.com/channel/UC7_gcs09iThXybpVgjHZ_7g","list",1),1,1)


CHANNEL ID:



=ARRAYFORMULA(REGEXREPLACE(QUERY(SUBSTITUTE(ARRAY_CONSTRAIN(
IMPORTDATA(https://www.youtube.com/watch?v=rckrnYw5sOA), 3000, 1), """", ""),
"where Col1 contains '<meta itemprop=channelId content='"),
"<meta itemprop=channelId content=|>", ""))





share|improve this answer

























  • Awesome, would you be able to get the number of comments too

    – DuckDuj
    Mar 8 at 14:45















0














TITLE:



=IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","//*[@id='eow-title']")


VIEWS:



=VALUE(REGEXREPLACE(TEXT(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo",
"//*[contains(@class, 'watch-view-count')]"),0)," view(s)?",""))


DURATION:



=SUBSTITUTE(REGEXREPLACE(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","//*[@itemprop='duration']/@content"),"PT|S",""),"M",":")


LIKES:



=IF(ISNA(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-like-button')])[1]"))=TRUE,0,
IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-like-button')])[1]"))


DISLIKES:



=IF(ISNA(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-dislike-button')])[1]"))=TRUE,0,
IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-dislike-button')])[1]"))


UPLOADED:



=REGEXREPLACE(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo",
"//*[contains(@class, 'watch-time-text')]"),"((Uploaded)|(Published)|(Streamed live)) on ","")


SUBSCRIPTIONS:



=IFERROR(MID(QUERY(IMPORTXML("https://www.youtube.com/channel/"&A1,
"//div[@class='primary-header-actions']"), "select Col1"), 31, 20), )


6



CHANNEL NAME:



=INDEX(IMPORTHTML("https://www.youtube.com/channel/UC7_gcs09iThXybpVgjHZ_7g","list",1),1,1)


CHANNEL ID:



=ARRAYFORMULA(REGEXREPLACE(QUERY(SUBSTITUTE(ARRAY_CONSTRAIN(
IMPORTDATA(https://www.youtube.com/watch?v=rckrnYw5sOA), 3000, 1), """", ""),
"where Col1 contains '<meta itemprop=channelId content='"),
"<meta itemprop=channelId content=|>", ""))





share|improve this answer

























  • Awesome, would you be able to get the number of comments too

    – DuckDuj
    Mar 8 at 14:45













0












0








0







TITLE:



=IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","//*[@id='eow-title']")


VIEWS:



=VALUE(REGEXREPLACE(TEXT(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo",
"//*[contains(@class, 'watch-view-count')]"),0)," view(s)?",""))


DURATION:



=SUBSTITUTE(REGEXREPLACE(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","//*[@itemprop='duration']/@content"),"PT|S",""),"M",":")


LIKES:



=IF(ISNA(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-like-button')])[1]"))=TRUE,0,
IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-like-button')])[1]"))


DISLIKES:



=IF(ISNA(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-dislike-button')])[1]"))=TRUE,0,
IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-dislike-button')])[1]"))


UPLOADED:



=REGEXREPLACE(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo",
"//*[contains(@class, 'watch-time-text')]"),"((Uploaded)|(Published)|(Streamed live)) on ","")


SUBSCRIPTIONS:



=IFERROR(MID(QUERY(IMPORTXML("https://www.youtube.com/channel/"&A1,
"//div[@class='primary-header-actions']"), "select Col1"), 31, 20), )


6



CHANNEL NAME:



=INDEX(IMPORTHTML("https://www.youtube.com/channel/UC7_gcs09iThXybpVgjHZ_7g","list",1),1,1)


CHANNEL ID:



=ARRAYFORMULA(REGEXREPLACE(QUERY(SUBSTITUTE(ARRAY_CONSTRAIN(
IMPORTDATA(https://www.youtube.com/watch?v=rckrnYw5sOA), 3000, 1), """", ""),
"where Col1 contains '<meta itemprop=channelId content='"),
"<meta itemprop=channelId content=|>", ""))





share|improve this answer















TITLE:



=IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","//*[@id='eow-title']")


VIEWS:



=VALUE(REGEXREPLACE(TEXT(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo",
"//*[contains(@class, 'watch-view-count')]"),0)," view(s)?",""))


DURATION:



=SUBSTITUTE(REGEXREPLACE(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","//*[@itemprop='duration']/@content"),"PT|S",""),"M",":")


LIKES:



=IF(ISNA(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-like-button')])[1]"))=TRUE,0,
IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-like-button')])[1]"))


DISLIKES:



=IF(ISNA(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-dislike-button')])[1]"))=TRUE,0,
IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo","(//*[contains(@class,'like-button-renderer-dislike-button')])[1]"))


UPLOADED:



=REGEXREPLACE(IMPORTXML("https://www.youtube.com/watch?v=MkgR0SxmMKo",
"//*[contains(@class, 'watch-time-text')]"),"((Uploaded)|(Published)|(Streamed live)) on ","")


SUBSCRIPTIONS:



=IFERROR(MID(QUERY(IMPORTXML("https://www.youtube.com/channel/"&A1,
"//div[@class='primary-header-actions']"), "select Col1"), 31, 20), )


6



CHANNEL NAME:



=INDEX(IMPORTHTML("https://www.youtube.com/channel/UC7_gcs09iThXybpVgjHZ_7g","list",1),1,1)


CHANNEL ID:



=ARRAYFORMULA(REGEXREPLACE(QUERY(SUBSTITUTE(ARRAY_CONSTRAIN(
IMPORTDATA(https://www.youtube.com/watch?v=rckrnYw5sOA), 3000, 1), """", ""),
"where Col1 contains '<meta itemprop=channelId content='"),
"<meta itemprop=channelId content=|>", ""))






share|improve this answer














share|improve this answer



share|improve this answer








edited Mar 18 at 12:36

























answered Mar 8 at 13:53









player0player0

1




1












  • Awesome, would you be able to get the number of comments too

    – DuckDuj
    Mar 8 at 14:45

















  • Awesome, would you be able to get the number of comments too

    – DuckDuj
    Mar 8 at 14:45
















Awesome, would you be able to get the number of comments too

– DuckDuj
Mar 8 at 14:45





Awesome, would you be able to get the number of comments too

– DuckDuj
Mar 8 at 14:45





Popular posts from this blog

Can't find variable: document ReactNative Js2019 Community Moderator ElectionReactNative: how to center text?Can't find variable: navigate - ReactNative navigationReact Native error: “Can't find variable: TouchableHighlight”How to use Expo.DocumentPicker.getDocumentAsync properly. [Expo] [ReactNative]Can't find variable: regeneratorRuntime (ReactNative)Reactnative Expo It is advisable for a StartUp?Can't find variable : Self / Can't install firebaseNPM Install Error in installing ReactNative CLIContacts Displaying in App using ReactnativeFacebook login error: can't find variable: Alert

Thal And Out Agency railway station See also References External links Navigation menuOfficial Web Site of Pakistan RailwaysArchivedOfficial Web Site of Pakistan Railwayseeexpanding ite

Posting a File and Associated Data to a RESTful WebService preferably as JSON2019 Community Moderator ElectionREST URI convention - Singular or plural name of resource while creating itUploading both data and files in one form using Ajax?How do I upload a file with metadata using a REST web service?REST API - file (ie images) processing - best practicesSpring: JSON data and file in the same requestREST API Put large dataPosting a file and JSON data to Spring rest serviceRESTful Web Service Upload/Download Large Data With JSONREST API Design sending JSON data and a file to the api in same requestPost JSONArray to REST servicePUT vs. POST in RESTParsing values from a JSON file?JavaScript/jQuery to download file via POST with JSON dataHow do I upload a file with metadata using a REST web service?How to POST JSON data with Curl from Terminal/Commandline to Test Spring REST?Separate REST JSON API server and client?what's the correct way to send a file from REST web service to client?How do I write JSON data to a file?What is “406-Not Acceptable Response” in HTTP?REST API - file (ie images) processing - best practices