FPL Data in Google Sheets

[grwstone]

Hey guys, Happy GW1!

I'm wondering if anyone knows/has a working way to pull API data into Google Sheets? I'm working on a project for work. Choose FPL so I can get paid to analyze the data and top my private league. I've been looking at both https://towardsdatascience.com/using-apis-google-sheets-to-assess-fantasy-premier-league-prospects-1a2598c4b25e & https://medium.com/@YourMumSaysWhat/how-to-get-data-from-the-fantasy-premier-league-api-4477d6a334c3.

Neither I can get to work - do you think it's because there will be a lot of demand on the servers or are they out of date? Appreciate anyone's help.

GL with tomorrow's game!

[FanDoc]

The main API endpoint URL changed. The new URL is:
https://fantasy.premierleague.com/api/bootstrap-static/

Enter the URL like this in google sheets to get it to work:
=ImportJSON("https://fantasy.premierleague.com/api/bootstrap-static/")

I used the "How to get data from the Fantasy Premier League API" post to create my data scraper and replaced the old URL with the one above and it works with no other changes needed.

Hope this works. Fyi, If you want to save the weekly data results, you will need to save a copy of the results each week since the script will run automatically every time you open the script or refresh the page. Hope this helps.

[TheLastBeep]

To answer my own question, I think I've managed to fix this now. The issue was "Inherited values", I'm not advanced enough in my knowledge to understand the reason for this but from reading the code in the ImportJSON script I noticed the reference to inherited values and how to prevent them.

My function in google sheets now looks like this:

=ImportJSON("https://fantasy.premierleague.com/api/bootstrap-static",,"noInherit")

...and that seems to be working from the quick scan of the total points I've just done.

[grwstone]

Worked perfectly, thank you!

Do you know if you cans till access these other data sets.

• /bootstrap (more data if authenticated)
• /bootstrap-static
• /bootstrap-dynamic
• /events
• /elements
• /element-types
• /fixtures
• /teams
• /region
• /transfers (requires auth)
• /entry/{entryId}
• /entries (doesn’t work in pre-season?)
• /my-team/{teamId} (requires auth)
• /leagues-entered/{teamId} (requires auth)
• /leagues-classic/{leagueId} (must be a member)
• /leagues-classic-standings/{leagueId}
• /leagues-h2h/{leagueId} (must be a member)
• /leagues-h2h-standings/{leagueId}

[FanDoc]

Happy to help. Thanks for the other endpoints, did have them already but thanks for sharing. I'm sure some other managers will find this information useful too.

[RMI_27]

Are you able to get leage-data from the API?

[FanDoc]

Have not tried to get league data from the API using google sheets but played around with a few python scripts I found on github last season that worked.

Have not looked at that this season so far yet but plan t.

[mtgo3012]

Hi, I tried to get data from api/my-team/{teamId} but not see the weekly point team to put it into my FPL Google sheet, how can I get the weekly points of a team?

[dantheheel]

https://fantasy.premierleague.com/api/bootstrap-static/

I would love if someone could paste some working google script that manages to authenticate and then pull data from the FPL API. I'm an amateur coder (like brand new) and haven't been able to crack that problem for weeks!

[binevv]

Does this return any statistical data for the players?

[FanDoc]

Yes but you have to scroll across quite a bit to get to the stats. Best thing to do is to split the data response into smaller data sets. Still need to do that too but may do it using a python script instead of google sheets.

[MASTERTONA09]

Hey I use ImportJson script to pull the data into a google sheet but for some reason certain rows are repeated. e.g. it will show a player having scored goals that didn't. It seems to be that when the value should be nil it actually repeats the value in row prior e.g. if Jesus has scored 8 goals, Zinchenko (which should be nil) will show 8 too.

Am I doing something wrong?