You can say "It's very motivational" but usually that's used before a noun. A motivational video, for example. If "motivative" is a word, it's one I've never seen.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.