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 through Bot Runner or Studio Pro.
Bot Runner:
Right click on the 'ElectroNeek Bot Runner' in the bottom right tray → "Settings" → "Services".
Studio Pro:
Navigate to "Settings" → "Services Connection".
Parameters
-
Set a value: enables you to directly write the id.
-
Save the previous step result: chooses the previous activity result as the id.
-
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.
-
Save the previous step result: chooses the previous activity result as the data.
-
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"]].
-
Set a value: allows you to explicitly specify the name of the sheet to which you want to append values.
-
Save the previous step result: takes the result of the activity from the previous step of the algorithm as the name of the sheet.
-
Calculate a value: allows you to use a special formula or a special method to specify the name of the sheet.
Contains an annotation to the activity. The input text will be displayed above the activity name.
Usage Examples
This activity 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.