We determine the algebraic and transcendental lattices of a general cubic fourfold with a symplectic automorphism of prime order. We prove that cubic fourfolds admitting a symplectic automorphism of order at least three are rational, and we exhibit two families of rational cubic fourfolds that are not equivariantly rational with respect to their group of automorphisms. As an application, we determine the cohomological action of symplectic birational transformations of manifolds of OG10 type that are induced by prime order symplectic automorphisms of cubic fourfolds.