This method requires 2 controllers but you will likely get this through normal play tooFirstly turn on your second controller and press
on it whilst in the main menu to join the game (I set it to quest) now setup a 1v1 exhibition match and once it begins line the second player up behind the ball so that once your main player drives forwards and hits them it pushes them into the ball and in turn the ball into their goal.
Here's a video