How to forward submissions from different forms into the same spreadsheet

  • Profile Image
    Asked on September 26, 2014 at 04:54 PM

    Hi: I'm setting up a writing contest and I've got my form in place for the public who will be submitting their short stories. Now on the judging side, I have 5 judges who will be reading the articles and rating them. So far what I have done is create a form for each article that includes the story, so the judges can read it, then it has a 1-10 scale at the bottom where they can rate the story after they've read it. Because I have set up a new form for each article, and there could be as many as 50-75 articles, how can I get all the rating scores to go into the same spreadsheet? Otherwise, each story is a separate form with it's own spreadsheet--which is not very efficient. There must be a way for me to get multiple rating into the same spreadsheet.

    Thanks --Rich

  • Profile Image
    Answered on September 26, 2014 at 06:29 PM

    We do not have an option to send the form data from multiple forms into the same Spreadsheet/Google Spreadsheet.

    As a work around, it is possible to use a Zapier service integration to send the data from the jotform email alerts to online Google Spreadsheet.

    Setup is the following:

    - Create the next Zap on your Zapier account. 

    Send Email to Add Row to Google Spreadsheet

    - Then, add an Email Notification to each rating jotform. The Email Notifications should be configured to use special Zapier email recipient address, so it will forward the data to your Google Spreadsheet.

    Please feel free to contact us if you need any further assistance.