I have one jotform that is integrated with Google Sheets. How do I get it to add new data to Google Sheets each time a form is submitted to me?

  • ParkABike
    Asked on April 5, 2016 at 1:19 PM
    Do I have to "integrate" it every time I want the new information to go to Google Sheets?  How do I get it to go to Google Sheets without having to do it manually?
    Each Jotform I set up gives me different info, therefore I'd like each form to be integrated and automatically update the Google sheet it is linked with...how do I do this?
     
     
    Answered by Kiran
     

     

    Do you mean to have all the submissions of different JotForms in your account to one Google spreadsheet? Unfortunately, it is not possible to integrate the same spreadsheet with the different JotForms. Please be noted that each JotForm has its own integration of Google Spreadsheet and it creates a new spreadsheet for each form. Once the form is integrated with Google spreadsheet, the existing submissions of the JotForm will be copied to the spreadsheet and the new submissions will be appended to the sheet as they are received.

    Hope this information helps! If you need any further assistance, please let us know. We will be happy to help. 

  • David JotForm Support
    Replied on April 5, 2016 at 2:20 PM

    Submission data will be added to your integrated sheet each time the form is submitted.  Set up the integration once and there is nothing else that needs to be done for it to automatically update:

    https://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-