# How to retrieve data after duplicating and relation in Google sheets **URL:** \ **Category:** Ask for Help\ **Created:** [February 22, 2021, 11:21pm UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252 "2021-02-22T23:21:16Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\ **Post date:** [February 22, 2021, 11:21pm UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/1 "2021-02-22T23:21:16Z")
Hello the Glide Community! 👋🏼 I am sending this message since I need some help. I face a problem between Glide and Google sheets. To explain more my issue, I am using Stripe and I duplicated the App : Sales sheet to a separate sheet called Sales by using this formula ={‘App: Sales’!A:Z} From glide, I did some relation and lookup in this separate sheet called Sales. However I cannot see the data in Google sheets. I need these data for sending zaps with zapier. Is anyone may help me please ? Or suggest me solutions ? Thanks in advance, Regards ---
**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:** [February 22, 2021, 11:29pm UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/2 "2021-02-22T23:29:49Z")
The relation & lookup data columns are Glide-calculated columns so you won’t see them in the sheet. To be able to have that value in your sheet, you should create a vlookup arrayformula. ---
**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\ **Post date:** [February 23, 2021, 9:06am UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/3 "2021-02-23T09:06:54Z")
Thanks for your response ! @ThinhDinh Could you please tell me how may I create the vlookup arrayformula ? Regards ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 23, 2021, 9:17am UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/4 "2021-02-23T09:17:47Z")
to see data from glide tables or user specific columns, you have to write them to google sheets using any action with set columns. ---
**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\ **Post date:** [February 23, 2021, 11:18am UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/5 "2021-02-23T11:18:27Z")
Thanks for your response @Uzo could you please give an example ? or tell me how I can do this ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 23, 2021, 11:28am UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/6 "2021-02-23T11:28:32Z")
![Screen Shot 2021-02-23 at 6.26.18 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/ac67c4e51347fccea8c45bed517750622e6d9fc9.png) . . ![Screen Shot 2021-02-23 at 6.24.28 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c8d0441f011dddb965f364619f59b6b367d9c797.png) ---
**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:** [February 23, 2021, 12:34pm UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/7 "2021-02-23T12:34:00Z")
You can read more about arrayformula here. > [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727): > > Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. > > > **1/ Definition** > > > > Arrayformula is defined as “a range, mathematical expression using one cell range … ---
**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\ **Post date:** [February 23, 2021, 6:13pm UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/8 "2021-02-23T18:13:12Z")
Hello, I am not sure that these answers above may fix the issue. I cannot see the column created from glide in Google Sheets. Please see the screenshots. Could you please see and advise ? Column created in glide ![Capture columm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fba8ca30f584e79440eb2a4399e851daaf3ede1a.png) Column not visible in google sheets ![Capture columm google](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d7947f251972a734ee3d0ac1d0403677a3da1206.png) Regards ---
**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:** [February 23, 2021, 6:23pm UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/9 "2021-02-23T18:23:24Z")
Glide columns, such as relation, lookup, math, template, etc. Will not be visible in a google sheet. They are columns that are calculated on the fly, and actually are calculated on each individual user’s device. They are not columns of data in the traditional sense. What you see in those columns is being calculated in real time. Those values are not stored anywhere, and because of that, none of the values from those glide computed columns will appear in a google sheet. What is being mentioned in the previous posts is that you need to create separate formulas in your Google sheets if you need those same values in your Google sheet ---
**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\ **Post date:** [February 23, 2021, 9:52pm UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/10 "2021-02-23T21:52:18Z")
Sure I got it thanks @Jeff_Hager@ThinhDinh ! 😃 I am trying to use vlookup to retrieve data from a sheets but I need some help for the syntax of formula. I put an example of my google sheets. In my case I would like to display Vendor, Price, TAX, Commission, Price final in App : Sales sheets from Products sheet. In both sheets I have ID product to do the link. Letting you know my data come at the end of the sheets. > **[Vlookup](https://docs.google.com/spreadsheets/d/1xBESQZUWrVO93j_VVYgPNO588vC7OOhdDTQgUTgeHEM/edit?usp=sharing)** > > Products > > Name,Category,Description,Price,TAX,Commission,Price final,Vendor,Image 1,Image 2,Image 3,Link,Date Added,🔒ID product > Nouille,Asian food,Nouille avec son canard lacké,100,00 €,0,20 €,20,00 €,120,00 €,galerie@gmail.com,\ **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:** [February 23, 2021, 11:26pm UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/11 "2021-02-23T23:26:19Z") Can you share the editing rights to [ariesarsenal@gmail.com](mailto:ariesarsenal@gmail.com)? I can only view as of now. ---
**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\ **Post date:** [February 24, 2021, 8:28am UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/12 "2021-02-24T08:28:43Z")
Sure @ThinhDinh I shared the editing rights to [ariesarsenal@gmail.com](mailto:ariesarsenal@gmail.com) ---
**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\ **Post date:** [February 24, 2021, 8:33am UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/13 "2021-02-24T08:33:56Z")
Also I shared the editing rights to everyone ---
**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:** [February 24, 2021, 8:38am UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/14 "2021-02-24T08:38:43Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a9be83b69d06a5a0b661ca3e5b27ea256bb0ee2d.png) It has been done for you. The arrayformula takes the product ID in column D, looks to the Products sheet and returns column D, E, F, G through a temporary data table containing columns N, D, E, F, G of the Products sheet. ---
**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\ **Post date:** [February 24, 2021, 8:51am UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/15 "2021-02-24T08:51:37Z")
Thanks @ThinhDinh for your quick help ! just to understand what does that mean {2\3\4\5} ? Also do you know why when there are a formula in the sheet, the rows come at the end of the sheets after been added from glide ? Could you please tell how the rows can come at the beginning ? ---
**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:** [February 24, 2021, 8:52am UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/16 "2021-02-24T08:52:57Z")
The temporary data table goes N, D, E, F, G. I want to return D, E, F, G and their order is 2nd, 3rd, 4th, 5th. When you use arrayformulas, you must delete all empty rows, because weirdly the Google API doesn’t see those as empty rows and writes the new rows at the end of the Sheet. ---
**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\ **Post date:** [February 24, 2021, 8:55am UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/17 "2021-02-24T08:55:49Z")
Thank you a lot !! So I have to delete all empty rows every time or once ? ---
**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:** [February 24, 2021, 8:57am UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/18 "2021-02-24T08:57:04Z")
You can just delete them all now, then the Google API will just add one row at a time at the bottom. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/how-to-retrieve-data-after-duplicating-and-relation-in-google-sheets/23252/19 "2024-01-17T16:53:19Z")