This workflow gives you more control of how your Photoshop frame animations are exported.
This takes you through converting frames to layers and layers to files. Your next step is to import the file sequence into After Effects, but that video will have to come later!