Get Sheet

The Get Sheet node allows you to retrieve data from Google Sheets documents.

Overview

This node enables you to:

  • Read entire sheets
  • Get specific ranges
  • Retrieve formatted or raw values
  • Access multiple ranges at once
  • Get sheet metadata

Configuration

ParameterTypeDescription
Spreadsheet IDStringThe ID of the Google Sheet
RangeStringRange to read (e.g., ‘Sheet1!A1:D10’)
Include HeadersBooleanWhether to include header row
Value Render OptionStringHow to render values (FORMATTED/UNFORMATTED)
Date Time OptionStringHow to render dates (SERIAL_NUMBER/FORMATTED_STRING)

Authentication

This node requires:

  • Google Cloud Project
  • Google Sheets API enabled
  • Service account or OAuth2 credentials
  • Read access to the spreadsheet

Output

The node returns:

  • Retrieved data as array
  • Range information
  • Sheet metadata
  • Error messages if operation fails

Example Usage

{
  "spreadsheet_id": "1234567890abcdef",
  "range": "Sheet1!A1:D10",
  "include_headers": true,
  "value_render_option": "FORMATTED_VALUE",
  "date_time_option": "FORMATTED_STRING"
}

Response Format

{
  "values": [
    ["Header1", "Header2", "Header3"],
    ["Value1", "Value2", "Value3"]
    // ... more rows
  ],
  "range": "Sheet1!A1:D10",
  "majorDimension": "ROWS"
}