Append enables you to create an historical record of data that constantly changes from a source(s) into a destination. It does this by creating a new entry, below the previous entry, with the source data each time the connection is updated (see gif below). It's important that your origin sheet include a header.
- Click on create connection
- Select your data source
- Select your data destination
- On settings select the check box to enable append data
- Save your connection