Update values

Description

Changes a content of cells within the specified range. To make the function work, you need to provide the platform access to the Google services (right click on the 'electroNeek Agent' in the bottom right tray - ''Show summary' - 'Google' - Authenticate Google services').

Parameters

Spreadsheet Id

  1. Set a value: enables you to directly write the id.

  2. Save the previous step result: chooses the previous function result as the id.

  3. Calculate a value: enables you to use available properties and methods to form the id.

To get the spreadsheet id open manually the document. The text between '/d/' and '/edit' is the spreadsheet id.

Range

  1. Set a value: enables you to directly set the desired range, for example, A1:B3.

  2. Save the previous step result: chooses the previous function result as the range.

  3. Calculate a value: enables you to use available properties and methods to form the range.

Data

  1. Save the previous step result: chooses the previous function result as the data.

  2. Calculate a value: enables you to use available properties and methods to form the data to be written, for example, [["New Value 1", "New Value 2", "New Value 3"]].

Comment

Contains an annotation to the block. The input text will be displayed inside the block above the function name.

Usage Examples

This function will be useful when you need to change some specific cells values without modifying the whole data array.