Sunday, 8 February 2015

ImportXML: Importing multiple videos from YT user's videos tab



What I'm trying to do is to import multiple videos' data from a random YouTube profile.


I want to extract data from here(sample link): http://ift.tt/10bSsPp


I'm using google spreadsheet and simple importxml function, which extracts data from specified DIV.


My current ImportXML string: =importxml($A$1,"//div[@class='yt-lockup-content']")


And it works just fine, but what I get is the "main" page with only 30 latest videos and I want to have 60+ (or at least 50) in my spreadsheet. Unfortunately YouTube works like an endless scrolling site, so the code doesn't change when you click the "Load more" button.


Is there a way to export more than the initial 30 videos using Google Spreadsheet formulas?


Thanks!


No comments:

Post a Comment