Hi there,
I've already completed the script and tested with my own Google Spreadsheet and it works as expected. So if you're interested in working with me, please initiate a chat for further discussion and I'll show you the code and the way how to do it. Thanks for your consideration!
Regards.