The singer wanted to put his weight behind a dinner hosted by our columnist Tam Cowan.
Rod has now donated a VIP night at one of his gigs at the Hydro, Glasgow, on November 29 and December 3.
Two tickets, which will include meeting Rod, will be auctioned at Airdrie Working Men’s Club on June 22.
It is understood online bids have already topped £500.
Goram revealed to the Record last month that he had been diagnosed with terminal oesophageal cancer after thinking he had indigestion.
The ex-Ibrox goalkeeper said doctors told him he had six months to live, which was later cut to six weeks.
Sir Rod got in touch after Tam joked about his off-key performance last week at the Platinum Jubilee party.
Tam said: “Rod had a giggle about my column. He said he was hoarse because he was recovering from Covid.
“It’s amazing that he that has put up a meet and greet for Andy.”
Ex-Celt Frank McAvennie and other Old Firm legends are expected at the event.
Goram was last week moved to St Andrew’s Hospice in Airdrie after radiotherapy.
Sir Rod Stewart given the go-ahead to cut trees to save mansion from collapse
Sir Rod Stewart has been given the go-ahead to cut back trees in the grounds of his mansion to save them from collapse.
Two beeches at the singer’s property are decaying after being infected by fungus and are at risk of falling down.
The First Cut is the Deepest singer’s representatives submitted a planning application to reduce the height of the trees at Grade II-listed Durrington House in Harlow, Essex, to reduce the risk of collapse.
It has been approved by Epping Forest District Council after no objections were received.
Tree surgeons will chop 8ft off a fern-leaved beech tree and 6ft from the other beech.
Sir Rod is consulting a company in Holland which specialises in saving ancient trees. It uses steel braces to keep decaying trees standing.
Don’t miss the latest news from around Scotland and beyond – Sign up to our daily newsletter here .