Using ImportXML in Google Sheets

user_10531430 0
Viewed 45

I'm trying to get the number of users for Chrome extensions

Here's an example one:

https://chrome.google.com/webstore/detail/tabby-cat/mefhakmgclhhfbdadeojlkbllmecialg?hl=en

Here's what I have in my Google Sheets cells:

A1:

https://chrome.google.com/webstore/detail/tabby-cat/mefhakmgclhhfbdadeojlkbllmecialg

A2:

=IMPORTXML(A1, "/html/body/div[3]/div[2]/div/div/div[2]/div[1]/div/span[2]/span[4]/text()")

But I keep getting #N/A in A1 for some reason.

What a I doing wrong with the xpath?

web-scraping google-sheets xpath
1 Answers

try:

=QUERY(FLATTEN(IMPORTXML(A1, "//*")), 
 "where Col1 ends with '+ users' offset 5")

enter image description here

user_56326290
Related