I'm looking for a way to achieve the following:
Every time a user enters their email address in a Google Form, it is recorded in a Google Sheet.
I need that email address to automatically be given permission to view a folder on my Google Drive. I don't want the folder to be public.
How can I do that?