Export matrix table responses to Google Sheets

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!

Page 1 / 1

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.

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.

Hi @Sachin Nandikol, thank you for your response! I attempted to implement your solution, but haven’t had an luck.

Here’s a bit more detail about my matrix question, I’ve attempted use both Experience_# and QID1218154923_# as my Row ID, as they show up in the CSV export and question export tags: