cloudHQ Export Emails to Sheets will create a separate spreadsheet for each of the jobs.

But sometimes it is useful to have data from multiple Google spreadsheets inside one spreadsheet

You can do this easily using the IMPORTRANGE function in Google Sheets.

The formula for IMPORTRANGE is as follows:

=IMPORTRANGE("spreadsheet_url", "range_string")
  1. The first parameter – spreadsheet_url – is found in the search bar of your browser.
  2. The second parameter – range_string – is the data you want to bring in from another spreadsheet.

Simply copy the url, and paste it into the IMPORTRANGE function:

The Google Sheets help page for the formula is here.