# WriteData Required Frends version: 5.7+ Required .NET version: 8.0 Compatible Agents: Unknown Source code: {% tabs %} {% tab title="Parameter: 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"] ]

| | {% endtab %} | | {% tab title="Parameter: Connection" %} | Name | Description | | ------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 🗝ServiceAccountJson : `String` |

JSON string containing service account credentials.


Default: -
Example: { "type": "service\_account", "project\_id": ..., "private\_key\_id": ... }

| | {% endtab %} | | {% tab title="Parameter: 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:

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.

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.

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:

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.

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

| | {% endtab %} | | {% tab title="Result: 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 }

| | {% endtab %} | | {% tab title="Changelog" %} ## Changelog ### \[1.0.0] - 2025-09-10 #### Changed * Initial implementation {% endtab %} {% endtabs %}