Who can execute GPT functions in a shared Google spreadsheet?
After the Creator of a Google spreadsheet enables GPT functions, any user with Editor's access to the spreadsheet can execute them. The actions needed to set up a Google spreadsheet with GPT functions as well as how those functions behave depend on where your spreadsheet is located. They are described in the table below.
Where is the spreadsheet? | Who must enable GPT functions | Who can execute GPT functions | Who can display GPT for Sheets sidebar | Whose credits are used | Whose API keys are used (if any) |
---|---|---|---|---|---|
My Drive | Creator* | Creator* Current Owner** Editors*** | Current Owner** | Current Owner** | Current Owner** |
Shared Drive | Creator* | Creator* Editors*** | Creator* Editors*** | Creator* | Creator* |
* Creator: User who created the Google spreadsheet. You can find out who the Creator of a file is by checking the file Activity.
** Owner: By default the Owner of the spreadsheet is its Creator. If the ownership of the file is transferred, the new Owner must buy a credit pack and set their own API keys. The new Owner's credit pack and API keys are then used for all executions. You can find out who the Owner of a file is by checking the file Details.
*** Editor: User who has been granted access to edit a spreadsheet. In a Shared Drive, Editors are members with a Contributor access or higher permissions.