WCA-004 · n8n

Orders to Google Sheets

Name: Orders to Google Sheets
SKU: WCA-004

Refresh selected order fields while keeping staff notes and follow-up columns intact.

Setup begins with a compatibility check. Scope and pricing are agreed before work starts.

Workflow built. Google account integration remains unverified; purchases are not enabled.

Read requirements Request setup help

Sample output

See the result using sample data.

Example output using sample data

Orders to Google SheetsManaged + manual

Order	Status	Currency	Staff note
1042	Pending	USD	Review tomorrow
1034	Processing	USD	Check packing

Illustrative rows · staff notes are human-owned

Data and rules

How this scenario is designed to work.

Hourly schedule → initial window / modified overlap → existing row map → managed-column upsert → checkpoint

One row is keyed by store_key and order_id. Managed columns cover ID, dates, status, currency, order total, units, safe item summary, admin URL and sync time. Human columns staff_note, owner and follow_up are preserved. Customer PII is excluded by default.

Requirements and configuration.

Your own compatible n8n runtime, one standard WooCommerce store and read-only REST credentials. Email scenarios require an owner email transport; Sheets requires Google access and an agreed sheet.

Selected sheet, exact header schema, initial-import period, overlap, timezone and a single serialized runner.

Included in the review package: workflow, sample fixtures/output, setup and configuration docs, acceptance checks, safe-disable and recovery guidance. See the local tested profile below; production/customer accounts remain unverified.

Operational limits

Repeats, errors and safe recovery.

Partial writes or timeouts must not advance the overall watermark. A repeated overlap reconciles managed fields. Duplicate keys or malformed headers stop writing; formula-like names must be written safely as plain text. Sheets is not a transactional database.

No data must be treated as a complete empty result only after the relevant API selection succeeds. Disable the schedule before investigating unexpected output or changing state.

Scope

What this does not include.

Bidirectional sync, accounting, CRM, automatic sheet access, order deletion sync and arbitrary plugin fields.

Package licensing, installation and third-party runtime costs are separate. Final licence, update, support and refund terms require confirmation before purchasing is enabled.

For a compatible, single-store setup.

Standard statuses and simple/variable products are the initial test target. Custom inventory, subscriptions, marketplaces and custom statuses require a compatibility review. The local profile is verified; other environments require acceptance.

See installation scope

Technical profile

Schedule: hourly
Prerequisites: One self-hosted n8n process; N8N_CONCURRENCY_PRODUCTION_LIMIT=1; standard single-store Woo REST v3; read-only HTTPS key; explicit persistent Data Table. Owner SMTP or a selected Google Sheet.
Tested versions: n8n 2.41.6 / Node 24.21.0; WooCommerce 11.1.2 / WordPress 7.1.2 / PHP 8.2.12; HPOS. Local API/Data Tables + synthetic SMTP; Google mocked only.
Limits: Local fixtures: 309 orders, 250 stock entities. Default stop limits: maxEntities 5000 / maxRequests 200 (not a tested workload claim). Standard simple/variable products and statuses. Cloud, multiple workers and custom inventory are unverified.
Support scope: Import, configuration and reproducible package defects; final periods and commercial terms require seller approval.

Runtime and third-party costs are separate. Final licence, update, support and refund terms must be agreed before sales are enabled.