I'm not clear what you want, but think of it as switching ON when the pin goes LOW. You will need a transistor to switch the motor on and off, but we can't tell you which one until you tell us
- the voltage ("I think it's 12V" isn't precise enough!), and
- the current drawn by the motor.
Both of these should be marked on the drill.