"RPC" Impossible" error Extracting Phone numbers from websites via google doc list of url's

[jmauget]

Step by step instructions followed here:

How to Scrape Phone Numbers from Websites Using Google Sheets and Bardeen

Jaakko Hyttinen asked on Slack: Hey everyone! I am pretty new to the Barden but can already see a lot of use cases for it. Now I have faced a problem though: I have a Google Sheets on Drive with links to the sites where I would like the Barden to collect the phonenumber, but since I am such a rookie I dont know how to build this could someone give me a hint or two? We exchanged some messages and the it was solved here is how you can do it too. Steps to Scrape Phone Numbers …

My case:
Error popup: "RPC Impossible. Please ensure to run this command from a web page (not new tab, or extension page).

Questions:

1. The url’s are embedded hyperlinks in the google doc sheet - could this break “Get page as html”?
2. The urls require login. I am logged in with the same browser and a manual click from google doc successfully opens page. Bardeen process get a firewall page - anyway around this?

[ivan]

Hi @jmauget

Can you share the automation link you tried for this use-case? As well as the error ?

This will help us investigate the issues.

Also, what pages are you trying to scrape? Can you share some of these URLs?

1. The url’s are embedded hyperlinks in the google doc sheet - could this break “Get page as html”?

That’s a posibility!

You can use the “find all links in text” after “Get table from Google Sheets” to make sure you’re getting the links from the link column.

Bardeen process get a firewall page - anyway around this?

No, unfortunately we don’t have a way to bypass this.

Do you have any screenshots on how this looks like?

[Artem_from_Bardeen]

Hey @jmauget ,

You can’t extract links directly from a Google doc, however, if you put the links into a sheet, then it should be possible to do with three actions:

Get Table From Sheet → Get Page as HTML → Convert HTML to Text → Find Phone Numbers in

In fact, I just tried entering the following prompt into our Magic Box (the same box you use to search for playbooks) "Get URLs from google sheet, load the page and extract phone numbers from the page text " and it came up with a really interesting alternative solution that can also work (see https://bardeen.ai/s/fU8mAylNYXts):

As long as your browser is logged in to those sites it should work.

[ivan]

To recap on our finding:

If you’re running into a RPC error:

The RPC error happens when someone tries to run a scraper on a Chrome tab, or on a page where scraping is not possible.

Therefore is not a Bardeen error, and can be fixed on the way you’re running your scraper automation.