Real pheromones can have an effect on people who are already emotionally close to you but chances are small that the kind found in a spray will even reach a stranger, much less make them become attracted to you.
Do pheromones really affect human behavior?
The debate over whether pheromones affect human behavior is hardly over, but at least enough evidence has been collected that a consensus has emerged on some effects, such as menstrual synchrony.
Do pheromones make you more attractive?
People who produce an elevated level of pheromones tend to have sex more often, feel more confident and sexually attractive, and can bond with others. High pheromones also make people more sexually attractive to others and therefore encourage more attention and social engagement.