Export matrix table responses to Google Sheets | XM Community
Skip to main content
Question

Export matrix table responses to Google Sheets

  • April 25, 2025
  • 3 replies
  • 64 views
E
Forum|alt.badge.img

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!

3 replies

Sachin Nandikol
QPN Level 6 ●●●●●●
Forum|alt.badge.img+44
  • Sachin Nandikol
  • QPN Level 6 ●●●●●●
  • 531 replies
  • April 26, 2025

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.

Sachin
E
Forum|alt.badge.img
  • ericterr
  • Author
  • 2 replies
  • April 28, 2025

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:

I appreciate your help!

E
Forum|alt.badge.img
  • ericterr
  • Author
  • 2 replies
  • May 1, 2025

Hi ​@Sachin Nandikol, thank you for your response.

I’ve attempted to implement the solution you described, but haven’t had any luck. I have tried the following:

${q://QID1218154923/QID1218154923_10/SelectedAnswers}

${q://QID1218154923/Experience_10/SelectedAnswers}

${q://QID1218154923/SelectedAnswers}: Results in the question text instead of the chosen response

Here’s a bit more info about my matrix question:

I appreciate your help!


Terms & ConditionsAccessibility statement