https://screenrant.com/the-flash-season-9-red-death-oliver-queen-return/

The origin story of the Red Death in The Flash season 9, episode 3 may explain how Stephen Amell's Green Arrow returns to Barry Allen's life.