-1

I want to import some data from a website to my google sheet. I’m most interested in the first section “Totals”. I have tried typing this in my google sheet: =IMPORTHTML(“BC Copenhagen-Teamstats - Basketligaen 2”,"table", 1) But the number 2, seems to be a problem, Idk why thought.

I have also experimented with this: =IMPORTXML(“https://basketligaen.dk/bc-copenhagen-teamstats/“,”//*[@id=‘hs-container’]/div/div/div/div/div[2]”) However, it can’t find the data

Should I maybe use a service like Make or Zapier? However, I'm not sure how.

Website: BC Copenhagen-Teamstats - Basketligaen

Rubén
  • 34,714
  • 9
  • 70
  • 166
Alexander Rubino
  • 9
  • 3

1 Answers1

1

Google sheets' IMPORTXML does not support the scraping of JavaScript elements:

Stephen Ostermiller
  • 23,933
  • 14
  • 88
  • 109
player0
  • 124,011
  • 12
  • 67
  • 124