Can I get the google sheet integration to add the spreadsheet to an existing workbook?

  • mstrain
    Asked on February 26, 2019 at 3:05 PM

    Hi, Can I get the google sheet integration to add the spreadsheet to an existing workbook?


    i.e main workbook called 'Main' with named sheets added, i.e. sheet1/sheet2.


    Jotform one submissions go directly to main, jotform 2 submissions go to worksheet 1 etc

  • David JotForm Support Manager
    Replied on February 26, 2019 at 5:12 PM

    We have an integration with Google Sheets: https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets 

    Each form you integrate will be sent to a specific folder that is defined in the integration, not to an existing folder.

  • LGHSgradnight
    Replied on February 28, 2019 at 4:38 PM

    I'm just another user. I've been doing this for quite some time. Use the "Importrange" function on the sheet in the workbook you want. You can have multiple Importrange's in a workbook, each on it's own sheet. I think this will accomplish what you want.

  • David JotForm Support Manager
    Replied on February 28, 2019 at 6:06 PM

    @LGHSgradnight, thanks for sharing this alternative option, this will be surely useful for users who might want to do the same with their integrated sheet.

  • mstrain
    Replied on March 1, 2019 at 4:23 AM

    Thanks @LGHSgradnight, brilliant option.