# Show users in Google Sheets **URL:** \ **Category:** Ask for Help\ **Created:** [September 7, 2022, 12:59pm UTC](https://community.glideapps.com/t/show-users-in-google-sheets/48792 "2022-09-07T12:59:18Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Innovations\_Imob](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/innovations_imob/32/47439_2.png) [@Innovations\_Imob](https://community.glideapps.com/u/Innovations_Imob)\ **Post date:** [September 7, 2022, 12:59pm UTC](https://community.glideapps.com/t/show-users-in-google-sheets/48792/1 "2022-09-07T12:59:18Z")
Hello, I’m new to Glide. I created a Google Sheet in my Google Drive, then I created a new project linked to that Sheet. I see that Glide has created a Users table but I don’t see it in my Google Sheets. Is there a way to link it to my Google Sheets and have it show up as one of the Sheets over there? I could use that to mass add more users and edit the users more easily. Thank you. ---
**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:** [September 7, 2022, 2:57pm UTC](https://community.glideapps.com/t/show-users-in-google-sheets/48792/2 "2022-09-07T14:57:31Z")
Did Glide add it as a glide table (black icon) instead of a sheet table (green icon)? You can just add a new User table to your google sheet from within the google sheet (with the same column headings). Then change the user profile configuration in the app to use the new User table from the Google sheet instead of the User table from Glide. ---
**Author:** ![Innovations\_Imob](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/innovations_imob/32/47439_2.png) [@Innovations\_Imob](https://community.glideapps.com/u/Innovations_Imob)\ **Post date:** [September 7, 2022, 3:53pm UTC](https://community.glideapps.com/t/show-users-in-google-sheets/48792/3 "2022-09-07T15:53:33Z")
Yes, I have a glide table (black icon) named Users. If I understand you correctly I should: 1. Delete the Users table from the Data Editor 2. Go to Layout editor from the top 3. Go to User Profile tab on the left 4. Change Source sheet on the right to the one that I have in my Google Sheet 5. Make sure that Name/Email/Image/Role on the right correspond to the correct columns in my sheet And if all the above are correct, the app will now reference my own sheet for users. Right? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [September 7, 2022, 5:36pm UTC](https://community.glideapps.com/t/show-users-in-google-sheets/48792/4 "2022-09-07T17:36:12Z")
That sounds about right. Before deleting your old users table you may want to go through it and click ‘find all uses’ on each column. In case your app is using some columns from the glide table users sheet (i.e. set columns, relations, etc…) you could change those connections to the new users table before deleting the old. ---
**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:** [September 8, 2022, 5:08am UTC](https://community.glideapps.com/t/show-users-in-google-sheets/48792/5 "2022-09-08T05:08:05Z")
> [@Innovations\_Imob](#): > > Make sure that Name/Email/Image/Role on the right correspond to the correct columns in my sheet You should also check these columns in the Data Editor to make sure that Glide has automatically assigned the correct column types: - Name should be a Text column type - Email should be an Email column type - Image should be an Image column type - Role (if used) should be a Text column type