Jo guys, I have a question regarding the google scripts. Unfortunately I have no idea how to work with them, but I have to finish a program for my supervisor until Sunday. Could one help me with this? I would be infinitely grateful to you guys. I have already searched the internet.

Here is what I need: A script that pulls out and enters an email address from Google spreadsheets automatically (say every 5 minutes) and then gives that email address access rights to the sheet. As soon as the email address is removed, the permission should also be removed again. The script should run automatically every 5 minutes.

Thank you all from the bottom of my heart!