Appending or Editing Data in the Existing Worksheet

This example Pipeline demonstrates how to append data in an existing worksheet without specifying a cell reference and by specifying a cell reference.

Download this Pipeline
  1. Configure the JSON Generator Snap to pass sample data as follows:




  2. Configure the Mapper Snap to combine the message and number fields as shown below.


  3. Configure the Worksheet Writer Snap as shown below:


  4. After validating the Pipeline, the Snap writes the data after the last row following the existing content in the worksheet.
To successfully reuse pipelines:
  1. Download and import the pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.