HI All

I am hoping you can help me with this. 

I am running a project for UNICEF and I need to do the following:

CONTEXT: 6 months ago, pregnant mothers visited the hospital and provided their phone number which is a unique ID. So now - I have volunteers that will call pregnant mothers who previously came to the hospital for a follow up about their pregnancy. 

Step 1: Every time a volunteer starts my survey, the survey has to retrieve one of the mothers’ unique ID aka phone numbers (randomly without replacement) and show it in the survey so that the volunteer can make the call. 

Step 2: The phone numbers is stored in a Google Drive in Sheets - the survey has to pick mothers who have not yet been called. The status has to change to “In Call” when the volunteer starts call. Otherwise the status is empty.

Step 3: After the volunteer speaks the mothers, the volunteer fills out more data in the survey. At the end of the call the status has to change to “Done”

Step 4: The mothers who were called need not be contacted again so the status has to change in the google Sheet so that in Step 2 - the survey is loaded next time by a different volunteer it only selects those not “In Call” and not “Done”.

Is there a way to do this at all? I’ve looked up Triggers, Workflows etc. I do not know coding so I am not sure how to do it.  

Thanks

Priya