How do I make a random permutation function in Google Sheets

I need to generate a function on google sheets that randomly generates 8 numbers within the range of 1:8. It needs to be a permutation, so none of the 8 numbers should repeat. I am able to do this in R, but my advisor is requesting that I do it in google sheets. If you need any additional information to make this work please let me know!

I have tried using a random array function and restricted the range to 1-8 but it will generate the same number multiple times.