Survey Response Workflow: Response data not translated

Hello @MihoSato, 

To ensure that the survey response data is displayed in English regardless of the input language, you need to set up your workflow correctly. Here's how you can do it:

1. In your workflow trigger, make sure you've selected "Newly created response" as the event that starts the workflow.

2. In the "Select what language to receive response data in" section, choose "Resolve translations into another language" and select "English (US)" from the dropdown menu. This will ensure that the response data is translated into English.

3. For your email task, ensure that the email body contains the response summary using piped text. This will dynamically pull in the response data in English.

4. For your Microsoft Excel task, make sure that the survey response is added to the correct Excel worksheet.

If you've followed these steps and are still seeing responses in German and Japanese, it might be due to the fact that the "Resolve translations into another language" option only applies to closed-ended questions (i.e., questions with predefined answer choices). Open-ended responses (i.e., free text comments) will still appear in the language they were entered in.

If you need to translate open-ended responses, you can use the Translate Text Responses feature. This feature allows you to translate comments in the Data & Analysis tab, making it compatible with Text iQ, response editing, data exports, reporting, and CX Dashboards.

Let me know if this helps.