# Synchronisation de mon Google Sheets ne fonctionne pas **URL:** \ **Category:** Report a Bug\ **Created:** [April 1, 2020, 3:08pm UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247 "2020-04-01T15:08:05Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Jeanne\_Leroy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeanne_leroy/32/5015_2.png) [@Jeanne\_Leroy](https://community.glideapps.com/u/Jeanne_Leroy)\ **Post date:** [April 1, 2020, 3:08pm UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/1 "2020-04-01T15:08:06Z")
Bonjour, J’ai un problème avec mon Glide, le Google Sheets que j’utilise ne se synchronise pas dans mon Glide. Concrètement, dans “Edit” et “Data” les données ne sont pas les mêmes. Dans “Edit” la mise à jour est bien effectuée et pas dans “Data”. Du coup, je suis bloquée car les données ne sont pas les bonnes. Ce que j’ai déjà fait : supprimer mon Glide et en ouvrir un autre, actualisé la page https://, fermé puis ouvert l’application. Je vous remercie par avance pour votre réponse, Jeanne ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [April 1, 2020, 7:33pm UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/2 "2020-04-01T19:33:57Z")
Essayez d’actualiser la déconnexion de Glide tous ensemble et / ou actualisez le navigateur. ---
**Author:** ![Jeanne\_Leroy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeanne_leroy/32/5015_2.png) [@Jeanne\_Leroy](https://community.glideapps.com/u/Jeanne_Leroy)\ **Post date:** [April 2, 2020, 7:27am UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/3 "2020-04-02T07:27:59Z")
Le mer. 1 avr. 2020 à 21:44, George B via Glide Community [glideapps@discoursemail.com](mailto:glideapps@discoursemail.com) a écrit : ---
**Author:** ![dafy\_alex](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dafy_alex/32/9983_2.png) [@dafy\_alex](https://community.glideapps.com/u/dafy_alex)\ **Post date:** [July 3, 2020, 8:09am UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/4 "2020-07-03T08:09:31Z")
Bonjour, J’ai aussi un problème de synchronisation. Les lignes ajoutés dans la Gsheet n’apparaissent pas dans Data. J’ai aussi essayé en saisissant via le bouton formulaire : la Gsheet est bien mise à jour, mais pas la Data. J’ai supprimé et recréé les colonnes Relations, au cas où, mais ça n’a pas corrigé le problème, au contraire : le lien de la catégorie au produit ne fonctionne plus. Pouvez-vous m’aider, svp ? Voici le lien de l’application : [https://mauritiusproducts.glideapp.io](https://mauritiusproducts.glideapp.io) Merci d’avance. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 3, 2020, 8:24am UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/5 "2020-07-03T08:24:14Z")
It’s highly likely your rows are added at row 501 or 1001. Scroll down a bit in the Sheets to see if they are there. ---
**Author:** ![dafy\_alex](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dafy_alex/32/9983_2.png) [@dafy\_alex](https://community.glideapps.com/u/dafy_alex)\ **Post date:** [July 3, 2020, 8:58am UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/6 "2020-07-03T08:58:48Z")
Hi, I have only 10 rows. Thank’s ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 3, 2020, 9:01am UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/7 "2020-07-03T09:01:05Z")
Yeah but can you scroll down your Sheets and see if the row you added have some how gone to row 501 or 1001? Do you have empty rows (as in not filled in with data) in your Sheets? ---
**Author:** ![dafy\_alex](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dafy_alex/32/9983_2.png) [@dafy\_alex](https://community.glideapps.com/u/dafy_alex)\ **Post date:** [July 3, 2020, 9:10am UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/8 "2020-07-03T09:10:55Z")
No, I haven’t. I give a try by adding a row with form button. The row was well added in 10th ligne in Gsheet. But the Data in Glide was not updated. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 3, 2020, 9:13am UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/9 "2020-07-03T09:13:32Z")
Oh sorry I mistranslated that, I thought it was the other way around. Have you tried refreshing the Glide tab and press syncing again? ---
**Author:** ![dafy\_alex](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dafy_alex/32/9983_2.png) [@dafy\_alex](https://community.glideapps.com/u/dafy_alex)\ **Post date:** [July 3, 2020, 10:38am UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/10 "2020-07-03T10:38:47Z")
It’s ok about synchronisation. The refresh button wasn’t active because the browser zoom was at 100% ! But, the issue now, is the link beween categories and products doesn’t work anymore. When I deleted the relation columns, it broken the View details. And when I tried to create again the relation columns for the Inline list, it doesn’t work. Thank’s for your help. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 3, 2020, 10:40am UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/11 "2020-07-03T10:40:05Z")
Can you show me the relation you are setting, what is it returning now? ---
**Author:** ![dafy\_alex](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dafy_alex/32/9983_2.png) [@dafy\_alex](https://community.glideapps.com/u/dafy_alex)\ **Post date:** [July 3, 2020, 10:49am UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/12 "2020-07-03T10:49:17Z")
Here is some print screen.! [Opera Snapshot\_2020-07-03\_124405\_go.glideapps.com|690x243](https://community.glideapps.com/uploads/short-url/wUxGjZmgiYbiO660TeMmoR2ftqA.png) ![Opera Snapshot_2020-07-03_124456_go.glideapps.com](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c2bc2a8203ceadc07a6ea6dcbe400dfed8b6b552.png) ![Opera Snapshot_2020-07-03_124523_go.glideapps.com](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a51cc1f8b6a2695851b47b959cb8fe5092c425a8.png) When I use filters on products list, it’s work fine. I don’t understand. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 3, 2020, 10:59am UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/13 "2020-07-03T10:59:16Z")
Do you mean the Relation is returning the unique row ID instead of what you expect, or is it returning the wrong rows? If it’s the row ID you worry about, it’s not a problem as a “relation” will return the first column in the matching sheet for you to know there’s actually something being returned, it’s not an indication that they actually return the wrong value, they have it so you know it’s there. ---
**Author:** ![dafy\_alex](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dafy_alex/32/9983_2.png) [@dafy\_alex](https://community.glideapps.com/u/dafy_alex)\ **Post date:** [July 3, 2020, 12:08pm UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/14 "2020-07-03T12:08:15Z")
When I click on one category, I get an empty page. If I go directly on products list and I choose a category via filter, it works fine : I get the right category’s product. Is the structure of the Gsheet have to be same as the one in Data ? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 3, 2020, 12:09pm UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/15 "2020-07-03T12:09:32Z")
You can link each category to a screen and the value of that is the relation, if I understand your situation right. ---
**Author:** ![dafy\_alex](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dafy_alex/32/9983_2.png) [@dafy\_alex](https://community.glideapps.com/u/dafy_alex)\ **Post date:** [July 3, 2020, 12:15pm UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/16 "2020-07-03T12:15:19Z")
Yes, that’s it. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 3, 2020, 12:16pm UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/17 "2020-07-03T12:16:58Z")
What I usually do is have the unique categories and their images in one sheet, then make a relation linking that to multiple matches in another sheet. Make an inline list and link each item to the relation, the corresponding items for each category will be shown. ---
**Author:** ![dafy\_alex](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dafy_alex/32/9983_2.png) [@dafy\_alex](https://community.glideapps.com/u/dafy_alex)\ **Post date:** [July 3, 2020, 12:24pm UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/18 "2020-07-03T12:24:50Z")
That what I did previously, and it worked fine until I deleted relation columns, and recreated them. May be I have to recreate all the sheet and glide ? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 3, 2020, 12:35pm UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/19 "2020-07-03T12:35:49Z")
Did you recreate the relation with the same name as before? ---
**Author:** ![dafy\_alex](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dafy_alex/32/9983_2.png) [@dafy\_alex](https://community.glideapps.com/u/dafy_alex)\ **Post date:** [July 3, 2020, 12:49pm UTC](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247/20 "2020-07-03T12:49:33Z")
I’m not sure. I will try to retrieve the same name. [Next page](https://community.glideapps.com/t/synchronisation-de-mon-google-sheets-ne-fonctionne-pas/6247.md?page=2)