# Lookup sync problem with Google Sheets when submit **URL:** \ **Category:** Report a Bug\ **Created:** [October 23, 2019, 10:04pm UTC](https://community.glideapps.com/t/lookup-sync-problem-with-google-sheets-when-submit/1356 "2019-10-23T22:04:39Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![quangfr](https://avatars.discourse-cdn.com/v4/letter/q/439d5e/32.png) [@quangfr](https://community.glideapps.com/u/quangfr)\ **Post date:** [October 23, 2019, 10:04pm UTC](https://community.glideapps.com/t/lookup-sync-problem-with-google-sheets-when-submit/1356/1 "2019-10-23T22:04:39Z")
I tried the Lookup feature in Data with a simple case : - An USERS Sheet with NAME and EMAIL - A SUBMISSIONS Sheet with only EMAIL - A Column Relationship of EMAIL in SUBMISSIONS with USERS - A Lookup Relationship in SUBMISSIONS to get NAME from USERS sheets It doesn’t seem to sync data to Google Sheets when I submit the form. If I remove Lookup relationship, it does work. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 26, 2019, 9:12pm UTC](https://community.glideapps.com/t/lookup-sync-problem-with-google-sheets-when-submit/1356/2 "2019-10-26T21:12:11Z")
I think I can reproduce this. I tried it in staging. I added 2 records using a form button to a sheet that has a lookup column. Those rows do not show in the google sheet. Once I remove the Lookup column, it works again to submit a form, but the data is now out of sync with the sheet and seems to have overwritten the third row in the glide data (I believe it said user2 instead of blah2). Rows added while the lookup was there still do not show in the google sheet. ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9ba8d6df5f07007a10817a2d8d806dd4847bd821.jpeg) ![Capture2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1a3bcc84350810b98fbb448deb5397f27f9f069e.jpeg) ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [October 26, 2019, 9:43pm UTC](https://community.glideapps.com/t/lookup-sync-problem-with-google-sheets-when-submit/1356/3 "2019-10-26T21:43:43Z")
On it! ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [October 26, 2019, 10:41pm UTC](https://community.glideapps.com/t/lookup-sync-problem-with-google-sheets-when-submit/1356/4 "2019-10-26T22:41:20Z")
Should be fixed now. Thanks for reporting! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 26, 2019, 11:41pm UTC](https://community.glideapps.com/t/lookup-sync-problem-with-google-sheets-when-submit/1356/5 "2019-10-26T23:41:55Z")
Looks good to me!