Yes, the tent cloth should be thoroughly dry before impregnating it with Sprayhood & Tent Protector.
Sprayhood & Tent Protector is a strong, water-soluble impregnating agent. Thus, it cannot penetrate the cloth where it is still wet.
The water eventually evaporates, leaving the active formula behind. So ensure the tent cloth is saturated with the impregnating agent.