UpdateGoogleSheetData
Use this activity to update an area of the Google sheet with the data you provide in the input schema of this activity.
Configuration
The Configuration tab has the following fields that identify which Google Sheets connection to use.
| Field | Description |
|---|---|
| Connection | Google Sheets connection name. If you have created multiple Google Sheets connections, select the one you want to use in this flow. |
| Create Titles From Object | You can specify new data with which to update the Google Sheets. This data is entered in the Input Settings tab. Selecting True in this tab will ensure that both titles and their values for the new data will be entered in the Google Sheet when it is updated. If you select False, the Google sheet will be updated with only the data without the title. |
| Row or Column | Select whether you would like the output of this activity to be presented in Rows or Columns. |
| Include Values In Response | If you select True, this activity will display the updated values of the data in the Output tab. |
Input Settings
The Input Settings tab allows you to provide an optional series of labeled fields which will be applied to the input schema as named properties for each row. This allows you to map arbitrary fields from the output of previous activities to the named fields you have provided. If you do not provide named fields you can map arrays of fields or arrays of objects to the spreadsheet data. In such a case, the fields being mapped must be simple objects not complex objects.
Input
The Input tab displays the column names that you entered in the Input Settings tab. If no fields were defined, can map arrays of fields, or arrays of simple objects from any preceding activity using the Mapper or alternatively you can enter their values manually.
| Field | Description |
|---|---|
| spreadsheetId | This is a mandatory field. The ID that is a part of the URL for the spreadsheet. For example, if the URL for the spreadsheet is https://docs.google.com/spreadsheets/d/1fIJ7c57nPwpor9NDarbDdBiCCDQ6lxP_jVG2u79lCKns/edit#gid=0, the spreadsheetID is 1fIJ7c57nPwpor9NDarbDdBiCCDQ6lxP_jVG2u79lCKns |
| sheetId | This is a mandatory field. The name of the tab which appears at the bottom of the sheet. |
| startCell | The coordinates of the beginning cell from where to start writing the data on the destination sheet. |
| overWrite | When set to False, it appends the data to the sheet. If set to True, it overwrites any existing data. |