Forum Discussion
PhilMayor
3 years agoSuper Hero
To do it this way the Google sheet has to be open to the public, there are examples on here that do this.
The main issue I would see is that storing emails on an open sheet would break GDPR rules, may not be an issue for you but if it is the fine is huge.
I would find it much easier to spin up a Wordpress site with a paywall and allow access that way via a sign in.