Translate Typeform responses into one English tracker

Every time someone submits your survey, we translate their open-text answers into English and log the whole response to a Google Sheet your team can read.

Works with Typeform, DeepL, Google Sheets

What it does

  • Watches your Typeform survey and runs the moment a new response comes in.
  • Translates the free-text answers into English and detects which language each respondent wrote in.
  • Adds one row to your Google Sheet with the submission time, the detected language, the original answers, and their English translations.
  • Leaves multiple-choice answers untouched and always records the language, even when the response is already in English.

The prompt

Paste it into a new chat in General Input, and a specialist builds it with you.

This is a deterministic, code-style workflow. Trigger it with a webhook that fires whenever a new response is submitted to my Typeform survey. Typeform emits a first-class outgoing webhook on each new submission, and the payload carries the submitted answers. If any answer data is missing from the webhook payload, fetch it with Typeform's Retrieve Responses operation using the form and response identifiers from the payload.

From the response, gather only the free-text (open-text) answers into an array of strings, preserving their order and remembering which question each one belongs to. Send that array in a single DeepL Translate Text call with target_lang set to EN and source_lang omitted so DeepL auto-detects the language. Read back both the translations and the detected_source_language that DeepL returns. DeepL accepts up to 50 text strings in one call, so batch all the open-text answers into that single request. Note that DeepL free-plan API keys end in ':fx' and must use the api-free.deepl.com host.

Then append exactly one row to my Google Sheets tracker using Append Values. The row should contain, in order: the submission timestamp, the detected source language, the original open-text answers, and their English translations. Pass multiple-choice, rating, and other closed answers through unchanged into their own columns; do not translate them.

Keep everything deterministic: translate only the open-text fields, leave every multiple-choice answer exactly as submitted, and always record the detected source language even when it is already English. One response in produces one row out.

What you'll need

  • A Typeform account with the survey you want to track.
  • A DeepL account for the translations (the free plan works).
  • A Google account and a Google Sheet to collect the responses.

Make it yours

  • Choose which survey questions get translated and which pass through unchanged.
  • Point it at any Google Sheet and set the column order that suits your team.
  • Switch the target language if your team reads something other than English.

FAQs

Does this work with free DeepL and free Typeform accounts?
Yes. A free DeepL plan handles the translations, and Typeform's built-in response notifications trigger the workflow, so you can get started without a paid tier.
What happens if someone answers in English?
The response is logged just like any other, and the detected language is recorded as English, so your sheet always shows where each answer came from.
Will it translate the multiple-choice answers too?
No. Only the open-text answers are translated. Multiple-choice and rating answers are copied across exactly as they were submitted.
How fast does a new response show up in the sheet?
It runs as soon as someone submits the form, so the translated row usually appears within moments of the response coming in.
Can my whole team read every language in one place?
Yes, that is the point. Every response lands in the same sheet in English, so a team that does not speak every respondent's language can read them all together.

Read every survey response, whatever language it's in.

Automatically translate and log multilingual form submissions so your whole team stays on the same page.

Create your first specialistBook a call
Explore more prompts

Keep reading

Call overdue Xero customers with an AI collections agent

Every weekday at 10am, an AI voice agent phones your most overdue Xero accounts, logs what each customer promised, and reports back to finance in Slack.

· Works with LiveKit, Xero, Deepgram, Google Sheets, Slack

Local listing health board for every location you manage

See every Google Maps listing you manage on one screen, ranked worst first, with an audit button that writes the fix list for you.

· Works with Local Business Data, Google Sheets

Let support send one-off Loops emails without an engineer

Your team picks a template, finds the customer, checks they are safe to email, then sends it, with every send logged where the whole team can see it.

· Works with Loops.so, Stripe, Google Sheets