# Google sheets per user
**URL:** https://community.glideapps.com/t/google-sheets-per-user/65949
**Category:** Ask for Help
**Created:** [September 9, 2023, 2:59pm UTC](https://community.glideapps.com/t/google-sheets-per-user/65949 "2023-09-09T14:59:46Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@AlpacaPie](https://community.glideapps.com/u/AlpacaPie)
#### Post date: [September 9, 2023, 2:59pm UTC](https://community.glideapps.com/t/google-sheets-per-user/65949/1 "2023-09-09T14:59:46Z")
Hi,
I am looking to make a service app, ideally I would like users to connect their own Google Sheets, if that’s not possible I would like each user to read/write his own “sheet” inside my Google Sheet.
I am currently thinking the only way is that I will have to duplicate my app for each user and have a dedicated Google sheet for them.
Other suggestions are always welcome.
Thanks community.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 9, 2023, 3:04pm UTC](https://community.glideapps.com/t/google-sheets-per-user/65949/2 "2023-09-09T15:04:35Z")
Keep all users in the same sheet/table, and use Row Owners.
> **[Row Owners](https://www.glideapps.com/docs/essentials/security-and-user-data/row-owners)**
>
> A secure way to restrict access to certain rows.
---
### Author:  [@AlpacaPie](https://community.glideapps.com/u/AlpacaPie)
#### Post date: [September 9, 2023, 3:10pm UTC](https://community.glideapps.com/t/google-sheets-per-user/65949/3 "2023-09-09T15:10:25Z")
Thank you Darren for the quick reply, I will have a look into it.
In general, if users are row owners and they write data to my Sheet does that mean each row they are inserting makes them the row owners? if not, do I have to set this up?
Alon
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 9, 2023, 3:16pm UTC](https://community.glideapps.com/t/google-sheets-per-user/65949/4 "2023-09-09T15:16:45Z")
Make sure you have one column in the table that their email address is written into, and make that column a Row Owner.
---
### Author:  [@Fred\_Marker](https://community.glideapps.com/u/Fred_Marker)
#### Post date: [September 9, 2023, 4:32pm UTC](https://community.glideapps.com/t/google-sheets-per-user/65949/5 "2023-09-09T16:32:37Z")
@AlpacaPie FYI: all user data is saved to the Google sheet that is stored on YOUR Google drive. So you have their data. Better to use Glide tables that are saved to the cloud.
---
### Author:  [@AlpacaPie](https://community.glideapps.com/u/AlpacaPie)
#### Post date: [September 9, 2023, 5:05pm UTC](https://community.glideapps.com/t/google-sheets-per-user/65949/6 "2023-09-09T17:05:57Z")
Yes I figured that will be the best thing to do in this case.
Thank you very much guys.
---
### Author:  [@AlpacaPie](https://community.glideapps.com/u/AlpacaPie)
#### Post date: [September 9, 2023, 5:47pm UTC](https://community.glideapps.com/t/google-sheets-per-user/65949/7 "2023-09-09T17:47:03Z")
Actually as more of a general question and I might start it as a topic, I am not looking for the app to be shared across the users, I am trying to make a service for each one individually.
For that do you suggest making a Glide table for each user?
Also, can I get rid of the “Users” tab in this case?
I am playing around the app and mostly understand the concept, however, I am not sure about best practices.
Thanks again 🙂
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 9, 2023, 6:03pm UTC](https://community.glideapps.com/t/google-sheets-per-user/65949/8 "2023-09-09T18:03:10Z")
> [@How to share apps with different values for each employee](https://community.glideapps.com/t/how-to-share-apps-with-different-values-for-each-employee/64950/4):
>
> Here’s your options: Use row owners so each user can only access their own data in shared tables. Use filters, which are not nearly as secure as row owners. Build separate apps…one for each user. Use one app, but keep adding separate tables, and duplicate all screens and functionality in the app every time you add a new user. Row owners is going to be the absolute best and simplest solution.
---
### Author:  [@AlpacaPie](https://community.glideapps.com/u/AlpacaPie)
#### Post date: [September 9, 2023, 6:07pm UTC](https://community.glideapps.com/t/google-sheets-per-user/65949/9 "2023-09-09T18:07:08Z")
Cheers everyone, if there’s any other way I can say thanks and promote you guys let me know.
Great community and support!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [September 16, 2023, 6:07pm UTC](https://community.glideapps.com/t/google-sheets-per-user/65949/10 "2023-09-16T18:07:15Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.