How to integrate multiple forms with the single Google spreadsheet

  • Profile Image
    mjgroup
    Asked on August 24, 2018 at 05:10 AM

    Hello,


    I have multiple websites for our Company and each contact form has slightly different information, however there are 5 fields of data consistent across each form that I would like to populate into 1 spreadsheet. 

    i.e.

    Company Name

    Customer Name

    Product Interest

    Enquiry

    Is there a way I can push the data from each of my individual forms into one Google Sheet? Is it's very long winded process to populate them all into one sheet for further analysis. 


    Thanks!


  • Profile Image
    AshtonP
    Answered on August 24, 2018 at 10:05 AM

    Unfortunately, you cannot integrate multiple into a single Google sheet. Although you may achieve this by using an ImportRange function, you can read more about it here - https://support.google.com/docs/answer/3093340?rd=1

    You can also try to use our combine submissions app. This allows you to combine the submissions of multiple forms in one CSV file. Please take a look at the following URL: http://apps.jotform.com/app/combine_submissions

    Alternatively, you could try using Zapier to integrate Jotform with Google Sheets that might allow the multiple form integration into a sheet.

    Let us know if you need more information.