sheet/get FormID SH07

When to Use

• Finance — budget vs. actuals pull: A month-end reporting workflow reads the "Budget 2026" tab to retrieve all rows where Department equals "Engineering", then joins those figures with actuals from the ERP system to compute variance and route to a Slack notification node.
• HR — employee roster lookup: An onboarding trigger workflow reads the "Employees" sheet filtered by Status = "Active" and StartDate >= today to generate welcome emails and provision system accounts for all employees starting this week.
• Operations — inventory audit: A nightly reconciliation workflow reads the "Inventory" tab filtered by StockQty < ReorderLevel to identify items below threshold and create purchase orders automatically.
• Marketing — campaign tracking: A weekly analytics workflow reads the "Campaigns" tab filtered by Status = "Live" to pull active campaign IDs and then calls the ad platform API for each, appending performance metrics back to the sheet via sheet/appendOrUpdate.
• Reporting — single record lookup: A workflow triggered by a form submission reads the "Products" sheet with ReturnFirstMatch: true and a SKU filter to retrieve product details before generating a quote PDF. This avoids fetching all rows when only one record is needed.

Configuration

Validation Errors

Output Fields

Sample Configuration

{
  "resource": "sheet",
  "operation": "get",
  "CredentialId": 12,
  "SpreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
  "SheetName": "Employees",
  "Filters": [
    { "Column": "Department", "Operator": "Equals",        "Value": "Engineering" },
    { "Column": "Status",     "Operator": "Equals",        "Value": "Active" },
    { "Column": "Salary",     "Operator": "GreaterOrEqual","Value": "60000" }
  ],
  "CombineFilters": "And",
  "HeaderRow": 1,
  "FirstDataRow": 2,
  "ValueRender": "UNFORMATTED_VALUE",
  "DateTimeRender": "FORMATTED_STRING",
  "ReturnFirstMatch": false
}

Sample Output

{
  "rows": [
    {
      "EmployeeId": "E-1042",
      "FirstName": "Sarah",
      "LastName": "Mitchell",
      "Department": "Engineering",
      "Title": "Senior Software Engineer",
      "Salary": 95000,
      "Status": "Active",
      "StartDate": "2023-03-14",
      "ManagerEmail": "james.carter@acme.com"
    },
    {
      "EmployeeId": "E-1087",
      "FirstName": "David",
      "LastName": "Okonkwo",
      "Department": "Engineering",
      "Title": "DevOps Engineer",
      "Salary": 88000,
      "Status": "Active",
      "StartDate": "2024-07-01",
      "ManagerEmail": "james.carter@acme.com"
    },
    {
      "EmployeeId": "E-1103",
      "FirstName": "Priya",
      "LastName": "Sharma",
      "Department": "Engineering",
      "Title": "Staff Engineer",
      "Salary": 120000,
      "Status": "Active",
      "StartDate": "2021-11-08",
      "ManagerEmail": "james.carter@acme.com"
    }
  ],
  "rowCount": 3,
  "spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
  "sheetName": "Employees",
  "status": "success",
  "resource": "sheet",
  "operation": "get"
}

Expression Reference

Assuming this node is named getEmployees in the workflow:

Node Policies & GuardRails

• Credential storage: The OAuth token or service account key is resolved from the Credentials Manager at runtime via CredentialId. Tokens are never exposed in workflow logs or output ports.
• Quota awareness: The Sheets API allows 300 read requests per minute per project. If a loop node calls sheet/get in rapid succession, insert a Delay node (600 ms minimum) to avoid 429 errors.
• Large datasets: Sheets with more than 1,000 rows should use narrow filter conditions to reduce result size. For full exports of very large sheets, prefer the Google Drive CSV export endpoint via an HttpRequest node.
• Sheet name case sensitivity: SheetName is matched exactly as typed. A sheet named "Employee Data" will not be found if you specify "employee data".
• ValueRender selection: Use UNFORMATTED_VALUE when downstream nodes perform numeric comparisons or arithmetic. Use FORMATTED_VALUE when the visual display string is the required output (e.g. currency formatted as "$1,200.00").
• Empty result handling: When no rows match the filters, rows is an empty array [] and rowCount is 0. The node routes to the success port — it does not route to error. Add an IF node downstream to branch on rowCount == 0 if your workflow requires different handling for empty results.
• ReturnFirstMatch performance: When looking up a single record by a unique key (e.g. EmployeeId), always set ReturnFirstMatch: true. This stops row scanning at the first match and avoids reading the rest of the sheet.

Workflow Examples

Example 1 — Weekly Payroll Summary Email

Trigger: Scheduled (every Friday 9 AM). Read all active employees from the Payroll sheet, compute total payroll cost, and send a summary email to Finance.

// Node 1 — sheet/get (getActiveEmployees)
{
  "resource": "sheet", "operation": "get",
  "CredentialId": 12,
  "SpreadsheetId": "{{ $env.PAYROLL_SHEET_ID }}",
  "SheetName": "Employees",
  "Filters": [{ "Column": "Status", "Operator": "Equals", "Value": "Active" }],
  "ValueRender": "UNFORMATTED_VALUE"
}

// Node 2 — Code node (computeTotals)
// $output.getActiveEmployees.rows  →  sum Salary field
// Outputs: totalPayroll, headcount

// Node 3 — Email node
{
  "To": "finance@acme.com",
  "Subject": "Weekly Payroll Summary — {{ $now | date('YYYY-MM-DD') }}",
  "Body": "Headcount: {{ $output.computeTotals.headcount }}\nTotal Payroll: ${{ $output.computeTotals.totalPayroll }}"
}

Example 2 — Inventory Reorder Alert

Trigger: Nightly at 2 AM. Read all inventory rows where stock is below the reorder threshold, then create purchase orders via the ERP HTTP API for each item.

// Node 1 — sheet/get (getLowStock)
{
  "resource": "sheet", "operation": "get",
  "CredentialId": 15,
  "SpreadsheetId": "{{ $env.INVENTORY_SHEET_ID }}",
  "SheetName": "Stock",
  "Filters": [
    { "Column": "CurrentQty", "Operator": "LessThan", "Value": "{{ $json.ReorderLevel }}" }
  ],
  "ValueRender": "UNFORMATTED_VALUE"
}

// Node 2 — Loop node over $output.getLowStock.rows
// Node 3 — HttpRequest: POST /erp/purchase-orders for each item

Example 3 — Single Product Lookup Before Quote

Trigger: Form submission with a SKU. Retrieve the product details and use them to populate a quote PDF template.

// Node 1 — sheet/get (getProduct)
{
  "resource": "sheet", "operation": "get",
  "CredentialId": 12,
  "SpreadsheetId": "{{ $env.CATALOG_SHEET_ID }}",
  "SheetName": "Products",
  "Filters": [{ "Column": "SKU", "Operator": "Equals", "Value": "{{ $json.sku }}" }],
  "ReturnFirstMatch": true
}

// Node 2 — PDF generation node
{
  "Template": "quote-template",
  "ProductName": "{{ $output.getProduct.rows[0].ProductName }}",
  "UnitPrice": "{{ $output.getProduct.rows[0].UnitPrice }}",
  "Description": "{{ $output.getProduct.rows[0].Description }}"
}