Sync inventory updates between systems via webhook and Google Sheets logging

(Retail Automation) Transfer Inventory Updates Across Systems

This workflow automatically synchronizes inventory quantity updates between systems using a webhook-driven approach. When an inventory update is received, the workflow validates the source, prepares a clean payload, sends the update to a secondary system via an HTTP API and logs the update into Google Sheets for tracking and auditing.

Quick Implementation Steps

1. Import the workflow JSON into n8n. 2. Configure the Webhook URL in your source system. 3. Update the HTTP Request node with the secondary system API endpoint. 4. Connect Google Sheets and select the target spreadsheet. 5. Activate the workflow.

What It Does

This workflow listens for inventory update events sent from an external system such as an online store, POS, ERP or warehouse platform. Once an update is received, the workflow normalizes the incoming data by extracting key fields like product ID, SKU, stock quantity, source system and modification timestamp.

To avoid circular synchronization issues, the workflow validates the origin of the update and ensures that updates originating from the secondary system are not reprocessed. Valid inventory updates are then transformed into a clean, API-ready payload and sent to a secondary system using an HTTP Request node.

After the inventory update is successfully pushed to the secondary system, the workflow logs the inventory details into Google Sheets. This provides a simple audit trail for tracking inventory movements and troubleshooting sync issues.