Web Scraping Google Sheets Script

Question

I'm trying to input data based on column "A" into column "B". If "A" is a comprehensive list of website urls, would it be possible to run a script that scrapes the phone numbers, for example, from these websites and inputs into column "B"?

I am 100% newbie to scripting, but would love to learn how this works.

Yaakov Bressler · Accepted Answer · 2020-04-23 22:00:42Z

2

Assuming each cell in Column A is one url, you definitely can scrape for phone numbers.

The code to achieve this:

Extract the webpage's text (assuming the phone number isn't structured as a link or something else).
Search that text for phone numbers using regex.

B2: =JOIN("|",IMPORTXML(A2,"//a/@href"))
C2: =REGEXEXTRACT(B2,"[0-9]{3}[- ]*[0-9]{3}[- ]*[0-9]{4}")

answered Apr 23, 2020 at 22:00

Yaakov Bressler

12.7k5 gold badges66 silver badges96 bronze badges

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

2 Comments

Maggie Moore Over a year ago

thank you for the response! IMPORTXML doesn't pull any of the content of the page, and won't let me then search for the phone number in C2.

Yaakov Bressler Over a year ago

What's the URL you're using? (It could have some protection against bots...)

Collectives™ on Stack Overflow

Web Scraping Google Sheets Script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related