Specific values into Google sheet | Community
Skip to main content
Question

Specific values into Google sheet


Forum|alt.badge.img

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.

5 replies

john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5298 replies
  • March 14, 2025

@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


Grace
Community Team
Forum|alt.badge.img+5
  • Community Advocate
  • 2661 replies
  • April 11, 2025

Hi ​@garywaller10 happy Friday!

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


Forum|alt.badge.img
  • Author
  • Explorer
  • 6 replies
  • April 11, 2025

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


Grace
Community Team
Forum|alt.badge.img+5
  • Community Advocate
  • 2661 replies
  • April 11, 2025

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


picsoung
Typeform
Forum|alt.badge.img+5
  • Developer Advocate @ Typeform
  • 390 replies
  • April 17, 2025

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.