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
=GOOGLE.SHEETS.SPREADSHEET.SHARE(B2, "user@google.com")	TRUE	Shares spreadsheet with ID given in B2.