So I would guess making a composition for lets say 90 seconds. Because a soccer match is 90 minutes, so every second in after effects comp is a minute from the data.
And then somehow linking the data file that a text or precomp is shown at a specific time.
For example in the spreadsheet we see the first GOAL scored at 04:51. So in the comp at 4 seconds the text goal would be shown.
Or have a precomp/text on each second and have it turn on/off (opacity) incase something happens on that specific second in the json.
to answer the question short, YES, you can indeed.
Some thing to consider:
1. In example video, the data-set is super 'friendly' I shall say, because goals/events happens with good amount of time gaps in between. What would happen if a lot of events takes place in a short timeframe? Such scenarios needs to be treated differently. Especially, when most often its length might be limited for social media types.
2. The approach depends on amount of data you would be using. If its only a goal fact mention, then having home vs away pre-comps would work, if its a simple reveal. However, if animation should be triggered by such even, then more complex expression is required. (especially if times goes one after another).
With that said - it all depends on the approach. Even if you choose 90s as a ballpark, there are more things to be considered.