Fishing Reel Mechanics

How would i make an object (the spool) move forwards and backwards after another object (the spooler) completes 2 rotations. Im not bothered about a cable actualy spooling just yet, but i cant work out how to transform the location with a sine wave.

Dose anyone know a good way of doing this ?