Were you ever able to come up with a workable solution for this?

I'm looking for a similar solution and I am at the same rookie level with google scripting as you were when posting this. Very curious to see what solution you ended up with here! Any info would be greatly appreciated.