Send daily stock and sales profit reports with Google Sheets and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 20 nodes and runs on a schedule (every day at 06:00). Along the way it connects Gmail and Google Sheets.
How it runs
Trigger: On a schedule (every day at 06:00).
- GetData From Note Sheet (Google Sheets): uses Google Sheets
- GetData From SalesDetails Sheet (Google Sheets): uses Google Sheets
- GetData From Incoming Goods Sheet (Google Sheets): uses Google Sheets
- GetData From Stock of Goods Sheet (Google Sheets): uses Google Sheets
- Daily Filter Note (Filter): keeps only the items that match a condition
- Daily SalesDetails Filter (Filter): keeps only the items that match a condition
- Daily FIlter IncomingGoods (Filter): keeps only the items that match a condition
- Merge: merges the data from its input branches
- Sum Total Daily Gross Profit (Summarize): summarizes / groups the items
- Sum By Quantity SalesDetail (Summarize): summarizes / groups the items
…plus 9 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Merge
n8n-nodes-base.merge - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Summarize
n8n-nodes-base.summarize
From the author
Quick overview This workflow runs daily at 6AM to pull yesterday’s sales, incoming goods, and inventory data from Google Sheets, update stock quantities and status in the inventory sheet, and email a profit summary via Gmail. How it works 1. Runs every day at…