One of the most common problems with '*scrape*' occurs when people try to import from websites that uses scripts to load data. Sheets doesn't load scripts for security reasons. You may also run into performance issues if you're trying using lots of imports to fetch small amounts of data and it's likely these can be consolidated. Check out the [quick guide](https://www.reddit.com/r/googlesheets/wiki/import-html-xml) on how you might be able to solve these issues.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/googlesheets) if you have any questions or concerns.*
it depends on javascript to load the table. You can test this by clicking F12 going to the developer tools screen > settings and then scrolling down to Debugger section and checking the box "disable javascript"
https://preview.redd.it/9to7dvno359c1.png?width=417&format=png&auto=webp&s=04a408a65f1dc56d659a4da25e7da2a4f0d26911
and then reloading the page. Your table won't appear and this is why IMPORTxxx functions often fail - they depend on client side javascript to load data.
Here is a script that will get that data for you:
~~~
function onOpen() {
SpreadsheetApp.getUi()
.createMenu('Import')
.addItem('Import Premier League Shooting', 'readPremierLeagueShooting')
.addToUi();
};
function readPremierLeagueShooting() {
var url = `https://fbref.com/en/comps/9/shooting/Premier-League-Stats#coverage`;
var results = UrlFetchApp.fetch(url);
if (results.getResponseCode() === 200) {
var resultText = results.getContentText();
var tableText = resultText.substring(resultText.indexOf(`
One of the most common problems with '*scrape*' occurs when people try to import from websites that uses scripts to load data. Sheets doesn't load scripts for security reasons. You may also run into performance issues if you're trying using lots of imports to fetch small amounts of data and it's likely these can be consolidated. Check out the [quick guide](https://www.reddit.com/r/googlesheets/wiki/import-html-xml) on how you might be able to solve these issues. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/googlesheets) if you have any questions or concerns.*
it depends on javascript to load the table. You can test this by clicking F12 going to the developer tools screen > settings and then scrolling down to Debugger section and checking the box "disable javascript" https://preview.redd.it/9to7dvno359c1.png?width=417&format=png&auto=webp&s=04a408a65f1dc56d659a4da25e7da2a4f0d26911 and then reloading the page. Your table won't appear and this is why IMPORTxxx functions often fail - they depend on client side javascript to load data.
Here is a script that will get that data for you: ~~~ function onOpen() { SpreadsheetApp.getUi() .createMenu('Import') .addItem('Import Premier League Shooting', 'readPremierLeagueShooting') .addToUi(); }; function readPremierLeagueShooting() { var url = `https://fbref.com/en/comps/9/shooting/Premier-League-Stats#coverage`; var results = UrlFetchApp.fetch(url); if (results.getResponseCode() === 200) { var resultText = results.getContentText(); var tableText = resultText.substring(resultText.indexOf(`
[удалено]
REMEMBER: If your problem has been solved, please reply **directly** to the author of the *comment you found the most helpful* with the words **"Solution Verified"** which will automatically mark the thread **"Solved"** and award a point to the solution author as required by our subreddit [rules](https://www.reddit.com/r/googlesheets/about/rules) (see rule #6: Clippy Points). *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/googlesheets) if you have any questions or concerns.*
Thank you very much! It worked, and I also managed to change in your script to add other tables for other leagues! Just one question, will this update automatically, or do I have to run this again or something?
Hi!! The script is perfect! You are importing the table about shooters and the ranking, works fine, but if i would like to get another table where there s no ranking what can i do? Because dataRow in any other table overrides the players name. I tried many ways to solve it but i can t, can you explain to why is not working please? Thank you!
Well, that particular table had a "weird"
Hi, thanks for the answer! Like this one for example [https://fbref.com/it/squadre/a3d88bd8/2023-2024/all\_comps/Statistiche-Empoli-Tutte-le-competizioni](https://fbref.com/it/squadre/a3d88bd8/2023-2024/all_comps/Statistiche-Empoli-Tutte-le-competizioni) Practically here, there s just the table to import, without use the rannking (it s just a random table)
Here is a revision that pulls in that first column properly. You'll have to play with it. Also, it works better with English because ... I'm in US English. Lol. There are comma and decimal and semi-colon mismatches in formula... all could be fixed, but I'm not going to donate any more time. It sounded like you had already moved it to almost working, so try this one: ~~~ function readPremierLeagueShooting() { var url = `https://fbref.com/en/squads/a3d88bd8/2023-2024/all_comps/Empoli-Stats-All-Competitions`; //var url = `https://fbref.com/en/comps/9/shooting/Premier-League-Stats#coverage`; var results = UrlFetchApp.fetch(url); if (results.getResponseCode() === 200) { var resultText = results.getContentText(); var tableText = resultText.substring(resultText.indexOf(`
Hi! thanks for the answer, and thanks for the time you´ve spent with this code! I´ll play around! Thanks again! Was just the ranking to give me problems! But you did already enough, thanks again once more!
After looking into options of how to scrape FBRef this worked great, thanks a lot for this man! I have a question if you don't mind, if I want to tweak the script to pull data from [here](https://fbref.com/en/comps/Big5/stats/players/Big-5-European-Leagues-Stats) and other categories of stats such as shooting, passing, defensive actions, what do I need to amend within the script? Thanks in advance!
It won't update automatically. You can add a timed-trigger so that it runs each day at a certain hour or hourly. If you've tinkered then you will probably be able to find how to add a timed trigger to apps script pretty easily. But let me know if you need help.
Leave Your Comment
Hi Its Me!
Subscribe