Different users

Hi. Hope all community members are fine. If anyone could help, it would be great.

I have a google sheet with 20 sheets. I have created an app with a password which reads 3 of the sheets for a particular customer and in order to brand it, I paid the pro version.

Now I have other customers whom I would like them to use the app with the pro version however I need to upload their information from different sheets from the main google sheet without having to duplicate the app for them and buy the pro version.

Is that possible or is there any other way of doing that?

Thanks

Hi Gemini and welcome to the community!

Have you tried using the IMPORTRANGE function? It allows you to import information from other spreadsheets. That way you can use the same spreadsheet for different customers.

1 Like