Multilingual surveys and automated reports with Typeform and Google Sheet

@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?

@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 

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

Just an update to say that the best way of doing this was to use ChatGPT to create a Google Script, the script queried all tabs and cross checked results in a mapping table where column A (original language) and column B (English version). I was stuck for months until I used ChatGPT. 

Hey ​@j.biondini thanks so much for checking back in and providing an update on the solution. Good ol’ ChatGPT delivering the goods again 😎 Sounds like a solid workaround. Hopefully this can help more people looking to consolidate data from multiple typeforms in different languages 😍