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