Google Sheets and Qualtrics
I have to populate a survey that has teachers and teams in 86 schools. These teachers and teams will be in a drill down sequence in Qualtrics. Schoo<Team<Teacher. The teachers and teams will change often in the schools and I would rather not update every survey as they change. I am wondering if I could connect Qualtrics to a google sheet that is shared with each school, then a person at each school could be in charge of keeping their sheet updated.
Is it possible to dynamically populate a drop-down question in a Qualtrics survey based on what is on a Google Sheet?