Google sheet Integration: Connection breaks updating google sheet directly

  • Tracy Fairman
    Asked on July 20, 2023 at 10:32 PM

    Hi! I am setting up this integration but it appears that if I change the format (ie - font) or manually adding a line in Google Sheets the integration is no longer working. Is that correct?

    Page URL: https://www.jotform.com/help/228-how-to-integrate-forms-with-google-sheets/
  • Rahul JotForm Support
    Replied on July 21, 2023 at 3:26 AM

    Hi Tracy,

    Thanks for reaching out to Jotform Support. Yes, adding any lines manually in Google Sheets directly will break the connection with Jotform and you'll need to Configure Google Sheet Integration again. Please note the following points when using Google Sheet Integration in Jotform:

    • Changes in your Google Sheets spreadsheet don’t affect your Jotform form entries.
    • Renaming column headings in Google Sheets may break the integration. You can redo the integration in Jotform to fix it.
    • Adding filters in Google Sheets may stop your spreadsheet from updating. Reapply the filters in Google Sheets to see the updates.
    • Inline edits in Tables won’t update entries in Google Sheets, unlike entry edits.

    Let us know if you have any other questions.