The 26-year-old fell down the pecking order at Brentford after their promotion to the top flight in the summer, although he has made six Premier League appearances this season after getting his chance through injury.
Heckingbottom was initially planning to sign a defender permanently in the January window, before a mid-month about-turn at Bramall Lane saw him forced to instead switch his attentions to the loan market.
And, asked if there is a chance Goode’s move could become a permanent one, Heckingbottom admitted: “It’s something I’ve spoken to Charlie about but it’s out of our control.
“He’s not our player. We’ll see how it goes but he’s looking forward to it. We could have got back up from anywhere but what’s the point? We wanted competition.
“Some clubs wanted to insist their players played or imposed financial penalties if they didn’t, which is no good either. We want that honesty in everything we do.”
Goode, who stands 6ft 5in tall, bounced back from rejection from Fulham as a teenager for being too small to reach the Premier League, via spells in non-league. He was spotted by Scunthorpe United playing for Hendon, and later worked under former Blade Keith Curle before moving to Brentford.