excel or Google Sheets automation

I don't know if what I am looking for would work best with Google sheets, Excel or something else but am trying to automate (as much as possible) and Excel sheet I use for quoting, booking and paying musicians for recording sessions. I have enclosed the sheet that I use for each project. There are a lot of things I would ultimately like to do but the biggest thing is automating the booking of musicians. The process would work like this: - Enter company and project info at top - Enter the number of players needed for each section (Strings, Woodwinds, Brass, Other) and the total number of hours they are needed for. I don't want to show instruments not being hired, right now I need to delete all rows not in use. - Autofill from the roster of players are the far right for each instrument (in the order they appear in the list) - do not show any empty rows in column O. - The part I don't know, can we email the musicians in column O with the session dates and times with Gmail and LOG their responses in Google Sheets? Marking confirmed musicians and green and removing the the musicians who decline to a column (AG) and emailing the next musician on the list until all musicians are hired? - Finally, generating a payroll sheet where I can make changes from the booked hours to the actual hours and total up. I am not sure how much of this is possible and am open to other ways of accomplishing the same thing. Let me know what you think. Alan -