GSheets Operator > Google Sheets Operator > Write Single Value to Cell

Write Single Value to Cell

Used to write a single value to any given cell, expressed in A1 Notation. If a value exists in this cell, it will be overwritten.

Inputs

In
Exec

In Token
Google Sheets Web Token Object Reference

A validated UGoogleSheetsWebToken object. Used to authenticate the Sheets operation.

Operation Params
Google Sheets Operation Params Structure

Generic request operation parameters

Call on Complete
Delegate (by ref)

This delegate will be called when the operation completes and tell you whether or not it was successful and return the response as a string.

In Value
String

The value you wish to write to the single cell.

In Spreadsheet Id
String

This is the spreadsheet ID number or key. Get it from your spreadsheet URL by calling GetSpreadsheetIdFromUrl.

In Sheet Id
Integer

This is the sheet ID number or GID. Get it from your sheet URL by calling GetSheetIdFromUrl or from a UGoogleSheetsObjectSpreadsheet calling GetSheetIdFromSheetIndex().

In Cell
String

The single cell you wish to write InValue to, expressed in A1 notation. Please ensure this cell exists before writing. Please do not put a range into InCell or an array of values into InValue. Use WriteValuesToSheet for that.

Outputs

Out
Exec