Home > Back-end >  how to scrap one of the rates in this website using google sheets' importxml formula?
how to scrap one of the rates in this website using google sheets' importxml formula?

Time:08-14

I want to get the rate of the euro from this website: bonbast.com. I tried this formula:

IMPORTXML("https://www.bonbast.com/","//tr[@id='eur1']")

but nothing imported. What is wrong with it?

CodePudding user response:

As mentioned in JaSON's comment, the IMPORTXML function cannot read dynamic values generated after the page loads. It's just meant to read static pages.

The website bonbast.com seems to have an API so you can use that to retrieve the data, though it's a paid service.

By default Sheets is not really equipped to scrape dynamic websites. You're better off looking for another site that has static data, look for some kind of extension or add-on that does the work for you or learn more advanced scraping approaches.

  • Related