Specific values into Google sheet | Community
Skip to main content

Hi Liz, John and Typeform team.

I would like to extract certain answers from Typeform into a google sheet, not all of them as we need to  print this off.

How can we do this?

I have already set up a follow up email which extracts certian values based on recall, however I need it to go into a google sheet. If there is an easy way (via webhook or whatever) then that would be better.

@garywaller10 - if you connect the Typeform to the Google Sheet, you get all the details on submit. don’t have much in the way of selecting a subset. 

however, in the Sheet, you can create a second tab and use the Arrayformula() function to pull the subset of each answers into the new tab automatically when there is a new submission. 

This second tab would be what you want to print out.. 

that seems to be much less overhead than using a webhook.. 

 

des


Hi ​@garywaller10 happy Friday!

Did ​@john.desborough’s suggestion help? Let us know if you have any more questions 😊


Hi Grace, thanks for following up. I’m sure it was a great idea, however I am not sure how to do this, so it didnt help.. I asked one of your support team if they had someone that could help but they said no


Hmm ​@Liz ​@picsoung I wonder if you have any ideas of an easy set up for this? 


Hey

I think ​@john.desborough’idea is the easiest to implement, have everything pushed to google sheet. Create a new sheet, and do some formula to filter only the relevant result.

An alternative would be to make your own Google Sheet connection using tools like Zapier or Make.


Reply


OSZAR »