# Changing Google Sheet for Existing App **URL:** \ **Category:** Ask for Help\ **Created:** [October 24, 2021, 10:13pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550 "2021-10-24T22:13:58Z")\ **Posts on this page:** 14\ **Page:** 2
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [December 16, 2021, 11:23am UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/21 "2021-12-16T11:23:23Z")
From your screenshot it looks like you might have some columns missing that were in the original. In the editor, under sharing, you could allow anyone to make the app copyable. If it’s a pro app you’ll have to make a duplicate first and then the duplicated app on free plan can be copied. Alternatively you could downgrade a pro app, make app copyable, and then upgrade again. ---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 16, 2021, 11:29am UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/22 "2021-12-16T11:29:49Z")
> [@Test\_Test](#): > > As part of the Glide app development process, I’ll surely add Glide columns as well as (perhaps) Glide tables. Will these survive the data-source change, including all links, relations, layouts and interactions? If they don’t survive, I’m not sure how can you go-live with a pre-existing system. Hi @Eric_Penn, Could you please assist us with this dilemma? Perhaps you can share some light on other issues to pay attention to so this transition will work smoothly. I’d hate to have to do all the work twice… 🙂 Thanks ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [December 16, 2021, 11:39am UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/23 "2021-12-16T11:39:57Z")
I’m pretty sure if you have glide computed columns that live in a glide table then those columns won’t make it through a duplication process. I don’t use glide tables but that was the case last time I checked. If you are simply trying to replace the sheet with an IDENTICAL sheet then it should work. It’s always a good idea to work inside a duplicate copy if possible or at least make a duplicate before you start. My other advice would be never press the “sync and remove features” button. If you ever see that message, which you shouldn’t, try replacing the sheet again with the original and wait for sync. I’ve used the replace data source feature a lot and it has worked for me. ---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 16, 2021, 12:28pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/24 "2021-12-16T12:28:51Z")
> [@Eric\_Penn](#): > > I don’t use glide tables but that was the case last time I checked. The question is regarding Google Sheets as the data source, not Glide Tables 🙂 ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [December 16, 2021, 12:35pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/25 "2021-12-16T12:35:16Z")
> [@Test\_Test](#): > > I’ll surely add Glide columns as well as (perhaps) Glide tables. Will these survive the data-source change, including all links, relations, layouts and interactions? I should clarify if you make a duplicate the computed columns in glide table won’t transfer. Everything else should be fine as long as your structure is identical. I encourage you to make a copy and try for yourself. Give the sheets different names so you could easily detect when the replace is successful. ---
**Author:** ![George-Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george-glide/32/22384_2.png) [@George-Glide](https://community.glideapps.com/u/George-Glide)\ **Post date:** [December 16, 2021, 3:01pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/26 "2021-12-16T15:01:19Z")
Glide uses Google Sheets, sheet tabs, and column UUID’s to sync data between Google Sheets and the Glide native tables. It does not use Google Sheet names, sheet tab names, or column header (row 1) names to link the respective parts of the sheet. However, when you replace one sheet with another, Settings\>\>Data Data sources (3 dot menu) Replace, as long as you are not already in a miss-matched sync condition, the matchup will be by sheet tab, and column header names. So if you make a duplicate of a sheet tab, and then delete the original and rename the duplicate tab to what the original name was, Glide will not recognize that duplicate tab as a valid match and display that sheet tab as missing all columns. As suggested by others it is always a good idea to make duplicates of live apps and test them before you try anything on live apps. ---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 16, 2021, 3:59pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/27 "2021-12-16T15:59:16Z")
> [@George-Glide](#): > > Settings\>\>Data Data sources (3 dot menu) Replace, as long as you are not already in a miss-matched sync condition, the matchup will be by sheet tab, and column header names. Many thanks for this detailed response. It’s probably just me, but I am now confused. Starting from a live Google Sheet system. The scenario was to make a copy of that system, without sharing the copy. Then I’ll program a Glide App based on that copy. Once finished, I’ll stop sharing the original live system (which has of course added new data since I made a copy of it). Once sharing is disabled, I’ll go back to the Glide App and change the data source to the “real” sheet, instead of the “frozen copy”. Now, what will happen? Glide columns will surely be added during the programing, as well as form and other elements unique to Glide. Will these survive, including references, actions, etc? If not, how do you migrate to Glide from a live Google Sheets? It’s not possible to take the system down for the entire duration of the programing. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 16, 2021, 4:09pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/28 "2021-12-16T16:09:02Z")
> [@Test\_Test](#): > > Once sharing is disabled, I’ll go back to the Glide App and change the data source to the “real” sheet, instead of the “frozen copy”. Now, what will happen? > Glide columns will surely be added during the programing, as well as form and other elements unique to Glide. Will these survive, including references, actions, etc? We appear to have come full circle 🙂 When you say “Glide columns will surely be added”, are you referring to Glide Computed columns? These will survive, as will all actions/components/etc that refer to them. _As long as_ the basic (sheet based columns) are still there. As I said way back here… > [@Darren\_Murphy](#): > > Glide computed columns and relations, etc will survive large chunks of data being added/removed, as long as the sheet column headings remain intact. The only thing you really need to worry about are columns that get renamed or removed in your master sheet while you’re working on the copy. As long as you can keep that under control, then you should be fine. ---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 16, 2021, 4:17pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/29 "2021-12-16T16:17:06Z")
> [@Darren\_Murphy](#): > > We appear to have come full circle 🙂 What throw me off was the post from @George-Glide. As I said > [@Test\_Test](#): > > It’s probably just me, but I am now confused. I’m fairing sure we’re indeed coming a full circle, but I am confused 🙂 ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [December 16, 2021, 4:50pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/30 "2021-12-16T16:50:17Z")
---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 16, 2021, 6:11pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/31 "2021-12-16T18:11:59Z")
Thanks for taking the time to record this video. Awesome! ---
**Author:** ![George-Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george-glide/32/22384_2.png) [@George-Glide](https://community.glideapps.com/u/George-Glide)\ **Post date:** [December 16, 2021, 7:16pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/32 "2021-12-16T19:16:52Z")
My recommendation would be to use the Publish feature and do small incremental changes to the live application, and publish often. Before publishing in the live app, and for testing, make duplicates of the live app. Test in the duplicate to be sure all of your changes are working. Then go back to the live app and publish it. This method would be much cleaner than sheet replacement which as you can see could cause all kinds of issues. ---
**Author:** ![Vitor\_Guimaraes](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vitor_guimaraes/32/39703_2.png) [@Vitor\_Guimaraes](https://community.glideapps.com/u/Vitor_Guimaraes)\ **Post date:** [July 17, 2024, 8:24pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/33 "2024-07-17T20:24:15Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a9923b263838d03d00a6c6ec27d89c64b0538973.png) I’m trying to replace a sheet for an identical one, but it is not recognizing the columns… Any tips? ---
**Author:** ![Vitor\_Guimaraes](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vitor_guimaraes/32/39703_2.png) [@Vitor\_Guimaraes](https://community.glideapps.com/u/Vitor_Guimaraes)\ **Post date:** [July 17, 2024, 9:07pm UTC](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550/34 "2024-07-17T21:07:53Z")
> **[How do I change the email address of my Glide account? | Glide Help Center](https://help.glideapps.com/en/articles/9168110-how-do-i-change-the-email-address-of-my-glide-account)** > > Changing the email address you sign into Glide with This page helped me out, so I’ll post it here [Previous page](https://community.glideapps.com/t/changing-google-sheet-for-existing-app/33550.md?page=1)