Hi there,
I will be happy to help you with that. I work as a Google App Script developer, so I write scripts for spreadsheets. We can write a script that calls Twilio or RingCentral APIs, through which, you will be able to text multiple people from the spreadsheet directly and populate their responses there and determine who is available for work.
I will be happy to discuss the project further with you!
Sincerely,
Mohamed