Topping their Champions League group for a seventh successive season, Manchester City clawed their way back from two goals down at half-time to secure first place in Group G with one match remaining.
The reigning European champions dozed through the first half, finding themselves punished twice by Openda's lethal finishing,
But some second-half substitutions brought a change of momentum and crucially three goals.
Foden was involved in each, as City move six points clear of Leipzig, who must settle for second spot.
Guardiola's men next turn their attention to a Premier League fixture against Tottenham at the weekend, and they will meet Red Star in their final group game midway through next month.
Meanwhile, Leipzig will aim to follow back-to-back defeats with a win over Heidenheim on Saturday; they face Young Boys in their Group G finale.
Erling Braut Haaland continued his fine goal scoring form and was on target again on Tuesday tonight which saw him increase his UCL tally to five level with Manchester United's striker, Ramus Hojlund who is expected to be in action against Galatasaray today.
Below is the Current UEFA Champions League table after Erling Haaland & Julian Alvarez netted today;