GOOGLE.SHEETS.SPREADSHEET.SHARE
Premium
Experimental
Shares a spreadsheet.
Syntax
=GOOGLE.SHEETS.SPREADSHEET.SHARE(Spreadsheet-Id, Account eMail, [Role])
Arguments
| Name | Type | Description |
|---|---|---|
| Spreadsheet-Id | Text | The id of the spreadsheet to share. |
| Account eMail | Text | An eMail address the user to share the spreadsheet with. |
| Role (optional) | Role | Optional permission role. Defaults to "writer". Options: "reader": Ready only permission. "writer": Read and write permission. |
Return
| Type | Description |
|---|---|
| Boolean | TRUE if share was successful. |
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | Shares spreadsheet with ID given in B2. |