Update Rows
Use this action to update the specified rows of a spreadsheet.
Using the Update 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 Update 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 Update 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 a Google Sheets authorization, select an authorization from the list.
4. In the Spreadsheet ID field, select or specify the ID of the spreadsheet to update the rows.
5. In the Sheet Name field, select or specify the name of the sheet to update the rows.
6. In the From Row field, enter the row number to start update operation in the sheet.
7. In the Select Entry Type field, select an entry type to update rows from the list that follows:
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.
8. Click Done.