How would look like a 1 formula that uses IMPORTXML to scrape the dates, team names and extended match scores from the league page? For example, in order to scrape the extended score of the match Bydgoszcz - Gornik Walbrzych , it's need to enter the match tab and get the date value, team names and extended score data, which are after “Final result”.
Similarly, the data are taken from the other matches, a sample of what it should get in the end made in the example file.
File link: #gid=0
How would look like a 1 formula that uses IMPORTXML to scrape the dates, team names and extended match scores from the league page? For example, in order to scrape the extended score of the match Bydgoszcz - Gornik Walbrzych , it's need to enter the match tab and get the date value, team names and extended score data, which are after “Final result”.
Similarly, the data are taken from the other matches, a sample of what it should get in the end made in the example file.
File link: https://docs.google/spreadsheets/d/1Imc097FCkd0T4Mu2OjY--B8a6EfGjBs5SqDG4uOMbCk/edit?gid=0#gid=0
Share Improve this question asked Jan 30 at 10:08 TheGunner4TheGunner4 656 bronze badges1 Answer
Reset to default 1Scraping Dynamic sites using Google Sheets
I had a similar case and I did the same experiment that I did for the past post and determined that the website that you are using is rendered dynamically and thus making it not possible to be scraped using Google Sheets alone. Kindly visit the post below for more information and possible work around.
How to pull data from a website using Apps Script
To prove that the site is indeed a dynamic site, I turned off Javascript on my browser and confirmed that the contents of the website in concern are dynamically rendered as when I turn off Javascript, the contents did not load at all, See images below.
References: Disable JavaScript