Hi Qualtrics Community! A recent experimental need here at Stanford has been to make surveys with questions whose content is customized based on samples from a Google Sheet. But these samples couldn't be _completely random_; rather the samples needed to enforce some structure like uniformity across views by respondents (e.g., one customized question is seen no more than N times). This type of sampling strategy requires maintaining a "global state" separate from the clients. We couldn't use the Google APIs, which can be imported into custom Qualtrics `javascript`, because they (appear to) require client-side `OAuth` logins to write to _any_ sheet, including one owned by the experimenter. Our respondents can't be asked to log into their Google profiles to help us maintain a global state for sampling. Our solution was to build a custom backend API in `node.js`. This API can run on some server (e.g., in AWS EC2 or GCE), load a Google Sheet using Google's API for `node.js`, and serve
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.