Google Sheets Integration: Form isn't adding data to Google Sheets.

  • mango124
    Asked on June 30, 2024 at 3:41 PM

    I have google sheets integrated into many of my forms, and the file was created in my google drive however the data was not pushed over.

    Same goes for my one drive to create pdfs.

    Proof of empty folder and sheet below.

    Integrations did not populate  Image 1 Screenshot 30 Screenshot 10It also will not accept my screenshots. Integrations did not populate  Image 2 Screenshot 41 Screenshot 21


  • Gian_D JotForm Support
    Replied on June 30, 2024 at 3:59 PM

    Hi Stephane,

    Thanks for reaching out to Jotform Support. I understand what you’d like to do, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

  • mango124
    Replied on June 30, 2024 at 5:31 PM

    Hi Gian, thank you for looking into this. Waiting for your response.

  • Gian_D JotForm Support
    Replied on June 30, 2024 at 6:00 PM

    Hi Stephane,

    I cloned your form and tested it to see if I could replicate the issue, but everything was working properly. Check out the screencast below to see my results:

    Google Sheets Integration: Form isnt adding data to Google Sheets Screenshot 50

    As you can see, I was able to add data to Google Sheets. I've cleared your form caches because, most of the time, that fixes the issue. Try again with your form. If the issue still persists, try to remove and re-add your Google Sheets integration again. Let me show you how to do it:

    1. In Form Builder, click on Settings in the orange navigation bar at the top of the screen, and in the menu that opens on the left side of the page, click on Integrations.
    2. Click on Google Sheets.

    Google Sheets Integration: Form isnt adding data to Google Sheets Screenshot 61

    3. Click on Remove Integration.

    Google Sheets Integration: Form isnt adding data to Google Sheets Screenshot 72

    4. Click on Yes, Remove.

    Google Sheets Integration: Form isnt adding data to Google Sheets Screenshot 83

    5. Re-integrate your form to Google Sheets again.

    As for your other question, I've moved that to a new thread. You can check that out here.

    Give it a try and reach out again if you have any other questions.

  • mango124
    Replied on July 1, 2024 at 3:10 PM

    Thanks Gian, this worked great for google. still not working for OneDrive, but I have found a secondary solution to download row by row manually.

  • Deanne JotForm Support
    Replied on July 1, 2024 at 4:08 PM

    Hi Stephane,

    Your question about OneDrive has already been answered on another thread by Gian. You check out his answer here.

    Reach out again if you have any other questions.

 
Your Answer