What oil should I use on my tufting gun?

Any lubricating oil is appropriate.

Sewing machine oil and WD40 are the most commonly used lubricating oils.