Add Rows
Use this action to add rows to the specified spreadsheet.
Using the Add Rows Action
To use this action in your workflow, connect it to ThingWorx Flow. To connect to the flow, do the following:
1. Drag the Add Rows action under the Google Sheets connector to the canvas, place the pointer on the action, and then click or double-click the action. The Add Rows action window opens.
2. Edit the label name, if needed. By default, the label name is same as the action name.
3. To add a new authorization, refer to the section Authorize Google Sheets in the Google Sheets connector topic.
If you previously added an authorization for Google Sheets, select an authorization from the list.
4. In the Spreadsheet ID field, select or specify the ID of the spreadsheet to add rows.
5. In the Sheet ID field, select or specify the ID of the sheet to add rows.
6. In the Select Entry Type field, select an entry type to add rows from the following list:
Single Row Entry—Enter the value for a specified Column. To add multiple column values click Add.
Multiple Row Entries—In the Row Data section, enter the information that follows:
Input Data Type—Select the data type as per your input.
Row Data—Enter the row data. If you selected Comma Separated Values as an input data type, provide data in Abc,123 format. If you selected JSON Array as an input data type, provide data in [\"Abc\",\"123\"] format. Multiple rows can be added by entering multiple CSV lines or by entering an array of JSON array.
7. Click Done.