Using Google Spreadsheets to get data from the FPL API | Fantasy Premier League Tips & Advice 

Hi Paddy, great video! Would you be able to use this method to analyse private leagues? E.g. get the data for each player's team within the league and then create some insights around who used their chips best, who left the most points on the bench etc?

This is great and got me off to a great start, the issue I found is that something screwy was going on with the data after it was imported. I find the data is correct if I import via power query in excel

This is killer, I've been think'n about starting to use the API to create a team with out my bias. I'm expecting it will end up blow'n me out of my league.

This a great video. I have been searching for a way to get the data using the API. I will use it to create a portfolio project.

Great video. I’ve been looking for something like this for a while. My question is how do I get the teams and their respective fixtures for the season using this data

they don't have bootstrap anymore, you know what to use now?

Hi Paddy, really nice video thank you! Out of curiosity, do you know on which data source the fantasy premier league is based on? is it OPTA? or something else?

How would I extract all the player picks from someone's team ID? And store it in a spreadsheet or db

hey bro, thank you for your video, but the Pastebin link seems like it died. Could you share another link. Thank you

It is really grat! Could you show us more videos about how to implement the data?

love the video but there's something i can't do when i pull a player's history , it do the transfer cost column wrong

Hey Paddy. Did you make any videos on how to model this data, or do you have any content/resource suggestions? Thanks mate! Loved the video btw. Easy enough for a mug like me to get the data into sheets lol.

Could this drag live points from the site and would it update live by itself if you set to update in settings think its every minute ?

Love the vid. Is this possible to do for FPL draft as well?

Great video, thanks man! Quick question; you don't happen to know why the FPL API often has 1's listed in cell's that should be 0's? For example, yellow cards, there are no 0's; every player seems to have been given at least 1 yellow card, even though most players have 0 yellow cards.

Great video, man. I was wondering how I can get data of this PL.

Can you use this data to create an FPL transfer planner? If so, how? Thanks

Thank you

Up the local baseball team ! 💪