sheet/append FormID SH01

When to Use

• Finance — expense report logging: Each time an employee submits an expense claim via a web form, the claim details (amount, category, vendor, date, submitter) are appended to the "Expense Log" sheet. Finance teams review and approve directly in Sheets without needing system access.
• HR — new hire onboarding log: When a new hire record is created in the HRIS, a workflow appends a row to the "Onboarding Tracker" sheet with name, start date, department, assigned buddy, and checklist status — giving HR visibility into all in-progress onboarding cases.
• Operations — shipment tracking: A webhook from the shipping platform triggers a row append to the "Shipment Log" sheet for every dispatch event, recording tracking number, destination, carrier, weight, and estimated delivery. Operations managers see a live rolling log.
• Marketing — lead capture: Web form submissions are appended to the "Leads" sheet in real time, enabling the sales team to work from a live pipeline without waiting for CRM sync cycles.
• Reporting — daily KPI batch: A nightly scheduled workflow computes daily KPIs (revenue, orders, active users) and appends a single summary row to the "KPI History" sheet, building a historical time series for trend analysis in connected charts.

Configuration

Validation Errors

Output Fields

Sample Configuration

{
  "resource": "sheet",
  "operation": "append",
  "CredentialId": 12,
  "SpreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
  "SheetName": "Expense Log",
  "DataMode": "DefineBelow",
  "ColumnMappings": [
    { "Column": "SubmittedAt",  "Value": "{{ $now | date('YYYY-MM-DD HH:mm:ss') }}" },
    { "Column": "EmployeeId",   "Value": "{{ $json.employeeId }}" },
    { "Column": "EmployeeName", "Value": "{{ $json.fullName }}" },
    { "Column": "Amount",       "Value": "{{ $json.amount }}" },
    { "Column": "Currency",     "Value": "{{ $json.currency }}" },
    { "Column": "Category",     "Value": "{{ $json.category }}" },
    { "Column": "Vendor",       "Value": "{{ $json.vendor }}" },
    { "Column": "Description",  "Value": "{{ $json.description }}" },
    { "Column": "Status",       "Value": "Pending" }
  ],
  "CellFormat": "UserEntered",
  "HeaderRow": 1,
  "FirstDataRow": 2,
  "HandlingExtraData": "IgnoreIt",
  "UseAppend": true
}

Sample Output

{
  "updatedRange": "Expense Log!A47:I47",
  "updatedRows": 1,
  "updatedColumns": 9,
  "updatedCells": 9,
  "spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
  "sheetName": "Expense Log",
  "status": "success",
  "resource": "sheet",
  "operation": "append"
}

Expression Reference

Assuming this node is named logExpense in the workflow:

Node Policies & GuardRails

• Formula injection prevention: User-supplied text that begins with =, +, -, or @ is interpreted as a formula by Google Sheets when CellFormat = UserEntered. Always sanitize free-text input from external sources before writing. Prepend a single quote ' to force text treatment, or set CellFormat = Raw for untrusted input.
• Idempotency caution: sheet/append always adds new rows — it never checks for duplicates. For idempotent writes (where re-running the workflow should not create duplicate rows), use sheet/appendOrUpdate with a unique key lookup filter instead.
• Concurrent writes: Avoid two parallel workflow branches writing to the same sheet simultaneously. Google Sheets does not support row-level locking — concurrent appends can collide and one write may overwrite the other. Serialize writes using a sequential node chain.
• Quota: Each append is one write request. With 100 writes/min quota, avoid firing this node more than 100 times per minute across all concurrent workflow executions.
• Sheet name case sensitivity: "expense log" will fail if the tab is named "Expense Log".
• Bulk appends: If upstream data is an array (e.g. 50 lead records from a batch webhook), pass the entire array to a single sheet/append call rather than looping. One API call for 50 rows is far more efficient than 50 individual calls.

Workflow Examples

Example 1 — Real-Time Lead Capture from Web Form

// Trigger: Webhook (form submission)
// Node 1 — sheet/append (logLead)
{
  "resource": "sheet", "operation": "append",
  "CredentialId": 12,
  "SpreadsheetId": "{{ $env.LEADS_SHEET_ID }}",
  "SheetName": "Leads",
  "DataMode": "DefineBelow",
  "ColumnMappings": [
    { "Column": "Timestamp",   "Value": "{{ $now | date('YYYY-MM-DD HH:mm') }}" },
    { "Column": "FirstName",   "Value": "{{ $json.firstName }}" },
    { "Column": "LastName",    "Value": "{{ $json.lastName }}" },
    { "Column": "Email",       "Value": "{{ $json.email }}" },
    { "Column": "Company",     "Value": "{{ $json.company }}" },
    { "Column": "Source",      "Value": "{{ $json.utmSource }}" },
    { "Column": "Status",      "Value": "New" }
  ],
  "CellFormat": "Raw"
}

// Node 2 — Slack notification to #sales-leads channel

Example 2 — Daily KPI Summary Append

// Trigger: Scheduled — daily at 11:55 PM
// Node 1 — HttpRequest: GET /api/metrics/daily for today's KPIs
// Node 2 — sheet/append (appendKPI)
{
  "resource": "sheet", "operation": "append",
  "CredentialId": 14,
  "SpreadsheetId": "{{ $env.KPI_SHEET_ID }}",
  "SheetName": "KPI History",
  "DataMode": "DefineBelow",
  "ColumnMappings": [
    { "Column": "Date",          "Value": "{{ $now | date('YYYY-MM-DD') }}" },
    { "Column": "Revenue",       "Value": "{{ $output.getMetrics.revenue }}" },
    { "Column": "Orders",        "Value": "{{ $output.getMetrics.orderCount }}" },
    { "Column": "ActiveUsers",   "Value": "{{ $output.getMetrics.activeUsers }}" },
    { "Column": "ConversionPct", "Value": "{{ $output.getMetrics.conversionRate }}" }
  ]
}