Integrate multiple forms into a single Google Sheet file

  • admin_admin283_LLC
    Asked on June 3, 2021 at 12:27 AM
    Jotform Thread 3137300 Screenshot
  • John JotForm Support
    Replied on June 3, 2021 at 7:04 AM

    If you mean you would like to integrate several forms with the same Google Sheet, that's possible.

    When you integrate the form, there's an option there to select which file to use:

    1622718090 60b8b68a58346  Screenshot 10

    1622718104 60b8b69843cb4  Screenshot 21

    Once done, the form's data will be sent to the specific sheet you've configured while setting up the integration.

    Also, if you intend to add customizations into each sheet, we highly discourage it as it may break the integration. If there's a need to manipulate the data between the sheets, we recommend duplicating them instead. You can use the IMPORTRANGE function to mirror the data from one sheet to another.

  • admin_admin283_LLC
    Replied on June 3, 2021 at 12:08 PM

    Actually the opposite. I was asking can use multiple google spreadsheets in one form?

  • John JotForm Support
    Replied on June 3, 2021 at 1:45 PM

    Unfortunately, no. It has to be one sheet for every form, so what you're trying to achieve isn't possible.

    You would need to manually create data manipulation processes (e.g. IMPORTRANGE) into the Workbook to slice the data from the original sheet to multiple sheets.