Uploading csv to jotform, not syncing with Google Sheets

  • onalytica
    Asked on October 28, 2020 at 5:15 AM

    I am uploading data here https://import.jotform.io/ to prefill a form with what data we have, we then want to send the unique edit submission links to specific people so they can fill in the blanks. I have managed to upload the data to the form and I can see the submission in my inbox, however it's not populating in the google sheet we have integrated. The work around at the moment is to remove Google Sheets integration and add it again ticking the "Send existing submissions to the sheet." option but we obviously don't want to have to do this ... do you know why the Google sheet isn't populating when I upload the data to the form?

  • Ashwin JotForm Support
    Replied on October 28, 2020 at 6:46 AM

    Please note that when you import data in form using "Import Data" app, it will not trigger any email or integration. If you want to send the imported data to integrated Google Spreadsheet, you need to reintegrate your form with Google Spreadsheet again.

    Hope this helps.

    Do get back to us if you have any questions.


  • onalytica
    Replied on October 28, 2020 at 7:05 AM

    Thanks for getting back to me. So the uploaded submissions exist in the jotform inbox but they won't sync to Google Sheets or SF automatically after upload, we have to remove and add integration again to force the sync is that correct?

    We want to send people the edit submission link so they get a pre-filled form and they just have to fill in the blanks. Is it the same regarding edited submissions? i.e. they won't sync to Google Sheets or Salesforce automatically, we have to remove and add the integrations again?


  • Lorenz JotForm Support
    Replied on October 28, 2020 at 9:34 AM

    Hi there,

    So the uploaded submissions exist in the JotForm Inbox but they won't sync to Google Sheets or SF automatically after upload, we have to remove and add integration again to force the sync is that correct?

    That is correct, Google Sheet or SF needs to be reintegrated again so the most updated submissions will be synced.

    We want to send people the edit submission link so they get a pre-filled form and they just have to fill in the blanks. Is it the same regarding edited submissions?

    As far as I know, the data from the integration should be updated when editing the submission using the edit link, since there's a submit button which triggers the process.

    I hope this helps. Let us know if you have any other questions.