I have integrated a Jotform with a Google Sheet to receive form submissions directly into the sheet. The objective was to trigger a Google Apps Script

  • Ashish Jain
    Asked on November 30, 2023 at 10:29 PM

    I have integrated a Jotform with a Google Sheet to receive form submissions directly into the sheet. The objective was to trigger a Google Apps Script function upon each form submission using the trigger settings in the associated Google Sheets. However, I am encountering an issue where the form does not appear as an option inside the trigger settings in Google Apps Script. Consequently, the desired function is not triggered automatically upon form submission.

  • William JotForm Support
    Replied on December 1, 2023 at 3:21 AM

    Hi Ashish,

    Thanks for reaching out to Jotform Support. The integration with Google Sheets is designed to simply transmit the data from your form to Google Sheets.

    I'm not sure how you are attempting to initialize triggering a script in your Google Apps but I would like to know more about this. Can you share with us more details on how this is supposed to work and what it does?

    As soon as we hear back from you we'll help you more with this.