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
Prospect Profile: Mariners SP Justus Sheffield
Breaking down a recent start by Seattle Mariners SP prospect Justus Sheffield, currently with the Triple-A Tacoma Rainiers.
Early team HR leader Stewart (quad) goes on IL
The Tigers have placed outfielder Christin Stewart on the 10-day injured list with a right quad strain.
Sabathia: Yankees just want to have fun after every win
Max Kellerman hates the Yankees celebrating with strobe lights after beating the Red Sox, while CC Sabathia embraces his team having fun.
White Sox righty Giolito strains hamstring, on IL
White Sox starter Lucas Giolito has been placed on the 10-day injured list after he strained his hamstring during Wednesday's game.
From 'blimp folder' to Foot Locker: Fake jobs MLB players use to fool fans
Sometimes, you just want to be anonymous. Ballplayers reveal to us the counterfeit careers they've created to conceal their identities away from the diamond.
Fantasy baseball free-agent finds: Rays among top pickups
There are several Tampa Bay Rays who are worth a close look in fantasy baseball leagues. Here are all the top waiver-wire options around the league.