# How to provide users with live access to form submissions in Google sheet?
**URL:** https://community.glideapps.com/t/how-to-provide-users-with-live-access-to-form-submissions-in-google-sheet/4565
**Category:** Ask for Help
**Created:** [February 13, 2020, 2:35pm UTC](https://community.glideapps.com/t/how-to-provide-users-with-live-access-to-form-submissions-in-google-sheet/4565 "2020-02-13T14:35:34Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Nick\_Regan1](https://community.glideapps.com/u/Nick_Regan1)
#### Post date: [February 13, 2020, 2:35pm UTC](https://community.glideapps.com/t/how-to-provide-users-with-live-access-to-form-submissions-in-google-sheet/4565/1 "2020-02-13T14:35:34Z")
Hi all -
I need to be able to provide my users with access to their data. Right now, users submit a form on my app and those form submissions go in to my app’s google sheet.
I can’t give individual users access to that google sheet as it will show them the form submissions of all other users. I know how to filter this WITHIN glide. But I need a way to for a user to also see this in a google sheet.
Any suggestions?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 14, 2020, 5:34am UTC](https://community.glideapps.com/t/how-to-provide-users-with-live-access-to-form-submissions-in-google-sheet/4565/2 "2020-02-14T05:34:09Z")
A few ideas:
- Set up some scripting to split the data into separate spreadsheets.
- Set up multiple sheets with ImportRange to pull in data from the main sheet.
- Set up something with Zapier to update and populate multiple sheets.
Grant access to each user’s own spreadsheet.
---
### Author:  [@RedHeadKev](https://community.glideapps.com/u/RedHeadKev)
#### Post date: [February 16, 2020, 1:32am UTC](https://community.glideapps.com/t/how-to-provide-users-with-live-access-to-form-submissions-in-google-sheet/4565/3 "2020-02-16T01:32:50Z")
Could the filter view per signed in user work here?
I am not sure of your privacy settings but something similar to Glides “[user profile](https://youtu.be/LFBkC9_yASM)” video seems like it could work. Maybe setting up a relation / inline list of users email address to the form response sheet and “special value” grab their email address.
In my understanding this would pull just their responses but I am not 100% sure.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 16, 2020, 1:51am UTC](https://community.glideapps.com/t/how-to-provide-users-with-live-access-to-form-submissions-in-google-sheet/4565/4 "2020-02-16T01:51:20Z")
He wants users to see their results in an actual spreadsheet instead of the app. Otherwise you are correct regarding per user data and filtering.
---
### Author:  [@MI\_I](https://community.glideapps.com/u/MI_I)
#### Post date: [March 13, 2020, 3:08am UTC](https://community.glideapps.com/t/how-to-provide-users-with-live-access-to-form-submissions-in-google-sheet/4565/5 "2020-03-13T03:08:51Z")
i have often failured Glide access to my picture address in Google sheet…
---
### Author:  [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)
#### Post date: [March 13, 2020, 10:57am UTC](https://community.glideapps.com/t/how-to-provide-users-with-live-access-to-form-submissions-in-google-sheet/4565/6 "2020-03-13T10:57:37Z")
If all they need is view rights, once he figures out how he will format individual reports for users, he could publish the report tab as html and host it in an iframe on google sites. The would keep people out of the spreadsheet.