CreateSheet

Creates a new sheet in a specified Google Sheets spreadsheet.

Task version: 1.1.0

Required Frends version: 5.7+

Required .NET version: 8.0

Compatible Agents: Crossplatform

Source code: https://github.com/FrendsPlatform/Frends.GoogleSheets/tree/main/Frends.GoogleSheets.CreateSheet

Task Parameters

Input

Name	Description
SpreadsheetId : String	The ID of the spreadsheet. Default: - Example: abcdef12345...98765ABC
NewSheetName : String	The name of the new sheet to be created. Default: NewSheet Example: NewSheet
Hidden : Boolean	Whether the new sheet should be hidden. Default: False Example: false

Connection

Name	Description
🗝ServiceAccountJson : String	JSON string containing service account credentials. Default: - Example: { "type": "service_account", "project_id": ..., "private_key_id": ... }

Options

Name	Description
ThrowErrorOnFailure : Boolean	Whether to throw an error on failure. Default: True Example: false
ErrorMessageOnFailure : String	Overrides the error message on failure. Default: - Example: Custom error message

Task Result

Name	Description
Success : Boolean	Indicates if the task completed successfully. Example: true
NewSheetId : Int32	The ID of the newly created sheet. Example: 12345
ETag : String	ETag of the response. Example: W/"abc123"
Error : Error	Error that occurred during task execution. Example: object { string Message, Exception AdditionalInfo }

Task Changelog

Changelog for Task Frends.GoogleSheets.CreateSheet.

[1.1.0] - 2026-07-20

Changed

• Added missing documentation example for the ETag property in the task result.
• Updated copyright information to meet compliance requirements.

[1.0.0] - 2025-09-10

Changed

• Initial implementation