Retail

Retail Sales & Inventory Manager

A complete shop back-office in Google Sheets. It records sales, updates stock, sends receipts, alerts on low stock, handles restocking and sends a daily sales summary.

The Retail Sales & Inventory Manager workflow on the n8n canvas, with its 34 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
Retail
Nodes
34
Apps
HTTP, Google Sheets
Price
Free
Download JSON
On this page

How it works

  1. A sale form checks the product and calculates the total and remaining stock.
  2. Stock is updated, the sale is saved and the customer receives a receipt.
  3. Low stock triggers a manager alert.
  4. Inventory forms add new products or restock existing ones.
  5. A daily summary of sales is generated and sent.

Use cases

  • Convenience and general stores
  • Boutiques
  • Small multi-product shops

What you need

This workflow connects to these apps.

  • n8n
  • HTTP
  • Google Sheets

You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.

  • Google Sheets account
  • Twilio account

Data setup

Create these tables with these exact column names before the first run.

TableColumns
Retail Shop Daily Sales Sheet → inventoryGoogle Sheetsproductstockmin_stockprice
Retail Shop Daily Sales Sheet → salesGoogle Sheetscustomer_namephone_numberproductquantitypricetotaltimedate
Retail Shop Daily Sales Sheet → daily_summaryGoogle Sheetsdatetotal_salesorderstop_product

Setup

  1. Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.

Nodes

NodeType
Sale Form TriggerformTrigger
Fetch Product from InventorygoogleSheets
Validate Product Existsif
Product Not Found Alerttwilio
Calculate Sale, Total & Stockcode
Check Low Stock Thresholdif
Low Stock Alert (Manager)twilio
Update Inventory Stock 1googleSheets
Update Inventory StockgoogleSheets
Save Sale RecordgoogleSheets
Save Sale Record 1googleSheets
Send Customer Receipttwilio
Send Customer Receipt 1twilio
No Operation, do nothingnoOp
Inventory Form TriggerformTrigger
Fetch Inventory RecordsgoogleSheets
Check Product Existscode
Is Product Duplicate?if
Save New InventorygoogleSheets
Stock Update Form TriggerformTrigger
Fetch Product from Inventory1googleSheets
Validate Product Exists1if
Calculate Updated Stockcode
Update Inventory Stock1googleSheets
Daily Summary SchedulerscheduleTrigger
Fetch Today Sales DatagoogleSheets
Calculate Daily Sales Summarycode
Save Daily SummarygoogleSheets
Send Daily Report (Manager)twilio

Frequently asked questions

A complete shop back-office in Google Sheets. It records sales, updates stock, sends receipts, alerts on low stock, handles restocking and sends a daily sales summary. It's a 34-node n8n workflow.

An n8n instance, on n8n Cloud or self-hosted, and credentials for Google Sheets and Twilio. It uses only nodes that ship with n8n, so there's nothing else to install.

It works with 3 tables in Google Sheets. Create them with the column names listed under Data setup on this page before the first run.

Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.

Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.

Keep exploring
  • n8n canvas of the POS Invoice to WhatsApp workflow

    Retail10 nodes

    POS Invoice to WhatsApp

    Each new POS order gets a PDF invoice, which is uploaded to Drive and sent to the customer on WhatsApp. The order status is updated in Google Sheets.

  • n8n canvas of the AI Crop Advisory for Farmers workflow

    Agriculture27 nodes

    AI Crop Advisory for Farmers

    Gives farmers practical, AI-generated crop advice based on their soil, crop and live weather. Advice is delivered instantly on sign-up and refreshed daily over WhatsApp.