Consolidate my sources into one sheet

Introduction

Use Consolidate to merge multiple sheet tabs into a single sheet. All source sheets need to use the same layout, i.e., the same column and header row structure.

Consolidate options

Consolidate in two different ways:

  1. Consolidate all sheets from a selected folder
  2. Alternatively, specify the sheets individually

Consolidate from the folder is faster and more efficient. Just add new spreadsheets to your folder to add them to your consolidate without having to edit your connection.

Consolidate from folder

 Steps

  1. Click on the green "Plus" icon named "New" in your Add-on or Web App
  2. Select Blank Workflow or an existing one (skip step 3)
  3. Name your Workflow, e.g., Inventory Management 
  4. Select "Create Connection"
  5. Select the "Data source" which is the Source Folder by clicking on "Select This Folder" from where you want to transfer data. Then select the sheet (tab) from the spreadsheets that you want to move.
  6. Select the "Data destination," which is the spreadsheet to which data from the data source will be transferred to. On add-on, by default, the data destination is the Google Sheet that you are currently using.
  7. In "Settings" select the checkbox to enable append data
  8. Click to "Save Connection"


Consolidate individually

Steps

  1. Click on the green "Plus" icon named "New" in your Add-on or Web App
  2. Select Blank Workflow or an existing one (skip step 3)
  3. Name your Workflow, e.g., Inventory Management 
  4. Select "Create Connection"
  5. Select the "Data source" which are the Sources Sheets by clicking in individually in each spreadsheet from where you want to transfer data. Then select the sheet (tab) from worksheets that you want to move.
  6. Select the "Data destination" which is the spreadsheet to which data from the data source will be transferred to. In the add-on, by default, the data destination is the Google Sheet that you are currently using.
  7. In "Settings" select the checkbox to enable append data
  8. Click to "Save Connection"



Tip: Identify source

With many sources, it can become difficult to trace back from which origin the data came. Enable Identify source to add a column to your destination that tells you the source of origin of your data.