-
littletongovAsked 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?
Thanks very much!
-
JanReplied 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.