Unpublishing page delete automatically from site pages library using MS Flow

Or if you mean you only use a site for publishing news and want to remove news pages that get unpublished etc. you could also do a flow to delete files that a. have a first published date and b. promoted state = 0, this will remove pages that used to be news.