48.8 F
New York
Wednesday, April 21, 2021

-

Home News How to pull contact details from a website using only Google Sheets

How to pull contact details from a website using only Google Sheets

Document Analysis NLP IA

291
WORDS

WORDS
1:27
Reading Time

Reading Time
positive
sentiment

Sentiment0.10233333333333
subjective
redaction

Subjectivity0.5035293040293
probably it's an affirmation
Affirmation0.35169491525424

Highlights

RELEVANT
FREQ, RAKE or TFIDF
Entity
ORG
Entity
PERSON
Entity
PRODUCT
Entity
OTHER
Key Concepts (and relevance score)

Summary (IA Generated)

And do you find it an annoying and unnecessarily time-consuming task to sort through ever-changing web designs, to find that one button or bit of information you’re actually looking for? To obtain very specific bits of that HTML, Google Sheets uses a structured data format called XML and a related query language called XPath.

Such a formula in Google Sheets is built up as follows: =IMPORTXML(url, xpath_query).

There are many XPath cheat sheets and tutorials available on the web that can help you craft the right queries.

To show you what’s possible, we’ve used these (and some other) formulas to create a nifty little Google Sheets template.


131FansLike
3FollowersFollow
16FollowersFollow