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.

On this page
How it works
- A sale form checks the product and calculates the total and remaining stock.
- Stock is updated, the sale is saved and the customer receives a receipt.
- Low stock triggers a manager alert.
- Inventory forms add new products or restock existing ones.
- 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.
| Table | Columns |
|---|---|
| Retail Shop Daily Sales Sheet → inventoryGoogle Sheets | productstockmin_stockprice |
| Retail Shop Daily Sales Sheet → salesGoogle Sheets | customer_namephone_numberproductquantitypricetotaltimedate |
| Retail Shop Daily Sales Sheet → daily_summaryGoogle Sheets | datetotal_salesorderstop_product |
Setup
- 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.
- Connect the credentials listed above.
- Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
- Replace placeholder emails, phone numbers, and form links with your own.
- 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
| Node | Type |
|---|---|
| Sale Form Trigger | formTrigger |
| Fetch Product from Inventory | googleSheets |
| Validate Product Exists | if |
| Product Not Found Alert | twilio |
| Calculate Sale, Total & Stock | code |
| Check Low Stock Threshold | if |
| Low Stock Alert (Manager) | twilio |
| Update Inventory Stock 1 | googleSheets |
| Update Inventory Stock | googleSheets |
| Save Sale Record | googleSheets |
| Save Sale Record 1 | googleSheets |
| Send Customer Receipt | twilio |
| Send Customer Receipt 1 | twilio |
| No Operation, do nothing | noOp |
| Inventory Form Trigger | formTrigger |
| Fetch Inventory Records | googleSheets |
| Check Product Exists | code |
| Is Product Duplicate? | if |
| Save New Inventory | googleSheets |
| Stock Update Form Trigger | formTrigger |
| Fetch Product from Inventory1 | googleSheets |
| Validate Product Exists1 | if |
| Calculate Updated Stock | code |
| Update Inventory Stock1 | googleSheets |
| Daily Summary Scheduler | scheduleTrigger |
| Fetch Today Sales Data | googleSheets |
| Calculate Daily Sales Summary | code |
| Save Daily Summary | googleSheets |
| 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.



