How to have all the form submissions in one excel sheet, but each submission is sent to different email addresses?

  • BrightstarTelecom
    Asked on July 22, 2019 at 1:45 AM

    Currently, we have different agency partners so each of them has different forms assigned. Since each has a different form, the content of each submission is also saved on different excel sheets. Each form of these agencies is also sent to various email addresses (the agency owners).   

    Is there a way that all of the entries will just be on one sheet? But each submission will still be sent to these email addresses (they are not supposed to see the other emails where the form is sent).

    Because what we are thinking is, if later there will be a lot of submissions, it's quite tasking to check the excel sheets one by one, so it would be much better if all are in just one sheet. 

    Do we need to integrate to a CRM or something? Or we can do this using Jotform?

  • Nik_C
    Replied on July 22, 2019 at 4:49 AM

    Since Spreadsheet integration is done per form, you cannot integrate multiple forms with one Spreadsheet.

    What you can do, however, is use import range option: https://support.google.com/docs/forum/AAAABuH1jm0aqJAApdcr88/?hl=en&gpf=%23!topic%2Fdocs%2FaqJAApdcr88 that will allow you to combine multiple spreadsheet's data into one.

    Hope it helps.

    Thank you!