L'intégration de Google Sheet ne fonctionne pas

Bonjour

J'ai des soucis pour faire fonctionner une page google Sheet que j'ai intégré avec mon formulaire

dans l'onglet MY TOP 4

La mise à jour est très chaotique. Par exemple, il est 17h34, et l'entrée de 17H07 n'est pas intégree

comment se passent les mises à jour ? j'ai beau rafraichir la page google sheet ça ne fonctionne pas

voci le lien sur le drive : https://docs.google.com/spreadsheets/d/e/2PACX-1vStIPJEQqi1Jez-w5wBuhVLRvLnvsck26ka6INl5zRZNeWLnCByk5pHrpx8CYSSfp-3CvvfUaxKDhrc/pubhtml

le tableau de résultat

https://eu.jotform.com/tables/220484328745965/232772545394060

Hi Trentotto,

Our French 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 French, 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, I have manually pushed the missing submission to the spreadsheet. Can you check if they're now showing in the Google Sheets? Also, note that making changes to the Google Sheets directly will break the connection with Jotform which could cause the missing submissions. You can redo the Google Sheet integration to fix the issue. First, we’ll remove the existing Action. Let me show you how to do it:

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.

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 the settings as you want.
4. Once you finish customizing, click on the Save button at the bottom right of the settings.

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.

ok thanks. I tried what you explained me. It seems it works. So i understand that i can't do anything on the worksheet integrated, even applying a filter ;)

Thanks a lot

Great service, as usual

I will stop my job next month, after 12 years, and 11 years with Jotform

I'll miss jotform a lot !

I remember when i discover You and how it was helpul for my job (manager assistant in charge of Data ) !