Managing Multiple Typeforms & Google Sheets Integration

Hi ​@Questionaire oberA happy Friday!

You should be able to redirect based on a response using variables with a redirect link, here’s a Help Center guide on the setup.

And it’s possible to integrate multiple forms with the same Google Sheet, it will create a new tab for each form in that Sheet.

Hope that helps!

Hi everyone,

I currently have 15 questionnaires, each connected to its own Google Sheet with its own Apps Script.

I’m thinking about merging everything into a single Google Sheets file with multiple tabs (one tab per questionnaire), and I have a couple of questions:

1. If I do that, will the Apps Script be shared across all tabs, or can each tab still have its own separate script?

2. Once I connect multiple Typeform questionnaires to the same Google Sheets file (different tabs), will the responses from different questionnaires stay separated, or will they appear together?

Also, if anyone has experience managing multiple Typeform forms with a single Google Sheets + Apps Script setup (especially for sending emails), I’d really appreciate your advice.

Thanks in advance!

Thanks ​@Questionaire oberA I’m not too familiar with Apps Script, ​@john.desborough have you used it for organising Google Sheets? 

​@Questionaire oberA ​@Grace  - i have multiple typeforms that feed common Google Sheets, on individual tabs, and then i use combine the data across the tabs into a reporting tab that suits my needs. 

I have Apps Scripts running on a couple of them but nothing serious. all my reporting is driven off the one reporting tab. 

my conversations with Google Support over time has been frustrating about how Apps Scripts are supported and can co-habitat within the same Google Sheet. Essentially they have said that ‘while there should be no issue, they cannot guarantee’ .. but they are clear about the lines drawn on where they will attempt to provide support: once the data is written to the Google Sheet any technical issues with performance of Apps Scripts is the Google User (not the typeform) 

and i have never been able to get consistent performance from Apps Scripts for email - i use Document Studio to manage the Sheets to email functions. 

des

Thanks for sharing your experience ​@john.desborough. Hope that helps ​@Questionaire oberA as you build out your workflow 😊