As you can see, here are pictures of ways I've done this. The gold sparkles are Nicole by O.P.I.'s "Twist of Fate" paired with Essie's "Cute as a Button" (pink) and Revlon's "Siren" (orange).
When I add sparkles, I like to do a fade; heavy sparkle at the top, fading down to cover about 3/4 of the nail. The trick is to do layers of sparkles, so you don't put huge globs of polish on at once. I've used two layers in each picture, and it turned out really well. A look I LOVE is with the orange nails. A popular nail trend right now is to do something different on the ring finger nail to make it pop, and the extra sparkles added to it really takes this colour from great to gorgeous!
Don't be afraid to play around with different colours of sparkles and polishes! I really recommend doing this with a darker blue or purple polish and pair it with silver sparkles, it looks amazing! Try this look today, I can guarantee that you will love it:)