# Adding second google sheet

**URL:** <https://community.glideapps.com/t/adding-second-google-sheet/31090>\
**Category:** Ask for Help\
**Created:** [August 29, 2021, 5:18am UTC](https://community.glideapps.com/t/adding-second-google-sheet/31090 "2021-08-29T05:18:37Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\
**Post date:** [August 29, 2021, 5:18am UTC](https://community.glideapps.com/t/adding-second-google-sheet/31090/1 "2021-08-29T05:18:37Z")

</div>

I started my app with a Google sheet and now have moved onto almost fully using glide table, including new user signing up.

Now I have a need to process data coming from another Googlesheet. Instead of copying this sheet into my old sheet, I want to just have access to the new sheet as it is managed by someone else.

How can I link this new Googlesheet into my current APP?

Thanks

---

<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:** [August 29, 2021, 7:00am UTC](https://community.glideapps.com/t/adding-second-google-sheet/31090/2 "2021-08-29T07:00:01Z")

</div>

The easiest way is with [IMPORTRANGE](https://support.google.com/docs/answer/3093340?hl=en)

---

<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:** [August 29, 2021, 11:33am UTC](https://community.glideapps.com/t/adding-second-google-sheet/31090/3 "2021-08-29T11:33:31Z")

</div>

Do you want to bring data into your existing Google sheet, or just change the source sheet of the app?

> **[Introduction to the Data Editor](https://docs.glideapps.com/all/reference/data-editor/introduction-to-the-data-editor#changing-your-source-sheet)**
>
> Learn the basics of Glide's Data Editor

---

<div class="post-metadata">

**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\
**Post date:** [August 29, 2021, 11:37am UTC](https://community.glideapps.com/t/adding-second-google-sheet/31090/4 "2021-08-29T11:37:13Z")

</div>

the GS is managed by another person and will be updated on monthly basis. I will use one of my existing app to pull in data and process as required. I do not wish to copy the data over every month so I want to process at source.

---

<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:** [August 29, 2021, 11:59am UTC](https://community.glideapps.com/t/adding-second-google-sheet/31090/5 "2021-08-29T11:59:40Z")

</div>

Neither method mentioned above would require you to manually copy data. It wasn’t clear to me if you wanted to use an import formula to automatically have the data, and any updates, pulled into your existing sheet or if you wanted to have your app directly point to that other sheet instead of the existing sheet. Either way, you wouldn’t have to manually copy anything.

---

<div class="post-metadata">

**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\
**Post date:** [August 29, 2021, 12:03pm UTC](https://community.glideapps.com/t/adding-second-google-sheet/31090/6 "2021-08-29T12:03:47Z")

</div>

Now I have updated my APP to only use Glide Table. So this new request comes in to process data from a Google sheet. What is best practice, keeping in mind GS will be updated monthly. Thanks

---

<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:** [August 29, 2021, 12:07pm UTC](https://community.glideapps.com/t/adding-second-google-sheet/31090/7 "2021-08-29T12:07:56Z")

</div>

Either method above will allow you access to the data in your app.

---

<div class="post-metadata">

**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\
**Post date:** [August 29, 2021, 12:40pm UTC](https://community.glideapps.com/t/adding-second-google-sheet/31090/8 "2021-08-29T12:40:23Z")

</div>

ok. I have read and see how to do it…so in this case, if I change the GS, it will not impact the users profile or the way Users have been signing-in right? my app is LIVE so i am being extremely cautious 🤣

---

<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:** [August 29, 2021, 12:59pm UTC](https://community.glideapps.com/t/adding-second-google-sheet/31090/9 "2021-08-29T12:59:18Z")

</div>

I would maybe make a duplicate copy and try it on the duplicate first, but if you’ve converted everything to glide tables already and aren’t currently using the google sheet for anything in your app, then I don’t think it would cause any problems to switch the sheet source.

---

<div class="post-metadata">

**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\
**Post date:** [August 29, 2021, 1:05pm UTC](https://community.glideapps.com/t/adding-second-google-sheet/31090/10 "2021-08-29T13:05:50Z")

</div>

thanks. Making duplicate and testing out would be best 👍
