How to submit 2 forms data into single google sheet.

  • L38groupbookings
    Asked on May 22, 2019 at 2:30 AM

    Hi, 

    We want to collect 2 separate form data into single google sheet at 2 different tabs.

    Can you please advice how to achieve this?



    Regards

    Pulak 

  • Victoria_K
    Replied on May 22, 2019 at 4:13 AM

    Hello Pulak,

    We do not have a direct option to integrate 2 forms to single spreadsheet file. I can suggest to set up integration for 2 forms separately. Then, you can use IMPORTRANGE function to copy the data from those sheets into third one. 

    Here is related guide: How-to-Integrate-Forms-with-Google-Sheets

    Please note that we do not recommend to apply any changes within integrated spreadsheet or change its settings as this can cause the integration to fail.