The camshaft sprocket in a motorcycle is a gear attached to the camshaft, which is driven by the timing chain. It ensures the precise timing of the camshaft's rotation, controlling the opening and closing of the engine's valves in synchronization with the piston's movement, crucial for efficient engine operation.