Warm it up first, I have one of those needles (full of chassis grease) and they want to shoot off. Might tape it on or something.
Also, those guns are are designed to work with the tube. Might use some rolled aluminum foil to create a seal.
I like the way you are thinking. Not sure this is your winner, but innovative.