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 |
|Current Owner**||Current Owner**||Current Owner**|
* 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.