# User data back to Google Sheet?

**URL:** <https://community.glideapps.com/t/user-data-back-to-google-sheet/528>\
**Category:** Feature Requests\
**Created:** [September 23, 2019, 9:01pm UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528 "2019-09-23T21:01:58Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![dsak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dsak/32/402_2.png) [@dsak](https://community.glideapps.com/u/dsak)\
**Post date:** [September 23, 2019, 9:01pm UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528/1 "2019-09-23T21:01:58Z")

</div>

Is there a way that the people using my app can have their data all go back to my original sheet?

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [September 23, 2019, 9:20pm UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528/2 "2019-09-23T21:20:25Z")

</div>

That is the idea. The can add an existing row of data or add a new one. You control if they can edit or add in your Glide app, and what data they can edit and/or add.

---

<div class="post-metadata">

**Author:** ![dsak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dsak/32/402_2.png) [@dsak](https://community.glideapps.com/u/dsak)\
**Post date:** [September 23, 2019, 9:25pm UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528/3 "2019-09-23T21:25:22Z")

</div>

My problem is that when Privacy is set to Google email, it actually writes the data to a different sheet under their account, and not my original sheet. I can see the data in the database, but it does not modify my original sheet?

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [September 23, 2019, 10:02pm UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528/4 "2019-09-23T22:02:28Z")

</div>

Scroll down.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [September 24, 2019, 1:38am UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528/5 "2019-09-24T01:38:15Z")

</div>

Have you actually seen the data in their spreadsheet? What David is saying is that it may be in your spreadsheet but as the last row, with a whole bunch of blanks above the new data. This happens when you use arrayformulas of other formulas that write all the way down a column even if it writes blank data. To test this delete all the empty rows below where your data stops. If you add a new piece of data it will append a new row and be at the bottom of your data.

---

<div class="post-metadata">

**Author:** ![jesschrist](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jesschrist/32/86_2.png) [@jesschrist](https://community.glideapps.com/u/jesschrist)\
**Post date:** [September 24, 2019, 3:25am UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528/6 "2019-09-24T03:25:07Z")

</div>

I stick to using the details view and only allowing edits to existing info rather than users adding new entries. this means only one line per user and that you have to pre-add emails to that particular screen/sheet.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [September 24, 2019, 3:54am UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528/7 "2019-09-24T03:54:06Z")

</div>

Allowing the user to add items is critical for a lot of apps. Depending on the app there are plenty of reasons to have the users add rows to a sheet. If you have a whitelisted app, obviously you would have to preload those emails. But if your app was asking the users to say rate a restaurant for example. And leave a specific comment about the place, you would want them to be able to add a row to a sheet.

---

<div class="post-metadata">

**Author:** ![jesschrist](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jesschrist/32/86_2.png) [@jesschrist](https://community.glideapps.com/u/jesschrist)\
**Post date:** [September 24, 2019, 4:06am UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528/8 "2019-09-24T04:06:20Z")

</div>

I was under the impression that he wanted the information modified. ok

---

<div class="post-metadata">

**Author:** ![dsak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dsak/32/402_2.png) [@dsak](https://community.glideapps.com/u/dsak)\
**Post date:** [September 24, 2019, 7:48pm UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528/9 "2019-09-24T19:48:08Z")

</div>

Thanks! 😳

---

<div class="post-metadata">

**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\
**Post date:** [February 9, 2021, 9:24pm UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528/10 "2021-02-09T21:24:25Z")

</div>

Archiving topic

---

<div class="post-metadata">

**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\
**Post date:** [February 9, 2021, 9:24pm UTC](https://community.glideapps.com/t/user-data-back-to-google-sheet/528/11 "2021-02-09T21:24:28Z")

</div>


