Integrate multiple forms into one Google Spreadsheet

  • tjmasonius
    Asked on April 16, 2024 at 7:02 PM

    In the support, it says you can not integrate multiple forms into one sheet. Have you updated that capability yet?

  • Mike_G JotForm Support
    Replied on April 16, 2024 at 10:04 PM

    Hi TJ,

    Thanks for reaching out to us for help. Integrating multiple forms into one Google Spreadsheet is possible. However, submissions will not be sent to the same worksheet in that spreadsheet. For the first form, you will set the integration to create a new spreadsheet as you see in the screenshot below:

    Integrate multiple forms into one Google Spreadsheet Image 1 Screenshot 50

    For the other forms, you will select the Use an existing spreadsheet option in the integration settings and select the spreadsheet the integration on the first form has created. You will set a different worksheet name for the other forms:

    Integrate multiple forms into one Google Spreadsheet Image 2 Screenshot 61

    Check out the screenshot below to see the result:

    Integrate multiple forms into one Google Spreadsheet Image 3 Screenshot 72

    Because if you set the same Worksheet name in the integration settings, it will just create a new Worksheet with numeric suffix as shown in the screenshot below:

    Integrate multiple forms into one Google Spreadsheet Image 4 Screenshot 83

    This may not be what you are looking for but, right now, this is the only feature we have.

    Let us know if there’s anything else we can help you with.

 
Your Answer