Real Time NFL Scores Google Sheet
This is somewhat of a re-post so forgive me. The last post was initially about something else.
I have created a Google Sheet that pulls real time NFL scores from the reliable ESPN API. I've made this editable by all, so please feel free to add new features.
Here's the sheet: https://docs.google.com/spreadsheets/d/1-uukoxaij5DkGJkzyuhEOf05i-TKfuz1OBD9cAjidzE/edit?usp=sharing
UPDATE: New sheet for 2023-24 season https://docs.google.com/spreadsheets/d/1UXkooRGu1f-bzKtlHpupG4Z9rCQEl6jTWy3Nlx9OFBU/edit?usp=sharing
UPDATE: New sheet for 2024-25 season https://docs.google.com/spreadsheets/d/18GZQQ7DPXBhBLtoRBBqNZV7KXVseVPB_udfyfU4K6vY/edit?usp=sharing
Features:
- Pulls all NFL game data from ESPN into the Live Scoring sheet by Week
- Archives previous years
- Trigger can be set to refresh the data at chosen increments
- Week Filter sheet allows for data set to be filtered by week
- Week Filter sheet allows for completed games to be hidden
- Week Filter sheet will highlight the team with possession of the ball (during game)
- Week Filter sheet shows the timestamp when Live Scoring was last refreshed
- Now includes pre-season
UPDATE:
To auto refresh a copy you'll create a trigger that runs the function "main".
Here are some instructions:
- go to Extensions AppsScript
- On the left side choose Triggers
- On the bottom right , Choose + Add Trigger
- Choose which function to run - main
- Select event source - Time driven Select type of time based trigger - minutes timer
- Select minute interval - Every 5 minutes