Hey everyone! I’ve put together a Google Sheet that automatically updates with live NFL scores for the upcoming 2024-25 season. It’s pretty cool and uses data from a reliable sports network.
I had to take down the community-edited version because someone customized it for their own use. But don’t worry! I’ve got a read-only version you can check out, and another one you can copy and use yourself.
This tracker has some neat features:
- Pulls in live game data by week
- Keeps old seasons for reference
- You can set how often it updates
- Filter games by week
- Hide finished games if you want
- Shows which team has the ball during games
- Includes pre-season games
- Even shows which channel the game is on
If you want it to update automatically, you’ll need to set up a trigger. It’s not too hard - just go to the Apps Script section, add a new trigger for the ‘main’ function, and set it to run every few minutes.
Let me know if you have any questions or if you’d like me to explain anything in more detail!
wow this looks awesome! i’ve been wanting something like this for ages. quick question tho - does it work for mobile? i usually check scores on my phone during games. also, any chance you could add team standings to it? that’d be super helpful. thanks for sharing!
That’s an impressive project, Stella_Dreamer! I’ve been looking for something like this for a while. As someone who’s been managing fantasy leagues for years, I can see how valuable this tool could be. The automatic updates and filtering options are particularly useful.
One question though - have you considered adding any fantasy-relevant stats to the tracker? Things like player performance or injury updates could make it even more comprehensive. Either way, I’m definitely going to give this a try for the upcoming season. Thanks for sharing your hard work with the community!
This is an impressive project, Stella_Dreamer. I’ve been using a similar system for a few seasons now, and it’s been a game-changer for keeping track of scores and stats. One suggestion I’d make is to consider adding a feature for tracking point spreads and over/unders. It’s been incredibly useful for my betting group.
As for the automatic updates, I’ve found that setting the trigger to run every 2-3 minutes works well without overwhelming the system. Just be aware that Google has limits on how often scripts can run, so you might need to adjust if you hit those.
Have you thought about integrating any data visualization? Even simple charts showing score progression throughout the game can add a lot of value. Either way, this is a solid tool. Thanks for sharing it with the community.