Free FPL Google Apps Script
25/26 FPL Player Tracker Google Sheet Script
I have made a Google App script which I am sharing with all my subscribers, that you can use to track FPL players using official data from the FPL API. With the user interface and design of the new official app and website being terrible, having a tool like this to do most of your analysis is a game changer. I have put effort into making sure it’s easy to setup, and easy to use. Below are the features.
Features:
Imports all FPL player, team, and fixture data directly from the official FPL API.
Creates and updates a “Players” sheet with sortable stats/filters, including:
Position, Price, Total Points, Minutes, Goals, Assists, Clean Sheets, Goals Conceded, Penalties Saved, Yellow Cards, Red Cards, Saves, Bonus, BPS, Starts, DefC, Form, Ownership %, Status, Chance, xG, xA, xGI, xGC, Influence, Creativity, Threat, ICT Index, InfR, InfRT, CrR, CrRT, ThR, ThRT, ICTR, ICTRT, Points/Game, PP90, PP90/Cost, Weighted Score, Transfers In, Transfers Out, Notes*, News
* The notes column is your personal notes you keep on a player. These don’t get overwritten when the sheet is updated.
Adds checkboxes to track specific players.
Creates tracked player sheets by position (GK, DEF, MID, FWD).
Player photos (auto-fetched from the Premier League site) for tracked players.
Automatic clean formatting, alternate row shading. I have setup the formatting with usably in mind, and this is built into the script, so you don’t have to do any formatting.
Updates and formats a Teams sheet with all clubs, stats, and goal difference, points etc
Updates and formats a Fixtures sheet with all upcoming matches and difficulty ratings.
Updates and formats a Game Weeks sheet with all FPL deadlines and scores.
Generates a Fixture Difficulty “ticker” for all teams, color-coded by fixture difficulty.
All sheets have:
Dark theme, alternate row shading, auto column width, frozen header row, and hidden unused columns.
Menu for one-click updates:
Refresh Players, Refresh Tracked Players, Update Teams, Fixtures, Game Weeks, Fixture Difficulty, Full Refresh.
6-hour auto-update trigger (optional). One time set up at the start, so you will always be looking at fresh data without having to manually trigger updates from the menu.
Here’s a demo version of the sheet. Note that it’s ready only, so you can’t sort and filter the data or create notes or see the custom menu.….this is where the real value is, so make sure you install the full Google Apps Script in your own Google sheet to get full control of the data. I promise it’s easy to install and comes with an install guide.
How do you get it?
You just need to subscribe to my Substack below. I have put the download link to the free script in the welcome email. I will update the script and add new features if it’s popular, so make sure you stayed subscribed to receive updates. If you are a subscriber from before when I added the link to my welcome email, drop me a message on Substack and I will send you the link.