Is it possible to send submissions data from multiple forms to the same Google Sheet?

  • Profile Image
    BuryTrainingServices
    Asked on June 02, 2020 at 04:49 PM

    Hi Guys


    not sure if its the right place to ask this question , but if anybody could point me in the right direction tat would be great.


    i have 4 main form all more or less collect the same date (just a different truck type)

    is it possible to have all 4 four google sheet integrated into one and keep updating when i have form submissions.

    reason being i need to keep track of what company is doing what training all in one place so i can use for invoice and record keeping for the cliants.

    many thanks

    colin


  • Profile Image
    Kevin_G
    Answered on June 02, 2020 at 09:00 PM

    Unfortunately, our Google Sheets integration does not support this, one form can be integrated with one sheet. But as an alternative, you may integrate your forms with Google Sheets and then merge these sheets into a single one using the ImportRange function from Google, this guide will provide you more details: https://support.google.com/docs/answer/3093340?hl=en 

    This guide will help you to integrate your forms with Google Sheets: https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets

    I hope this helps.