Skip to main content

Hello Typeform fam! I am creating a form that receives responses from people in various states. Among the other responses submitted by a given user, they will enter their state by selecting it from the dropdown menu. Using Google Sheets integration, how can I send responses from Typeform into a specific sheet tab within a Google Sheet that corresponds with the state selected. For example, in the Typeform, the user selects Arizona as their state. Typeform sends all responses from that user to the Arizona sheet tab within the Google Sheet. Thanks for your help!

​@zelioso - you would be better off having all the responses landing in the one tab and using separate sheets for each of the target ‘states’ - you would use the arrayformula() function to pull a copy of the record into the ‘state tab’. 

the formula on each of the additional tabs would be set to pull in the record if state=arizona, for example. 

it would happen automatically 

 

just a thought

 

des

Thanks ​@john.desborough! Oh that’s brilliant! I’ll look into it now! Any recommendation and documentation or is it just as straight forward as you outline it?

​@zelioso - the google help files should tell you how to use the syntax. there are also a couple of other posts/webinars that are available in the Community where i show the usage of the arrayformula() function - they may not be exactly what you are seeking but if you have done vlookups before, this should be easy enough

des

Thanks a million!

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs