Gameiro came off the bench to secure a 2-2 draw in the second leg at the Petrovsky Stadium on Thursday, which ensured the holders progressed 4-3 on aggregate.
After scoring Sevilla's winner in a 2-1 first leg victory last week, Carlos Bacca found the net again with an early penalty in the second leg to put the La Liga side in command.
Zenit were gifted a way back into the tie when goalkeeper Beto, making his return from injury, inexplicably dropped a cross and Salomon Rondon turned the ball home just after half-time.
Three-time winners Sevilla then lost composure and Zenit capitalised, with Hulk putting them in front on the night in spectacular fashion with a sensational long-range lob to seemingly take the tie into extra time.
Gameiro had the final say five minutes from time, though, firing home with a clinical finish to keep Emery's men on course to retain Europe's secondary club competition.
When asked if he thought extra time was on the cards, Sevilla coach Emery said: "No, I hoped for this goal, I had faith. I had to have faith that we would find the second goal.
"We had to search for the moment. We managed to play the game with the difficulties that we had. We knew that it wasn't going to be easy.
"Sevilla is celebrating this victory and for this we dedicate it to everyone."
'People will remember us because we got to No.1 in the world rankings and achieved great things - but our biggest regret is that we didn’t win anything': Ex-Everton star Kevin Mirallas opens up on 'honour' of being part of nation's golden generation
‘I’m sure we’d have finished in the top four or five if he hadn’t joined Chelsea in January. Him leaving damaged the team, but we couldn’t stand in his way’: Alan Curbishley reflects on failed Champions League dream after selling key player
