Google Sheets tutorial: Import the data from multiple Google Spreadsheets into the one

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.