Multilingual surveys and automated reports with Typeform and Google Sheet | Community
Skip to main content
Question

Multilingual surveys and automated reports with Typeform and Google Sheet

  • September 19, 2024
  • 5 replies
  • 35 views

Hello,

I’m seeking a solution to streamline my current manual workflow.

I manage over ten surveys, each with the same set of questions and answers, targeting users in various countries. These surveys are in multiple languages, making it challenging to generate reports automatically. Currently, I use Google Sheets, but I have to manually translate non-English responses before matching and counting them with their English counterparts.

Is there a way to automate this process? I came across an article about using Google Data Studio, but I’m unsure if it can handle multiple languages effectively.

Thank you!

5 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14840 replies
  • September 19, 2024

@john.desborough have you ever used Google Data Studio in multiple languages? 


  • Author
  • Explorer
  • 2 replies
  • September 19, 2024
Liz wrote:

@john.desborough have you ever used Google Data Studio in multiple languages? 

I didn’t. Is there a way to create mapping tables with it?


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5257 replies
  • September 19, 2024

@Liz @j.biondini - what i have done in the past is to have each language form submit to separate google sheets. THEN i have a ‘consolidating sheet’ (you can do this with tabs in one sheet if you want) where i pull in data… you can set up a function to do a vlookup in another tab that looks for ‘language A term’ in column A and returns the value in column B.. ie english version. 

 

that’s the ‘fastest’ way to do it simply in Google Sheets. 

 

des


  • Author
  • Explorer
  • 2 replies
  • September 20, 2024
john.desborough wrote:

@Liz @j.biondini - what i have done in the past is to have each language form submit to separate google sheets. THEN i have a ‘consolidating sheet’ (you can do this with tabs in one sheet if you want) where i pull in data… you can set up a function to do a vlookup in another tab that looks for ‘language A term’ in column A and returns the value in column B.. ie english version. 

 

that’s the ‘fastest’ way to do it simply in Google Sheets. 

 

des

Thank you, I’ll try that now 


Liz
Community Team
Forum|alt.badge.img+5
  • Tech Community Advocate
  • 14840 replies
  • September 25, 2024

Let us know how it went, @j.biondini !


Reply