# Share only a table on google sheet

**URL:** <https://community.glideapps.com/t/share-only-a-table-on-google-sheet/34918>\
**Category:** Ask for Help\
**Created:** [November 22, 2021, 5:27pm UTC](https://community.glideapps.com/t/share-only-a-table-on-google-sheet/34918 "2021-11-22T17:27:07Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Riccardo\_Alati](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/riccardo_alati/32/22936_2.png) [@Riccardo\_Alati](https://community.glideapps.com/u/Riccardo_Alati)\
**Post date:** [November 22, 2021, 5:27pm UTC](https://community.glideapps.com/t/share-only-a-table-on-google-sheet/34918/1 "2021-11-22T17:27:07Z")

</div>

Hi everybody!  
i need to share only one sheet of my google sheet to one person. ( this person has to import all the data in that specifit sheet but i don’t want to allowed him to see all the app data in the other sheet)  
any ideas ?

---

<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:** [November 22, 2021, 6:17pm UTC](https://community.glideapps.com/t/share-only-a-table-on-google-sheet/34918/2 "2021-11-22T18:17:42Z")

</div>

I think I would create a separate Google Sheet and use =importrange().

If the person can input the data via a form (row by row, no bulk upload here), you could also create a form in your Glide app.

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [November 22, 2021, 6:20pm UTC](https://community.glideapps.com/t/share-only-a-table-on-google-sheet/34918/3 "2021-11-22T18:20:37Z")

</div>

You could use visible conditions on the tabs in the app.  
If its an Email sign-in app, and its just one person, then exclude his email from all the other tabs using visible condition.  
you could even set a “role” in your Users sheet and and assign it to this specific user and then use it a a visible condition on your app tabs.

---

<div class="post-metadata">

**Author:** ![Riccardo\_Alati](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/riccardo_alati/32/22936_2.png) [@Riccardo\_Alati](https://community.glideapps.com/u/Riccardo_Alati)\
**Post date:** [November 22, 2021, 6:42pm UTC](https://community.glideapps.com/t/share-only-a-table-on-google-sheet/34918/4 "2021-11-22T18:42:59Z")

</div>

the person want to write on a google sheet cause he has to write lot of row

---

<div class="post-metadata">

**Author:** ![Riccardo\_Alati](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/riccardo_alati/32/22936_2.png) [@Riccardo\_Alati](https://community.glideapps.com/u/Riccardo_Alati)\
**Post date:** [November 22, 2021, 6:44pm UTC](https://community.glideapps.com/t/share-only-a-table-on-google-sheet/34918/5 "2021-11-22T18:44:19Z")

</div>

thank you, il will try with import function cause the person ha to load lot of row so he prefere to do it from the sheet and not from the app

---

<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:** [November 22, 2021, 6:45pm UTC](https://community.glideapps.com/t/share-only-a-table-on-google-sheet/34918/6 "2021-11-22T18:45:34Z")

</div>

> [@Riccardo\_Alati](#):
>
> the person want to write on a google sheet cause he has to write lot of row

In that case I would create a separate Google Sheet and use =importrange().

---

<div class="post-metadata">

**Author:** ![Riccardo\_Alati](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/riccardo_alati/32/22936_2.png) [@Riccardo\_Alati](https://community.glideapps.com/u/Riccardo_Alati)\
**Post date:** [November 22, 2021, 6:54pm UTC](https://community.glideapps.com/t/share-only-a-table-on-google-sheet/34918/7 "2021-11-22T18:54:21Z")

</div>

now it works. thank you a lot

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 23, 2021, 6:54pm UTC](https://community.glideapps.com/t/share-only-a-table-on-google-sheet/34918/8 "2021-11-23T18:54:40Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
