Best answer

Google Sheet

  • 29 April 2020
  • 1 reply



I did connect my Typeform to a Google Sheet. All good so far. However for certain questions in my Typeform I get multiple answers.

For instance “In the list below, what your 3 favorites watch brands ?” : Rolex, Hublot, Omega, Cartier, Richard Mille”

So in my Google Sheet I get all anwsers like this “ RolexOmegaCartier”

Would you know how I could put a comma “,” between theses answers so it’s more readable and can be extracted for KPI’s ? 


thanks a lot for your help,


Best answer by andywingrave 29 April 2020, 13:28

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +9

Hey! Great question. You can actually use Zapier’s Formatter to do this


Here’s a specific help page which should point you in the right direction:


Hope that helps!