Sign up for free
Functions

IMPORT_GOOGLE_SHEETS

Get cell values from spreadsheets from Google Sheets.

icon of Google SheetsGoogle Sheets
Not a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.

Parameter List

Syntax
IMPORT_GOOGLE_SHEETS(url, range, 
[header_type]
)
url

The spreadsheet URL from Google Sheets. For example: https://docs.google.com/spreadsheets/d/{spreadsheetId}/edit#gid=0.

range

Google Sheets range where to get the cell values from. For example: "A1:B10" or "Sheet1!A1:B2". Note that you should not use the sheet name in the range when the url is from a specific sheet.

[optional] header_type

The header type that should be created.

  • 0 to get generic table headers. For example: value_0 and value_1.
  • 1 (default) to create headers from the first row of the range.
Selected options:
Use first row
No headers

Examples

IMPORT_GOOGLE_SHEETS("https://docs.google.com/spreadsheets/d/1KZt15SSOMt9OUJI-64ZT55FCNDmXvgViIFQjKElA/edit#gid=0", "sheet2!A1:C4", 0) returns the range of data in "sheet2!A1:C4" from the given spreadsheet url