I have a clickfunnels website that requires users to sign up with their email address and password to get access to a members area. Within the members area they can currently download a set of google sheet tools to use within their own google drive accounts. They are currently able to make multiple copies of each sheet and use them in whichever google drive accounts they wish.
I am trying to figure out a simple way to force each user to have to signup for additional accounts on my website if they wish to create copies and use the sheets in multiple google drive accounts.
I was hoping to handle some of this on my clickfunnels website side with a custom form of some sort but I am only able to gather my customer list (emails) and not add additional fields to the data base. I can auto export my users emails to a google sheet via zapier but these email address wont necessarily be the same emails they want to use for the drive folder they save their sheets to so im not sure this is even useful for what I need.
I currently have an authorization script built in google apps script that requires each user to input their user email and password for my website within each tool and then logs in from the users computer to verify they still have an active account. I also am able to log each google sheet id and save those within a separate sheet saved to the users google drive that also can include their email registered with my clickfunnels website. Again... not sure if this could be useful yet or not either.
I've been thinking about different options such as a completely separate mysql database or possibly some way to handle this task soley within google apps script, but I have been struggling to come up with anything feasible. I have also considered implementing some sort of authorization token that might somehow be used which could be emailed to each user after signup automatically. I already have a google google apps script developer that can implement pretty much anything but I'm looking for someone that might have a creative solution to help assist in completing the tasks from a consulting perspective.
If you have any thoughts, suggestions, or questions please reach out.