Append values

Description

Adds values to the first completely empty line in a table. 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.

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 comfortable to use when a table doesn't contain completely empty lines. In this case using the function will add a new line to the end of the table.