Integração com Planilhas Google Não está funcionando

  • luisratund
    Perguntado em 2 de dezembro de 2024 às 12:37

    Olá!


    Reparei hoje que a integração do Jotform com o Planilhas Google não está funcionando no formulário https://www.jotform.com/build/230374007955052.


    Na integração que já existia, os envios pararam no dia 26/11. E na configuração de uma nova integração, as informações não migrão.

    Integração com Planilhas Google Não está funcionando Image 1 Screenshot 20

  • Joseph Christian Jotform Support
    Respondido em 2 de dezembro de 2024 às 15:07

    Hi Luis,

    Thanks for reaching out to Jotform Support. Our Portuguese Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Portuguese, let us know and we can have them do that. But, it might take a while until they're available again.

    Now, coming back to your question. When I checked the action logs of your form's Google Sheets integration, I saw that the recent submissions failed to sync due to Worksheet not found error. Take a look at the screenshot below:

    Integração com Planilhas Google Não está funcionando Image 1 Screenshot 40Usually, removing the integration and then adding it back, solves the issue. 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.

    Integração com Planilhas Google Não está funcionando Image 2 Screenshot 51 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.

    Integração com Planilhas Google Não está funcionando Image 3 Screenshot 62 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.