How to make http request to YouTube API from Google Sheets?

E

elleremo2014-11-22 14:47:40

Google

elleremo, 2014-11-22 14:47:40

I don’t know how to code, but I found a way to put the number of views from any video on YouTube into a google spreadsheet.
Function IMPORTDATA(link) < and put in the link gdata.youtube.com/feeds/api/videos ..Channel ID...
The function returns the idea of CSV , but in reality it's just text (Xml), from which you can extract the necessary information by means google tables. The problem is that in 80% of cases this text either does not fit or spreads to neighboring cells. Who faced, tell me if there is a solution.
And another question, is it possible to extract the desired line from this xml using the ImportXML(link; request_xpath) function ? In place of x_path, I inserted the option that the Chrome console panel offers., But to no avail

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

K

kuzy4ka, 2015-05-18
@kuzy4ka

Keep my friend working method habrahabr.ru/info/agreement/?back_link=http%3A%2F%...
I broke my head on the network with this)