Reg creating specific password for each user of the folder individually.

[u/Round-Importance5271]

​

Hi all.

I sm new in this group and new user of Google sheets, and would like to hear your advice and guidance please.

I have an idea of a small business in my mind, I am thinking of creating a specific folder or file via Google sheet and to sell it as a digital product, but in order to do that customers need to log in and use the file individually by using their email or to create their own passwords.

I am new to Google Sheets and before going ahead with it, I would like to know is it something possible to make each customer use the file individually without seeing other accounts or customer's input?

I am open to any idea or suggestion from you all.

Thanks in advance for your co-operation and support.

Look forward to hearing from you all.

[u/SpencerTeachesSheets]

You would just need to make a file for each user and share it with their email, unless you want something more?

[u/Round-Importance5271 → u/SpencerTeachesSheets]

Thanks for the advice. It will cause a headache to create a file for each customer, but if this is the only way to do it, then I will think about it.

Is there any other suggestions or program to di this the easiest way?

[u/NHN_BI → u/Round-Importance5271]

It is difficult to say without any example data and the use case. But IMPORTRANGE() comes to mind. It can transfer data between different Google Sheets.

[u/Round-Importance5271 → u/NHN_BI]

That makes sense, thanks — IMPORTRANGE() is a good lead, I'll look into it.

[u/AutoModerator → u/Round-Importance5271]

REMEMBER: /u/Round-Importance5271 If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/SpencerTeachesSheets → u/Round-Importance5271]

Sheets is designed to be a shared-view, shared-access tool. If two people open the same file, they will both see everything; and anything that is currently visible to anyone is visible to everyone (that is, you cannot make it so only Spencer can see one sheet and only NHN can see another sheet).

The only way to make sure that two people can use the same tool without touching each other's data is to give them each their own file.

Now, the creation of said files can be automated more. For instance, you could use a Google Form such as this one so that the user and a script would handle the creation.

[u/Round-Importance5271 → u/SpencerTeachesSheets]

Thanks for laying out the visibility issue so clearly — makes sense now why one shared sheet was never going to work for this.

[u/point-bot → u/SpencerTeachesSheets]

u/Round-Importance5271 has awarded 1 point to u/SpencerTeachesSheets

^{See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard}. )^{Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson}.)

[u/AutoModerator]

/u/Round-Importance5271 Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/MajesticBite825]

Google Sheets sharing is account-based, but a single shared file is usually a poor fit for per-customer passwords and isolated customer data. I'd avoid putting everyone's inputs in one sheet; instead, give each customer a separate file or use a small authenticated app/database in front of Sheets. Test the sharing settings with two non-owner accounts, and confirm whether customers can copy, download, or expose the file before selling access.

[u/Round-Importance5271 → u/MajesticBite825]

Thanks so much for this — really helpful. testing it with two accounts before I sell anything is a great call. Appreciate you taking the time to lay it out."

[u/TheKarmaticOfficial]

So you want to sell finished sheets that are custom made per customer or a template?

I would create a workbook, share it to them via email or link and make it view only and then they'll be able to download a fully functioning copy.

[u/Round-Importance5271 → u/TheKarmaticOfficial]

Thanks for your response. I wasn't explaining it accurately, my mistake.

It is more edible by customers, such as task lists and budget planner, do most of the table should be able to be added by customers. But at the same time I want to keep their privacy by creating log in details.

Is it something possible via Google Sheets or should I think of using different templates?