How can I use the API to copy data from my Contact List (Trigger) to a Google Sheet?

Thanks Tom! Any experience in those calls? I may have to rework it and instead of using a contact list, pull the data from the Results (responses).

I have experience with the Qualtrics API calls for contacts and responses (contact calls are different depending on if you are using Target Audience or not). In version 3 of the API contact calls are easier to code that response exports. I haven't used the Google Sheets API.

do you have an example of an API call to a survey's responses to pull them? All I can find is a call to an "export" which then creates a zip file? Any place you can point to for good examples of API calls for responses?

Tom, Actually I found this post from you: https://www.qualtrics.com/community/discussion/comment/1409#Comment_1409 which seems to explain it. Wow...definitely want to use the older API call. I'd like to be able to pull in new responses into a Google Sheet, either periodically (on a schedule) or as they are saved.

Well, unfortunately, in version 3.0 of the API you get response data by exporting it. There is an outstanding feature request to get a response by response id in json format. This is why I said it is easier to code getting contact data. You can get response data using getLegacyResponseData in version 2.5 of the API.

Thanks, @TomG! "Getting a response by response ID in JSON format" is on our feature backlog for V3 APIs. We are hoping to have it released soon!