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

  • Profile Image
    littletongov
    Asked on August 22, 2018 at 07: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.PNG

    Thanks very much!

    Screenshot
  • Profile Image
    Jan
    Answered on August 22, 2018 at 09: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.