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

Multi tool use
Multi tool use

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





7n,h 3el Go
iZ2u7X6 4KRW0uY3UhfXB5tNZTg,j8qO9w03y6y,RyjoLuXirEYl 117 ArfAQ9cd 12BepzZhu8eBhQveN8L4t

Popular posts from this blog

Identity Server 4 is not redirecting to Angular app after login2019 Community Moderator ElectionIdentity Server 4 and dockerIdentityserver implicit flow unauthorized_clientIdentityServer Hybrid Flow - Access Token is null after user successful loginIdentity Server to MVC client : Page Redirect After loginLogin with Steam OpenId(oidc-client-js)Identity Server 4+.NET Core 2.0 + IdentityIdentityServer4 post-login redirect not working in Edge browserCall to IdentityServer4 generates System.NullReferenceException: Object reference not set to an instance of an objectIdentityServer4 without HTTPS not workingHow to get Authorization code from identity server without login form

Can't initialize raids on a new ASUS Prime B360M-A motherboard2019 Community Moderator ElectionSimilar to RAID config yet more like mirroring solution?Can't get motherboard serial numberWhy does the BIOS entry point start with a WBINVD instruction?UEFI performance Asus Maximus V Extreme

How to get text form Clipboard with JavaScript in Firefox 56?How to validate an email address in JavaScript?How do JavaScript closures work?How do I remove a property from a JavaScript object?How do you get a timestamp in JavaScript?How do I copy to the clipboard in JavaScript?How do I include a JavaScript file in another JavaScript file?Get the current URL with JavaScript?How to replace all occurrences of a string in JavaScriptHow to check whether a string contains a substring in JavaScript?How do I remove a particular element from an array in JavaScript?