Submission data not forwarded to Google Sheet

  • Profile Image
    Asked on October 11, 2019 at 02:22 PM

    Hi! I've figured out how to create the PERFECT form to use but I'm having trouble getting the google doc to fill in the quantities when submitted. The email I receive with orders lists them but the google doc doesn't fill in that specific field. I'm really hoping it's something Jotform can help with bc I have almost no chance of getting help from Google and I need the form submission to be working ASAP. Thanksgiving turkey orders depend on it! 

  • Profile Image
    Answered on October 11, 2019 at 03:56 PM

    I'm not sure I understood your question correctly.

    To clarify, you have integrated your form with Google Sheets however the data is not showing?

    Can you please share to us a screenshot of the issue?

    To post a screenshot, kindly follow this guide:-How-to-add-screenshots-images-to-questions-to-the-support-forum

    I have tested a cloned version of your form and integrated it with Google Sheet.

    The inventory widget data is forwarded correctly to the Google Sheet.

    You may try re-integrating your form with Google Sheet.


    Let us know how it goes.

  • Profile Image
    Answered on October 11, 2019 at 04:10 PM

    Yes you understood correctly! So two screenshots… Capture2 is the google doc after submitting form, Capture3 is the confirmation email. It’s not apparent from the email (which is why the google doc is important) which size Amish Heritage Breast I ordered, although I definitely submitted a form for the 4-7lb so it would be show up first on the google doc.


  • Profile Image
    Answered on October 11, 2019 at 05:40 PM

    I made a test submission in your form and it is captured in your form submissions page.

    Can you check your Google Spreadsheet again? If it still did not reflect on the spreadsheet, it is possible that you've made changes on your form as well as on the integrated sheet that's why it stops updating a particular column. To fix this, please re-integrate your form with Google Spreadsheet.

    Also, as much as possible, please do not make any changes to the integrated spreadsheet. This is one of the reasons why the sheet stops from updating.

  • Profile Image
    Answered on October 12, 2019 at 01:50 PM
    I think that did the trick. Thanks!
    Raegan Stremel | Marketing & Events Manager
    3738 Lexington Road | Louisville, KY 40207
    office: 502-498-2468 | fax: 502-618-4051|
    #TheRainbowWay | LIKE us on Facebook! | Follow us on Instagram! | Follow us on Twitter!