Hi! I’m currently creating a database where all the answers from the Typeform questionnaire will be directed. I would like to direct the answers from the Typeform to a specific existing row/s in Google sheet. Is this possible? Thanks in advance for the answers.
Answered
How to connect the Typeform answer to a specific row in Google Sheet?
Best answer by john.desborough
while Typeform doesn’t have the capability, as pointed out, natively, you could try the following (i do something similar to this with entries into one of my forms):
- create additional tabs in your google sheet
- have the 2nd tab pull the data from the typeform ‘dump’ into the primary tab - on this one you can change column headers to something more intuitive for your use case (from the typeform question text)
- as long as you have the appropriate identifiers, you can then have additional tabs with the related ‘data structure’ into which you can pull the data that you need ie into an existing row.
- i use this to update response data by industry when someone self-selects an industry sector in their response - ie if they select “business consulting’ then the data points they enter are added into the appropriate column of the row associated with ‘business consulting’ - this allows me to update comparatives vs industry, etc.
This may require a little bit of thinking on how to establish the cross-tab identifiers that will allow you to relate the data elements and to establish the appropriate formulae to transform the data as required.
cheers
des
+5Hi
If you have any other questions, please let us know!
Life is a series of awkward moments separated by snacks.
1 person likes this
+6- Certified Partner & Champion
- 5260 replies
- Answer
while Typeform doesn’t have the capability, as pointed out, natively, you could try the following (i do something similar to this with entries into one of my forms):
- create additional tabs in your google sheet
- have the 2nd tab pull the data from the typeform ‘dump’ into the primary tab - on this one you can change column headers to something more intuitive for your use case (from the typeform question text)
- as long as you have the appropriate identifiers, you can then have additional tabs with the related ‘data structure’ into which you can pull the data that you need ie into an existing row.
- i use this to update response data by industry when someone self-selects an industry sector in their response - ie if they select “business consulting’ then the data points they enter are added into the appropriate column of the row associated with ‘business consulting’ - this allows me to update comparatives vs industry, etc.
This may require a little bit of thinking on how to establish the cross-tab identifiers that will allow you to relate the data elements and to establish the appropriate formulae to transform the data as required.
cheers
des
If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
1 person likes this
+6- Certified Partner
- 189 replies
Hey 
Just jumping in to say that you could connect your typeform to the Google Sheet with the help of Integromat. It’s a no-code platform that lets you connect online apps and services and automate all sorts of processes.
First of all, let me share the link to
Integromat’s pre-configured Typeform integration
If you follow the link, you’ll be able to check out all the available features (i.e. actions, triggers and ready-to-use templates) of the integration.
Anyway, a scenario (that’s what we call our automations 
) that could help you with your use case might look for example like this:
What does this beauty do? Glad you asked 
It:
- receives the data from the form submission
- processes the answers one by one (that’s the ‘iterator’ bit)
- and stores the information in a specific cell in Google Sheets
If you like what you see, you can easily sign up for a free Integromat account and start exploring the magic of automation 
(the top hat emoji is the closest to ‘magic’ I could find 
)
Side note: I didn’t want to overwhelm you with millions of screenshots and steps here. If you’d like to know more about setting up the scenario, feel free to ask all the questions 
Never change. Or do, if you want, I'm not your boss.
+5Life is a series of awkward moments separated by snacks.
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.