Smoother Flipbook in a Material?

Recently learned about turning spritesheets into flipbooks to create animated materials. Made it to put onto my GUI to show collected items similar to Jake & Daxter/Ratchet and Clank with their Precursor Orbs/Bolts

However I still don’t know how many sprites I should have in the spritesheet to have a “smooth” animation.

[Current Spritesheet] (https://i.imgur.com/go25MAB.png)

[Animated Material with flipbook] (https://i.imgur.com/dZGOkZj.png)

I do see that there are some redundant sprites on the sheet however, I do not know how many columns/rows I should have. Anyone have some information on this?