Action to create a new Google spreadsheet. This action is based on Google Spreadsheets API v4. The action needs a JSON instance of a Spreadsheet object in order to create a new spreadsheet. All data structures and limitations are the same to Google API.
Properties - A group of fields used to describe a specific object. These fields are grouped together so that it is possible to map data into them while having an overview over the structure of the object.
Action to create a new Google spreadsheet row. This action based on Google Spreadsheets API v4. Adds an array of given values to a spreadsheet as a new row. Data would be inserted in the same order as provided in the input array. Data will be inserted into the last empty line, starting from the first table column. A datatype of inserted values will be the same as for JSON type (string, numeric or boolean). Use “” value to make cell empty.
values. Array mapped to
valuesis going to be inserted as first row.
Input Mode: “First Row As Headers”.
1. Requires first row to have at least one cell with value:
Please check there is at least one non-empty cell in first row.
2. Requires cells in first row to be not empty:
Please check there are no empty cells in between in first row:
3. Requires cells in first row to be unique:
Please check values in first row are distinct:
This action is
deprecated - please use Add Spreadsheet Row action.
Your integration flow can also write or add a row to the given Google Spreadsheet as an action. In this case, your spreadsheet will be the target spreadsheet.
To use add row action the Google Spreadsheet file which will be receiving
new data must already be mapped using the Data Mapper. This means the target
spreadsheet columns need to be assigned to the specific
values which are
expected from the components within the same integration flow that is sending the information.
Please note that the system will write a new record using only a