My suggestion was to automate the process using Google Apps Script to automate the process using an algorithm. You’ve not give a lot of details about what you actually want to do but for what you did give, Google Apps Script would let you automate the task.