"It was really humbling to have so many people acknowledge what you have done," he said.
"I am extremely humbled by the fact the club have thought highly of me enough to retire my number.
"I never dreamed that would happen. It was something I didn't expect, along with the ovation.
Goodwin, who is based in Australia over the winter, says he is unsure of where his future lies as he believes he still has much more to offer.
"I'm still enjoying my cricket, so I don't want to stop playing," he continued.
"I've got to make some big decisions.
"If I get some offers from other counties, then I've got to make the decision whether I'm going to travel over from Australia again for another couple of years.
"That's what I think I've got in me. I'm still playing all forms of the game and still doing well - this season wasn't so well in four-day cricket but one-day cricket was good. I'll just wait and see."
This page is best viewed in an up-to-date web browser with style sheets (CSS) enabled. While you will be able to view the content of this page in your current browser, you will not be able to get the full visual experience. Please consider upgrading your browser software or enabling style sheets (CSS) if you are able to do so.