google-apps-scriptweb-applicationsgoogle-sites

Can Google Apps Scripts be flexible enough to handle multiple sheets?


Is it possible with one Google Apps Script published as a Web Application to be flexible enough to connect to different spreadsheets depending on the person or webmaster using the Application?

I saw when working with one of my scripts there are ‘script properties’ and then ‘user properties’ tabs under ‘Project properties’.

I tried to add a property but couldn't get it to Stick

So then I found Google Apps Script ‘Class Properties’ area.

When I think of how these two properties might work, I think of Google Gadgets. A user can add a gadget to her Google Site but can then change or configure the Gadget in the properties area of that gadget

Is this type of functionality possible?


Solution

  • You can configure settings that will allow one script to access the files of the user of the Apps Script. The user needs to log in with their Google account. You can publish the Apps Script script to run as ANYONE, and Execute the app as: User Accessing the Web App. Which requires the user to log in with their Google Account, and will allow the script to access the users files.

    The Properties Service is for storage. It doesn't set or grant permissions. A break down comparison of the different types of Properties is shown at:

    Comparison of Property Stores