Google Sheets is a free spreadsheet program offered by Google.

Design the Action steps for Google Sheets Node

In the Actions tab, you can define actions to be performed in Google Sheets Processing Node.

Click the Google Sheets node to open the attributes pane. In the Actions tab, select one of the following options from the first drop-down:

• G-Sheets Functions: To select the required Google Sheets Functions from the list in the second drop-down.
• Custom G-Sheets Function: The Custom Google Sheets functions are created for specific needs if not met by the Predefined Google Sheets functions. All the User Defined Functions created in the HyperApp with Type selected as Google Sheets gets listed in the drop-down.
• Call Function: To select other generic Functions from the list in the second drop-down.
  To know more about how to use Functions, click here.
• Set Variable: To set the value for a Variable as needed in further steps. The value set can either be a constant or another variable.

Variables

All Input/Local variables of the Google Sheets node are displayed under the Variables tab.

Table Definition

All Default/Custom DataTables in the task are displayed under the Table Definitions tab.

Properties of the Google Sheets Node

1. Navigate to the Properties tab and set the Name and Description properties for the node.
2. Enable Mark run Failure on Node Fail and Continue on Failure? options as required.
3. Select the Cluster to run on the task from the Clusters drop-down.

Result of Execution in Google Sheets Node

After executing the task, the Result of Execution window displays the following tabs:

• Input: The inputs mapped to the Google Sheets node are displayed.
• Output: The results of the actions performed are displayed in XML format.
• Run Info: The Run Details and Machine Details are displayed.
  • Run Details include Run ID, Sequence Number, and Total Node Execution Time (in seconds).
  • Machine Details include ID, Name, Host, Port, Iteration Start Time, Iteration End Time, Iteration Time (in seconds).
• Step Data: The details of the steps designed inside the node, the status of each step, and the values stored in the variables are displayed.
• Formatted Output:The table data of the output variable with Type selected as Table is displayed.

When the Create Sheet (Travel_Invoice, ABCD+/, example@gmail.com) function is executed, a Google Sheet with name Travel_Invoice is created.