Automating Auto-Refresh for Error-Free Spreadsheet Columns

Hey guys! Is there a way to keep auto-refreshing a column until all errors are solved? And is there a way to automatically do this for a whole sheet? I keep getting errors when i use chatgpt for a column. And every time i refresh, it takes a while to load and I'd always need to refresh it again. Is there a way to automate this part of the process?