connect multiple typeform in a single google sheets file | Community
Skip to main content
Answered

connect multiple typeform in a single google sheets file


Good morning, I need the responses of all the typeforms to reach a single google sheets file, because I see that currently only one google sheets file can be obtained for each typeform.

It is possible to integrate all typeforms in a single sheets file?

Best answer by john.desborough

@GB Lab Multimedia - yes you can.. all you need to do is to open the google sheet file and copy the url and then in typeform, connect the form to an existing google sheet 

and then you will be prompted for the url of the existing file

each form connection you add will create an additional tab in the google sheet

View original

3 replies

john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5298 replies
  • Answer
  • June 9, 2023

@GB Lab Multimedia - yes you can.. all you need to do is to open the google sheet file and copy the url and then in typeform, connect the form to an existing google sheet 

and then you will be prompted for the url of the existing file

each form connection you add will create an additional tab in the google sheet


Thank you very much, I see that if it works like this, I needed them to appear on the same sheet but I think that's how it works for me. thank you


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

@GB Lab Multimedia - you can use the same sheet as the target for many forms - you just need to add one additional tab (i often call it ‘reporting’) so that you can pull all the data together for a unique id .. example would be a series of forms for a company that collected home address, leave requests, timesheets, etc.. you could use their employee id or email address to link all the data associated with that identifier using something like vlookup in your arrrayformula() function. 

 

des


Reply