# Copy / paste google sheets data from glideapp
**URL:** https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583
**Category:** Ask for Help
**Created:** [August 17, 2021, 9:24am UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583 "2021-08-17T09:24:43Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Adrien\_Soviche](https://community.glideapps.com/u/Adrien_Soviche)
#### Post date: [August 17, 2021, 9:24am UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583/1 "2021-08-17T09:24:44Z")
Hi, nice to meet you dear glider community,
I’m a french user of glide app. And fresh one !
Well, i’ve looked for answer in the forum but without success.
I would my users copy/paste data from a sheet to another one in google sheet with button in glide app.
is it possible ?
is there another way to do that ? Hope you understood 🙂
Subsidiary question : is it possible to merge a new sheet in a google sheet with a function in glideapp ?
I wish you the best !!
Adrien
---
### Author:  [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [August 17, 2021, 9:38am UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583/2 "2021-08-17T09:38:02Z")
Hi @Adrien_Soviche welcome in this community.
Regarding your first question, yes it’s possibily with a button; simply you can associate an action “Add row” on your button.
With the Add Row action you can choice the sheet and feed the column with custom or existent data on your current table.
---
### Author:  [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [August 17, 2021, 9:41am UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583/3 "2021-08-17T09:41:03Z")
Regarding the second question may be the merge function is not exactly what you need.
May be you need only a relation between sheets.
Please explain me your scenario with an example.
---
### Author:  [@Adrien\_Soviche](https://community.glideapps.com/u/Adrien_Soviche)
#### Post date: [August 17, 2021, 9:48am UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583/4 "2021-08-17T09:48:03Z")
Well, thanks considering me !
This is so simple and complex together 😉
it’s about construction.
My user create a new location, for example a kitchen.
in my google sheet, there is a list of topics corresponding to the kitchen (and other sheets : one for bathroom, one for WC, and so on)
Then, when he creates the kitchen I want to copy/paste the data from kitchen to the sheet “all data”.
Then when he creates a bathroom I want to copy/paste the data from bathroom added from bathroom in “all data”.
Have you get it ?? I hope so !
---
### Author:  [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [August 17, 2021, 10:05am UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583/5 "2021-08-17T10:05:15Z")
Ok, if i understand, we can call your “All Data” sheet Home.
So, Home is composed of one or more bathroom, one or more kitchen, one or more room, and so on…
For example, whic data you need to copy from kitchen to Home (your all data sheet)? And from bathroom to Home?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 17, 2021, 11:15am UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583/6 "2021-08-17T11:15:49Z")
In addition, why do you need an “All data” sheet though?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 17, 2021, 11:59am UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583/7 "2021-08-17T11:59:03Z")
Or likewise, why do you need a sheet for each room instead of using the All Data sheet with a room column to separate the data as needed?
---
### Author:  [@Adrien\_Soviche](https://community.glideapps.com/u/Adrien_Soviche)
#### Post date: [August 21, 2021, 12:06pm UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583/8 "2021-08-21T12:06:43Z")
For example, a room will be compose with Topics as row : “Light” “Door” “window” “ceiling” “walls”… And each of this Topic will have about 15 columns : “description” “quantity” “Unit” “price”…
In the sheet “Room” all of this Topics will have values in there columns.
Then when I create a house, I will take as many room, bathroom, kitchen I need, and bring them in one big “all data”.
This “all data” allow me a lot of calculations
I copy the whole “room sheet” or the whole “kitchen sheet” anytime I need it.
I hope to be clear !
---
### Author:  [@Adrien\_Soviche](https://community.glideapps.com/u/Adrien_Soviche)
#### Post date: [August 21, 2021, 12:08pm UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583/9 "2021-08-21T12:08:00Z")
I think (maybe wrong) it should be easier to sum and calculate if it is in one single sheet.
---
### Author:  [@Adrien\_Soviche](https://community.glideapps.com/u/Adrien_Soviche)
#### Post date: [August 21, 2021, 12:09pm UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583/10 "2021-08-21T12:09:53Z")
I will make a video to explain what I do in excel that I would produce in glide 🙂
---
### Author:  [@Fleau75](https://community.glideapps.com/u/Fleau75)
#### Post date: [May 15, 2022, 7:57am UTC](https://community.glideapps.com/t/copy-paste-google-sheets-data-from-glideapp/30583/11 "2022-05-15T07:57:19Z")
Hello,
Weird, but I can’t paste data from an Excel document into Glide?
I tried to do by column by not putting too much data (about ten) and I don’t have the “paste” functionality by right clicking on Glide and the “Ctrl V” doesn’t work either. Is there a specific manipulation to do? My Glide table is big enough though.