Sandoval, whose future with the team is uncertain, hit a 3-2 fastball from rookie Phil Maton (3-2). It was his fifth homer in 47 games since returning to San Francisco this summer.
Giants reliever Hunter Strickland (4-3) pitched 1 1/3 scoreless innings.
"On your last game and at home here, you want to win the game, but how we won it, in that kind of fashion, it was a great ballgame," Giants manager Bruce Bochy said.
"For (Sandoval) to hit a home run, to walk it off, I know that's special for him and it was cool to see because he's done a nice job since coming here.
"It brought back good memories, I'm not going to lie."
After the game, San Francisco honored retiring pitcher Matt Cain on his 33rd birthday. Cain made the final appearances of his 13-year career Saturday. Bochy and catcher Buster Posey both spoke, and Bochy also thanked the fans for supporting the Giants through a 64-98 season.
Sandoval, who wants to return to San Francisco next year, made a strong closing argument Sunday.
"I feel excited for that moment, especially when I was running the bases, I wanted to cry," said the 2012 World Series MVP.
"I want to be here for the rest of my career. I want to be like Cain," he added
The Giants lost 23 more games than they did last season in their worst year since 1985, when they lost 100 games.
They finished tied with the Detroit Tigers for the worst record in baseball. The Tigers will get the first overall pick in the 2018 amateur draft under MLB's tiebreaking rules awarding the first pick to the team with a worse record the previous season.
The Padres (71-91) lost for the sixth time in seven games as they concluded their seventh straight losing season with a modest improvement of three more wins than last season.
The Giants hadn't won a series with the Padres since the 2016 All-Star break, losing seven of eight with one series tie over that stretch.
Padres starter Luis Perdomo, who's expected to compete for a spot in the rotation next spring, gave up four runs, seven hits and one walk in seven innings. The 24-year-old right-hander threw a season-high 108 pitches.
Hunter Renfroe was 2 for 4 with a home run. He connected on his 26th homer off Cueto in the third inning.
"I'm looking forward to a little relaxation period and then pick it up in spring training," Renfroe said. "We're hoping to make the playoffs next season, that's our biggest goal."
Giants right fielder Hunter Pence made a diving backhand catch on a ball in the gap, robbing Renfroe of extra bases for the final out in the seventh. Pence left the field to a standing ovation. He came out of the game with an unspecified injury, Bochy said.
Perdomo tripled leading off the fourth inning, his fifth of the year and his second against the Giants. Perdomo scored when Travis Jankowski followed with an infield hit to give the Padres a 4-1 lead.
More AP baseball coverage: https://apnews.com/tag/MLBbaseball
Aaron Judge already has one new, superstar teammate in Giancarlo Stanton. Now he's attempting to woo Orioles shortstop and future free agent Manny Machado to the Yankees.
Actor Jim Caviezel, best known for playing Jesus in "The Passion of the Christ," stood in for Royals bench coach Dale Sveum in the team photo on Wednesday.
John Farrell, who was fired by the Boston Red Sox as their manager last October, has moved on with the Cincinnati Reds, as a scout.
Michael Wilbon and Tony Kornheiser agree that baseball games should be quicker but the new minor league baseball rules undermine the game of baseball.
Right-hander Zack Greinke allowed one hit, no runs and struck out two before leaving the Arizona Diamondbacks' game Wednesday with right groin tightness.
The Marlins say third baseman Martin Prado will begin the season on the disabled list while he recovers from right knee surgery.