Danny Lennon's side are relishing the match against the SPL champions and Goodwin, who began his professional career with the Parkhead club as a kid, wants to overturn a recent run of poor results against the Hoops.
Neil Lennon's side have netted 14 goals in their last six outings against the Buddies. But while what has gone before offers little in the way of encouragement, Goodwin is optimistic that the hard work on the training ground over the past week can pay off.
"We have worked hard to prepare for this and we are not just turning up to get brushed aside as we may have done in the past," he said.
"We want to give a good account of ourselves and be positive. They are very much the in-form team and they have been great in the Champions League as well.
"We know we are huge underdogs but we are looking forward to the game. We are training hard and preparing hard and hopefully we can get a result."
And Goodwin is optimistic that Celtic's injury problems and the fact that the bulk of their squad have had an arduous week on international duty can work in St Mirren's favour.
"I think Scott Brown is struggling with his hip and we all know how important he is to Celtic," explained the former Hamilton Accies midfielder. "I watched them when they were away in Moscow and he was different class.
"He is the heartbeat of their team and hopefully if he is out that can play into our hands, but they do have such strength in depth.
"Neil Lennon is able to call on someone of equal quality to come in.
"I just hope the lads who have been on international duty have had a hard time and difficult flights and might have one eye on Tuesday night's tie in Barcelona."
Goodwin remains confident that St Mirren's aim of finishing in the top six is a realistic one. However, he is well aware that while their return in front of goal is better this season than it was at this point last term, there has been a raft of cheap goals conceded by St Mirren so far.
"Our aim at the start of the season was to make the top six," he said. "It is a difficult league and we are only a win away from getting back into third or fourth position.
"But I do think that this season, second position is going to be up for grabs.
"St Johnstone have shown that if you put a few results together you can move ahead. We'd like to think we can do the same.
"Last season we had one of the best defensive records in the league, but we were struggling to score goals.
"I think we have managed to score in every game this season bar one but we are not quite getting it right at the back so it's about finding a balance.
"We need to be a wee bit more resilient and I come into that category too. I'm a holding midfielder and that's my job."
Getting a result against Celtic would be a massive boost for the Paisley side, but Goodwin is aware that they cannot allow the visitors to get an early goal.
"If we can get the first goal it would make the difference and give us a bit of confidence," he said.
"We are confident that we will get out there and put on a really good show for own supporters."