Parsing Socialblade Information using Xpath and importing it into Google Sheets

Question

I am trying to build a Youtube analysis template to monitor my channel's competition.

I would like to parse certain information from Socialblade, but I have just managed to get the information which has an name. The image below shows the xpath for Number of channel uploads:

However, when I try to get information that doesn't have an associated to it I can't seem to be able to extract that information.

I have tried changing the xpath that Chrome generates automatically but had no success. Here's the original xpath for the Date of creation, which is the information I would like to import into Google Sheets:

When I insert this on Google Sheets I get an error message saying that there is a formula parse error.

How can I retrieve this information from SB's website and import it into Google Sheets?

E.Wiest · Accepted Answer · 2020-04-30 13:43:07Z

2

Just use the appropriate XPath :

=IMPORTXML(A1;"//span[.='User Created']/following-sibling::span")

answered Apr 30, 2020 at 13:43

E.Wiest

5,9152 gold badges9 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

djur Over a year ago

Could you share the code to get the profile picture as well? I have used the following code but while it doesn't result in an erorr it doesn't retrieve the image from the src. =IMPORTXML(D2,"//img[@id='YouTubeUserTopInfoAvatar']") Any idea how to make it work? Thanks!

Aerials Over a year ago

For this you want the src attribute, in your xpath query, that's the image's url. Whith which you can import it into sheets. I've edited my answer to add this example.

E.Wiest Over a year ago

Use =IMAGE(IMPORTXML(A1;"//img[@id='YouTubeUserTopInfoAvatar']/@src")). framapic.org/hyZm7QL3N2h3/JjOH08mAyB5K.PNG

Aerials · Accepted Answer · 2020-05-01 11:35:07Z

1

Perhaps this answer helps.

Also you appear to be concatenating wrong. Use single quotes like so:

=IMPORTXML(D2, "//span[.='User Created']/following-sibling::span")

If you want to get the url of an image, you can do so by fetching the "src" attribute of the image like:

=IMPORTXML("website-url", "//img[@id='image-tag-id']/@attribute-value-you-want")

Where you replace the parameters in the formula with real ones.

Then, if you would like to embed the image into the sheet, use:

=IMAGE(IMPORTXML("profile-url", "//img[@id='YouTubeUserTopInfoAvatar']/@src"))

and replace url with the user's profile url you want.

References:

edited May 1, 2020 at 11:35

answered Apr 30, 2020 at 11:54

Aerials

4,4691 gold badge20 silver badges20 bronze badges

3 Comments

djur Over a year ago

Unfortunately, this seems not to retrieve any results. I still got the same error.

Aerials Over a year ago

Can you share the error, is it parse error, or empty content from the response?

djur Over a year ago

It does seem to work now. I tried yesterday several times but it wouldn't work. Any ideas as to what code to use to retrieve the profile picture? I left a comment in the other response with the issue. Any help would be much appreciated.

Collectives™ on Stack Overflow

Parsing Socialblade Information using Xpath and importing it into Google Sheets

2 Answers 2

3 Comments

and replace url with the user's profile url you want.

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

and replace url with the user's profile url you want.

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related