Google Sheets integration not working

  • SAGTJotform
    Asked on June 5, 2025 at 11:30 AM

    I tried to integrate one of my form submissions with Google Sheets and I get an API error. I've attached the screenshot below. Can you help me?Google Sheets integration not working Image 1 Screenshot 20

  • Joeni JotForm Support
    Replied on June 5, 2025 at 11:48 AM

    Hi SAGTJotform,

    Thanks for reaching out to Jotform Support. The Request has insufficient authentication' error message may occur when integrating Jotform with Google Sheets due to authentication or authorization issues. Could you try removing the existing Google Sheets Integration and re-integrate it again? Let me show you how:

    1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
    2. In the menu on the left, click on Integrations and select the Google Sheets integration.
    3. Then, hover over the Action section and click on the Three Dots icon.
    4. In the dropdown menu, select Delete Action, and in the window that opens click on Yes, Discard.

    Google Sheets integration not working Image 1 Screenshot 30 Now, let's connect the Google Sheets Integration again:

    1. While in Google Sheet Integration settings, click on the Add New Action button.
    2. Now, select an action and click on Next.
    3. Then, click on Add Action and customize settings as you want.
    4. Once you finish customizing, click on the Save button at the bottom right of the settings.

    Google Sheets integration not working Image 2 Screenshot 41 If you select Create new spreadsheet, a new spreadsheet will be created in your Google account, where submissions will be collected. If you select Use existing spreadsheet, submissions will be collected in the spreadsheet you choose, which is already connected to your Google account. We also have a guide about How to Integrate Forms With Google Sheets that you can check out.

    Reach out again if you need any more help.

Your Reply