Hi, hope to find you doing well!
I have rich experience in automation work in google sheets using google app script.
So, please share the spreadsheet with me so that I can suggest you the fastest way to achieve that task.
I hope that definitely makes sense.
Regards,
Sanjay.