# Using Google Sheets

**URL:** <https://community.glideapps.com/t/using-google-sheets/69381>\
**Category:** Ask for Help\
**Created:** [January 9, 2024, 2:11am UTC](https://community.glideapps.com/t/using-google-sheets/69381 "2024-01-09T02:11:01Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\
**Post date:** [January 9, 2024, 2:11am UTC](https://community.glideapps.com/t/using-google-sheets/69381/1 "2024-01-09T02:11:01Z")

</div>

Is it a good idea to use a combination of Google Sheets and Glide Sheets? Thanks again.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [January 9, 2024, 2:11am UTC](https://community.glideapps.com/t/using-google-sheets/69381/2 "2024-01-09T02:11:26Z")

</div>

yes

---

<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:** [January 9, 2024, 2:13am UTC](https://community.glideapps.com/t/using-google-sheets/69381/3 "2024-01-09T02:13:59Z")

</div>

It depends on your requirements.  
Personally, I only attach a Google Sheet when I actually need one, which is pretty rare these days.  
But everyone’s experience will be different. Again, as I said, it depends on your requirements.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [January 9, 2024, 5:23pm UTC](https://community.glideapps.com/t/using-google-sheets/69381/4 "2024-01-09T17:23:10Z")

</div>

I think it depends if the data already exists, where it lives, what your budget is, what kind of technical stack you and your team are comfortable with.

- If the data already exists in Google Sheets and needs to stay there, then you might as well leave it there.
- If the data doesn’t already exist but you know it will make things much easier if it does live in Google Sheets because colleagues will want to work with Google Sheets, because you’ll be using Google App Scripts, because you will be using integrations that work beautifully well with Google Sheets, then you can leave it there.
- If you think on the contrary you would prefer to leverage the power of Glide Tables and the integrated ecosystem of Glide (Glide AI and integrations), then you can create or move the data to Glide Tables.
- Glide’s integrated ecosystem might come at a premium and using the built-in integrations might be more expensive than setting up integrations via 3rd party tools (such as Google Sheets).
- More integrations via Google Sheets might lead to a more complex technical stack.

These comments apply to other data sources: Excel, Airtable, SQL.

As Darren said, it depends.

My preference at this stage in my development journey is to do as much as possible within Glide, mostly because I’m not comfortable with complexity. Given the choice, I prefer working within a single integrated product (Glide) rather than integrating various best-of-bread tools which could lead to a Frankenstein setup. I think it’s a question of preference.

---

<div class="post-metadata">

**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\
**Post date:** [January 9, 2024, 6:20pm UTC](https://community.glideapps.com/t/using-google-sheets/69381/5 "2024-01-09T18:20:10Z")

</div>

Thanks and I appreciate all of your comments. However, this leads me to my next question. And It is, how do I plan for the creation of the same system/app for multiple businesses? From how I understand it, I cannot use the same database for two different businesses. But the creation of the app could apply to more than one business, but the data is different.

I am thinking ahead in terms of creating an app for the Play Store and/or duplicating the same App for more than one business.

Thanks.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [January 9, 2024, 6:43pm UTC](https://community.glideapps.com/t/using-google-sheets/69381/6 "2024-01-09T18:43:55Z")

</div>

> [@Benjamin\_Strickland](#):
>
> From how I understand it, I cannot use the same database for two different businesses.

In theory you could create one app and have multiple business clients use that single app. You would need to use roles and use the company name as a role to clearly separate the data and make sure one company never sees the data of another company.

That would be the theory. In practice, you would probably hit usage limits quite rapidly. You would probably be better off creating separate apps for your business clients.

> [@Benjamin\_Strickland](#):
>
> duplicating the same App for more than one business.

Your next question could be: “If have 25 paying business customers. I update one app. How can I efficiently update the other 24?”

Currently this is not possible. It has been requested though that we have the ability to create a “parent” app and “child” apps, where updating the parent app would automatically propagate the changes to the child apps.

> [@Benjamin\_Strickland](#):
>
> creating an app for the Play Store

Glide apps aren’t meant to be distributed via App Stores.

> [@My App is on the Appstore without third parties!](https://community.glideapps.com/t/my-app-is-on-the-appstore-without-third-parties/69417/2):
>
> This is a nice use case and surely will prove valuable to those who want to distribute their Glide applications via Amazon. That being said: Glide applications are meant to be custom software internal to businesses. When a business needs to distribute an app to their employees or partners, I’m not convinced it makes sense to send them to an app store or to Amazon. Instead, why not simply send them a link (URL or QR code)? As an analogy, if a business published an internal paper manual, instead…

---

<div class="post-metadata">

**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\
**Post date:** [January 9, 2024, 6:53pm UTC](https://community.glideapps.com/t/using-google-sheets/69381/7 "2024-01-09T18:53:19Z")

</div>

As I thought, the Play Store is out. But now my understanding is clearer in terms of what I can do with Glide. Separate clients is where I am leaning, but it appears the logic for each client would be to use the same data structure but the names of the sheets would be different. Is this correct?

Thanks

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [January 9, 2024, 6:58pm UTC](https://community.glideapps.com/t/using-google-sheets/69381/8 "2024-01-09T18:58:18Z")

</div>

I can update data in multiple apps, which I do for my customers.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [January 9, 2024, 7:06pm UTC](https://community.glideapps.com/t/using-google-sheets/69381/9 "2024-01-09T19:06:15Z")

</div>

> [@Benjamin\_Strickland](#):
>
> it appears the logic for each client would be to use the same data structure but the names of the sheets would be different. Is this correct?

Separate databases (sheets, tables) and separate apps for each client. This is how I would do it.
