I just used chatgpt to write a Google Apps script for me that pulls data and formatting from one spreadsheet into another and triggers every minute. In less then 5 minutes I was able to do something usually requires a lot more time coding.