Who can execute GPT functions in a shared Google spreadsheet?
After the Creator of a Google spreadsheet enables GPT functions by going to Extensions > GPT for Sheets and Docs > Enable 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 use GPT for Sheets sidebar | Whose balance is 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 have a positive balance in GPT for Sheets. If the Owner sets API keys in GPT for Sheets, they are also 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.