Integração do Google Sheets não funciona “Send Existing Submissions to the Sheet”

Estou criando uma integração do Google Sheets para o formulário id 242053655458056, mas mesmo com a confirmação de que “Send Existing Submissions to the Sheet” está marcado, e que novos envios chegam ao Sheets, mas nenhuma submissão anterior foi enviada.

Hi Climate_Ventures,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

For Google Sheets integration, Send Existing Submissions to the Sheet should send existing form entries to the spreadsheet when the integration is set up. The knowledge base also notes that renaming column headings in Google Sheets may break the integration, and that adding filters in Google Sheets may stop your spreadsheet from updating.

Here’s how to check the integration setup:

1. Open your form in Form Builder and go to Settings.
2. Select Integrations and open the Google Sheets action.
3. Verify that the spreadsheet and worksheet settings are correct, then confirm Send Existing Submissions to the Sheet is enabled.
4. Check your Google Sheets column headings and make sure they were not renamed after the integration was created.
5. Review whether any filters were added in Google Sheets, since filters may stop the sheet from updating.
6. Open the action logs from the integration menu and check for successful or failed runs.

The knowledge base also says that when you use Use an Existing Spreadsheet, it creates a new worksheet to store your form data instead of adding rows to the selected spreadsheet.

If the existing submissions still do not appear after checking those items, I don't know this information and our support team will handle your request.

Let us know if you have any other questions.