Godot Version
4.5
Question
On flipping the sprite horizontally and then playing the animation the sprite moves towards the right while the animation is playing before returning to the original position
That is not a question. If you have a question or need help with something you might want to phrase it in some other way.
i was working with a sprite sheet attack animation with animation player so the sprite is quite wide cuz of the weapon of the character which when the character is facing other side causes the character to shift horizontally when playing the said animation
So the center of the sprite does not match the center of the character? You can address that by making the sprite a child of another Node2D. Flip the parent node by setting its scale to -1. Offset the child sprite to have it flip around any point you like.