Is it possible to merge form data to one Google Sheet per form?

  • littletongov
    Asked on August 22, 2018 at 7:25 PM

    Using JotForm, Google Sheets Integration, and a Google Sheet Add-on called Autocrat, I have been automatically merging the data from each JotForm submission to its own Google Doc, which has been incredibly handy for several projects.

    I'm working on a new project, and I need to merge the data from each JotForm submission to its own Google Sheet - vertically. I can't use Autocrat because doesn't work with Sheets.

    Below is a partial screen shot of the Google Sheet where I need the data to go. The form question is in the first column, and the applicant's response needs to be inserted in the second column that corresponds with the question. Is this possible with any of the tools and/or add-ons available for Jotform?

    1534979821sheet screen shot Screenshot 10

    Thanks very much!

    Jotform Thread 1560375 Screenshot
  • Jan
    Replied on August 22, 2018 at 9:20 PM

    Unfortunately, it is not possible to send the submission data into a customize Google Sheet template. Actually, we do not recommend altering or customizing the spreadsheet because it can potentially break the integration.

    If you want, you can send the integrated sheet to another spreadsheet using Import Range function. Please check this helpful article: https://www.makeuseof.com/tag/how-to-import-data-from-other-google-spreadsheets/.

    Thank you for your understanding.