When Google Sheets and JotForm are integrated for multiple forms, it integrates all submissions into one Google Sheet instead of multiple ones.

PLEASE HELP!

When Google Sheets and JotForm are integrated for multiple forms, it integrates all submissions into one Google Sheet instead of multiple ones. When Google Sheets and JotForm are integrated, I need it to create multiple sheets and have the submissions to be collected under the appropriate sheet.  

Hi,

When you integrate Google Spreadsheet to your Form, it will create only one spreadsheet. Currently, when you remove and reintegrate, it creates a new spreadsheet per instance, the old spreadsheet will remain in your Google Drive but it will no longer be connected to your form.

It is a one way integration where the Form transfers the data to the newly created spreadsheet, you cannot pass data from Spreadsheet to the Form, you also cannot connect your own spreadsheet to the form.

Please check our guide here: http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet.

Note: Every time that remove and re-integrate Google Spreadsheet, it automatically loads all the submissions in the newly created spreadsheet.

If you want to compile multiple Forms with their Google Spreadsheets to one main Sheet (a master sheet), you can use the ImportRange function for that.

I hope that helps.

Is there another tool I could use to do what I am looking for it to do? Please help! Thanks!

@LCaraccilo

Sorry but I don't think there's any feature that would fit your requirement. The only option I could think of that would be automated is to create your own webhook script, this requires advanced php knowledge though. http://www.jotform.com/help/245-Creating-your-first-Webhook-with-JotForm

Other than that, you may consider PDF format instead. When you integrate to Google Drive, submissions data will be sent into PDF format.