Retrieve Unique ID from Google Sheets to a survey

Question

HI AllI 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.  ThanksPriya

Aggarwal · Accepted Answer

Yes, this can be done, but it requires integrating Qualtrics with Google Sheets using tools like Zapier or Google Apps Script, or by writing custom code.

resh_kr · Answer

​@priyakrishnan,This is doable byGoogle Sheets API or Zapier integration with Qualtrics.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded