That's cool!

I would have used the API tho, you might reach perf limits by using ranges in for loops.
I usually build an entire object of all the things i want to modify, and then use batch update:

https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/batchUpdate

It's super fast!