CODEWITHSUNDEEP
xmlxpathgoogle-sheetsxml-parsing
GDA
GDA

Reputation: 21

IMPORTXML on Google Sheets formula error

How do I pull the number of followers from the following page using IMPORTXML on google sheets? You can find the number of followers right below the orange "Add to Portfolio" https://seekingalpha.com/symbol/MITT

I have the above url in cell A1, and I'm trying to use the following formula unsuccessfully 

=importxml($A$1,"//div[@class='followers-number']")

Upvotes: 2

Views: 480

Answers (1)

Wicket
Wicket

Reputation: 38160

I searched for the class name, the value and the word followers on the source code returned by the URL but they aren't there. IMPORTXML only can access the source code of the page, not content added programmatically, so IMPORTXML isn't the tool the get the required value.

Related

Upvotes: 0

Related Questions