Hello, I am attempting to send responses to a matrix table question to a Google Sheet using the Google Sheets workflow. When I export my survey responses, each matrix row appears in its own column as intended with the ImportID label. I am trying to replicate that format in the automated workflow.I have tried using many combinations of the following, most result in empty values or the question text instead:${q://QID/ChoiceGroup/SelectedAnswers}${q://QID/ChoiceGroup/SelectedAnswers/#}${q://ImportID/ChoiceGroup/SelectedAnswers}${q://ImportID/SelectedAnswers}I have also tried using SelectedChoices in place of SelectedAnswers.Apologies if I have missed a solution elsewhere, thank you!

Hello @ericterr,Try piping as below once,For a specific row use the following format: ‘${q://QID/RowID/SelectedAnswers}’Example: If your matrix table has the QID ‘Q1’ and a row labeled ‘Row1’the piped text would be: ${q://Q1/Row1/SelectedAnswers}For all rows in the matrix table use: ${q://QID/SelectedAnswers}Let me know if this helps.

Export matrix table responses to Google Sheets

Export matrix table responses to Google Sheets | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded