Using Google Spreadsheets to get all of the data from the FPL API.

1. Open Google Sheets and create a new Script under Tools - Script Editor
2. Rename the file to ImportJSON and save it, then paste in the below file
3. Pastebin link: https://pastebin.com/ai1dc2QN
4. Then put the following Excel query into your google sheet, and tada, the data is yours!
=ImportJSON("https://fantasy.premierleague.com/api/bootstrap-static/")

Show more