How do I merge two worksheets into one?

For example, we have two jobs exporting email messages from particular labels into two different Google Sheets, as shown in the cloudHQ dashboard
The cloudHQ jobs create two existing spreadsheets for exporting emails:

  • label Name
  • label Test

Firstly, we need to create a destination Google Sheet named “SpreadsheetMerge” manually:

Secondly, we use the IMPORTRANGE function to import a range of cells from a specified spreadsheet in cell A1:

Thirdly, this formula needs to be refreshed in Google Sheets:

  • Click the File option
  • In the drop-down list, click on ‘Spreadsheet settings’
  • Click on the ‘Calculation’ tab in settings for this spreadsheet
  • Click on the Recalculation drop-down
  • Click on change

Tagged: