-1

I want to scrape data from link below : https://c.8891.com.tw/bmw/3-series-coupe/Summary.html

enter image description here

I tried:

=importhtml("https://c.8891.com.tw/bmw/3-series-coupe/Summary.html","table",0)

and

=importxml("https://c.8891.com.tw/bmw/3-series-coupe/Summary.html","//*[@id='gbox_grid']")

and I also want other year information and this url enter image description here enter image description here

Yang Willy
  • 1
  • 1
    Does this answer your question? [Scraping data to Google Sheets from a website that uses JavaScript](https://stackoverflow.com/questions/74237688/scraping-data-to-google-sheets-from-a-website-that-uses-javascript) – idchi May 19 '23 at 14:44

1 Answers1

0

Data on the page gets loaded via javascript, for the page you're scraping it gets loaded from this url. So you'll either need to use something like puppeteer that opens the page in chromium to scrape the things you want or if you really want to use google sheets you could use the url I wrote to load JSON into it following these steps but that will be only for this page.

idchi
  • 761
  • 1
  • 5
  • 15