# Create new Google Sheet on Entry

**URL:** https://community.glideapps.com/t/create-new-google-sheet-on-entry/12788
**Category:** Ask for Help
**Created:** [July 19, 2020, 5:00pm UTC](https://community.glideapps.com/t/create-new-google-sheet-on-entry/12788 "2020-07-19T17:00:23Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Coupons\_Deal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/coupons_deal/32/9734_2.png) [@Coupons\_Deal](https://community.glideapps.com/u/Coupons_Deal)
#### Post date: [July 19, 2020, 5:00pm UTC](https://community.glideapps.com/t/create-new-google-sheet-on-entry/12788/1 "2020-07-19T17:00:23Z")

</div>

Is it possible to Create a new Google spreadsheet from a existing template when new row is added in another spreadsheet?

And also is it possible to show the spread sheet (readonly) in glideapps like in webview or some other sort?

---

<div class="post-metadata">

### Author: ![Nadir\_Abdelrahman\_MD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nadir_abdelrahman_md/32/5237_2.png) [@Nadir\_Abdelrahman\_MD](https://community.glideapps.com/u/Nadir_Abdelrahman_MD)
#### Post date: [July 19, 2020, 5:15pm UTC](https://community.glideapps.com/t/create-new-google-sheet-on-entry/12788/2 "2020-07-19T17:15:42Z")

</div>

Sorry not clear what you are trying to do. Can you please explain more. There is way to do it using Google script if only creating new sheet

---

<div class="post-metadata">

### Author: ![Coupons\_Deal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/coupons_deal/32/9734_2.png) [@Coupons\_Deal](https://community.glideapps.com/u/Coupons_Deal)
#### Post date: [July 19, 2020, 7:31pm UTC](https://community.glideapps.com/t/create-new-google-sheet-on-entry/12788/3 "2020-07-19T19:31:28Z")

</div>

1 Template SpreadSheet - This is just a template of which i want to make copies of every time a new row is added.

App Spreadsheet - This is where user will insert data from.

For each new data entry, a spreadsheet is created from Template Spreadsheet and based on the formula’s the data is filled from the data entry by user in App Spreadsheet. This template sheet is basically a predefined designed sheet.

Example:  
Lets say my app capture students data like Name, Email, Grade. As a new entry is added, a new spreadsheet from Template per student is create and added the Name, Email… data captured by App into this new sheet.

---

<div class="post-metadata">

### Author: ![Nadir\_Abdelrahman\_MD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nadir_abdelrahman_md/32/5237_2.png) [@Nadir\_Abdelrahman\_MD](https://community.glideapps.com/u/Nadir_Abdelrahman_MD)
#### Post date: [July 20, 2020, 5:16am UTC](https://community.glideapps.com/t/create-new-google-sheet-on-entry/12788/4 "2020-07-20T05:16:26Z")

</div>

There are two options I think.

1. Use google script to do that
2. You use google spreadsheet as a database, and use relations to obtain information about your students in one place, rather than creating anew spreadsheet  
Just a thought.
