The TL;DR answer is that ChatGPT is not (yet) well-suited for writing stories.
Its usual style is too objective and therefore a bit boring and uncreative. It does fairly well at answering questions and writing essays, because that was the sort of task it was trained for. But it was never meant to write an engaging story.
ChatGPT is also limited in the context it can take into account. So if you want to create a story that is longer than a few pages, your risk ChatGPT losing the plot, because it can't remember what happened earlier. You'll need to work around its limited attention-span yourself.
If you want to try this anyway, then I would advise using the snowflake method. You start with a high level plot summary, and then repeatedly expand it. First you ask ChatGPT to expand the plot you provide to a number of sentences, then ask it to expand each sentence into a paragraph etc. At each step, you can ask ChatGPT to change things (or change them yourself) to give your own direction to the story.
Because of its limited attention span, beyond a certain point, you will need to provide it with a summary of the plot up to then, and with details it needs to take into account. Otherwise your story will end up riddled with plot-holes.
But as I said at the start, I wouldn't expect to much of it. If you want a riveting story, you might be able to use it as first sketch of a story, but you'll probably need to add the rivets yourself.
Another pertinent question, looking at the comments, is whether you should be burned at the stake for the mere suggestion of having a machine write for you. The way I look at it, the human part in this becomes more like that of a director than a playwright. It is a different way of shaping a story. There is still an art in it, but different from how writing has been done up to now.
Personally, I can't wait for the day that AIs become proper creative writing assistants. Because it sometimes takes me an hour just to write a few sentences, and I would very much like to concentrate on other parts of creating a story than putting it into words and onto paper. And considering I'm not wealthy enough to hire a ghost writer, a capable AI would be very welcome.
And let's be honest. This answer shouldn't have cost me one and a half hours to write. ChatGPT could have done it faster. It may have done it better. But it's banned. So you'll have to ask it itself, if you want to know.