# Platform - Multiple users, one spreadsheet base, different projects

**URL:** <https://community.glideapps.com/t/platform-multiple-users-one-spreadsheet-base-different-projects/22856>\
**Category:** Ask for Help\
**Created:** [February 16, 2021, 2:16am UTC](https://community.glideapps.com/t/platform-multiple-users-one-spreadsheet-base-different-projects/22856 "2021-02-16T02:16:44Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![SKuan](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@SKuan](https://community.glideapps.com/u/SKuan)\
**Post date:** [February 16, 2021, 2:16am UTC](https://community.glideapps.com/t/platform-multiple-users-one-spreadsheet-base-different-projects/22856/1 "2021-02-16T02:16:45Z")

</div>

Hello all!  
I have a Google financial spreadsheet which I would like to use it as a base for a platform, on a SaaS model. Is Glide able to do the following tasks?  
• Build an interface based on a Google spreadsheet (with a lot and complexes formulas and links), this interface would collect the users input, then the spreadsheet calculates the information and deliver the results of the project on a webpage.  
• Every new user would be able to access and update his own version of the project and cannot see other users’ data/info. I believe this point is critical because I would need to replicate the master Google spreadsheet calculations for each of the users, instead of having one spreadsheet in common for all users.

Thanks,  
Kuan

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 16, 2021, 2:30am UTC](https://community.glideapps.com/t/platform-multiple-users-one-spreadsheet-base-different-projects/22856/2 "2021-02-16T02:30:45Z")

</div>

> [@SKuan](#):
>
> Build an interface based on a Google spreadsheet (with a lot and complexes formulas and links), this interface would collect the users input, then the spreadsheet calculates the information and deliver the results of the project on a webpage.

Yes, possible.

> [@SKuan](#):
>
> Every new user would be able to access and update his own version of the project and cannot see other users’ data/info. I believe this point is critical because I would need to replicate the master Google spreadsheet calculations for each of the users, instead of having one spreadsheet in common for all users.

Yes, Glide has a number of [Security Features](https://docs.glideapps.com/all/guides/security-center) such as [Row Owners](https://docs.glideapps.com/all/reference/security-and-per-user-data/row-owners) and [Role Based Access](https://docs.glideapps.com/all/guides/security-center/role-based-security) that will help achieve this goal. You will most likely need a [Private Pro version](https://www.glideapps.com/pricing), as some of the features you’ll need only come with that plan.

---

<div class="post-metadata">

**Author:** ![SKuan](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@SKuan](https://community.glideapps.com/u/SKuan)\
**Post date:** [February 16, 2021, 5:00am UTC](https://community.glideapps.com/t/platform-multiple-users-one-spreadsheet-base-different-projects/22856/3 "2021-02-16T05:00:47Z")

</div>

Thanks for your reply @Darren_Murphy, I will take a look at these functions. As I have not started any app set up yet, do you think it would be better to wait the new Glide 2021 update to start my app or does not make any difference?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 16, 2021, 5:32am UTC](https://community.glideapps.com/t/platform-multiple-users-one-spreadsheet-base-different-projects/22856/4 "2021-02-16T05:32:40Z")

</div>

It won’t make any difference. Although the builder experience is changing, all the underlying functions and components will be the same. You can start using the new builder now, if you want…

 ![Screen Shot 2021-02-16 at 1.31.58 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bd5d13e262cb342013dfe5b3737603b858faeefd.png)

---

<div class="post-metadata">

**Author:** ![SKuan](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@SKuan](https://community.glideapps.com/u/SKuan)\
**Post date:** [February 16, 2021, 6:12am UTC](https://community.glideapps.com/t/platform-multiple-users-one-spreadsheet-base-different-projects/22856/5 "2021-02-16T06:12:44Z")

</div>

Great, thanks for the help @Darren_Murphy !

---

<div class="post-metadata">

**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 16, 2021, 1:08pm UTC](https://community.glideapps.com/t/platform-multiple-users-one-spreadsheet-base-different-projects/22856/6 "2021-02-16T13:08:05Z")

</div>

> [@SKuan](#):
>
> replicate the master Google spreadsheet calculations for each of the users, instead of having one spreadsheet in common for all users.

Just to be clear, you will still need to have data in one google sheet. You can’t connect the app to multiple google sheets. You can still have data separation with row owners, but all user data will need to be together.

---

<div class="post-metadata">

**Author:** ![SKuan](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@SKuan](https://community.glideapps.com/u/SKuan)\
**Post date:** [February 17, 2021, 1:40am UTC](https://community.glideapps.com/t/platform-multiple-users-one-spreadsheet-base-different-projects/22856/8 "2021-02-17T01:40:40Z")

</div>

Thanks @Jeff_Hager . I would have to figure something out how to work with this, the calculations on my spreadsheet are based in just one user data/project, therefore it will show just the project results for one owner / row. I do not know what would happen if multiple users update their data at the same time, as the spreadsheet can only process one project per time. Cheers

---

<div class="post-metadata">

**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/platform-multiple-users-one-spreadsheet-base-different-projects/22856/9 "2024-01-17T16:53:28Z")

</div>


