WriteData

Writes data to a Google Sheets document. Can append or overwrite data in the specified range.

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.WriteData

Task Parameters

Input

Name	Description
SpreadsheetId : String	The spreadsheet ID of the Google Sheets document. Default: - Example: abcdef12345...98765ABC
StartingCell : String	The A1 notation of the starting cell where data will be written. Default: Sheet1!A1 Example: Sheet1!A1
Values : String	The values to write, formatted as a JSON string representing a 2D array. Each inner array represents a row of values. Default: - Example: [ ["Value1", "Value2"], ["Value3", "Value4"] ]

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
InsertDataMode : InsertDataModes	Mode for inserting data into the sheet. - InsertRows: Will append data after the last row with data, shifting existing rows down. - UpdateOverwrite: Will overwrite existing data. - AppendOverwrite: Will append data after the last row with data, overwriting any existing data in its way. Possible values: InsertRows: Mode for inserting data into the sheet. - InsertRows: Will append data after the last row with data, shifting existing rows down. - UpdateOverwrite: Will overwrite existing data. - AppendOverwrite: Will append data after the last row with data, overwriting any existing data in its way. AppendOverwrite: Mode for inserting data into the sheet. - InsertRows: Will append data after the last row with data, shifting existing rows down. - UpdateOverwrite: Will overwrite existing data. - AppendOverwrite: Will append data after the last row with data, overwriting any existing data in its way. UpdateOverwrite: Mode for inserting data into the sheet. - InsertRows: Will append data after the last row with data, shifting existing rows down. - UpdateOverwrite: Will overwrite existing data. - AppendOverwrite: Will append data after the last row with data, overwriting any existing data in its way. Default: 2 Example: InsertRows
ValueInputMode : ValueInputModes	Mode for how the input data should be interpreted. - UserEntered: The values the user has entered will be parsed as if the user typed them into the UI. - Raw: The values will not be parsed and will be stored as-is. Possible values: UserEntered: Mode for how the input data should be interpreted. - UserEntered: The values the user has entered will be parsed as if the user typed them into the UI. - Raw: The values will not be parsed and will be stored as-is. Raw: Mode for how the input data should be interpreted. - UserEntered: The values the user has entered will be parsed as if the user typed them into the UI. - Raw: The values will not be parsed and will be stored as-is. Default: 0 Example: UserEntered

Task Result

Name	Description
Success : Boolean	Indicates if the task completed successfully. Example: true
UpdatedRange : String	Updated range after write operation. Example: Sheet1!A1
UpdatedRows : Int32	Number of updated rows after write operation. Example: 5
UpdatedColumns : Int32	Number of updated columns after write operation. Example: 5
ETag : String	ETag of the response. Example: abc123etag
Error : Error	Error that occurred during task execution. Example: object { string Message, Exception AdditionalInfo }

Task Changelog

Changelog for Task Frends.GoogleSheets.WriteData.

[1.1.0] - 2026-07-18

Changed

• Updated package copyright metadata to comply with Frends platform standards.

[1.0.0] - 2025-09-10

Changed

• Initial implementation