Uploading csv to jotform, not syncing with Google Sheets

  • Profile Image
    onalytica
    Asked on October 28, 2020 at 05: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?

  • Profile Image
    ashwin_d
    Answered on October 28, 2020 at 06: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.


  • Profile Image
    onalytica
    Answered on October 28, 2020 at 07: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?


  • Profile Image
    Lorenz_A
    Answered on October 28, 2020 at 09: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.