FREE N8N TEMPLATE · OPERATIONS & HR
Every morning this n8n workflow collects yesterday's Stripe payments, refunds and failed charges, plus Shopify orders and Google Analytics 4 traffic if you turn them on. It compares each figure with the same weekday last week, asks an AI model to write a short plain-English summary of what changed, and sends it by email and Slack along with the raw numbers.
- DIFFICULTY
- Intermediate
- SET-UP TIME
- About 45 minutes
- NODES
- 10
- CHECKED AGAINST
- n8n 2.41
- Stripe
- Shopify
- Google Analytics 4
- OpenAI or Anthropic
- Gmail
- Slack
LAST REVIEWED OCTOBER 2026
001 / HOW IT WORKS
Step by step, node by node
01Start every morning
A Schedule Trigger runs at 7am. The workflow timezone is Australia/Sydney, so yesterday means yesterday in Australian Eastern time, including daylight saving.
02Set the report dates
A Code node works out yesterday and the same weekday last week, with start and end times for both. Comparing like-for-like weekdays avoids Monday versus Sunday noise.
03Get Stripe charges
An HTTP Request node calls the Stripe charges API using your Stripe credential, covering the eight days in one request and following pagination until every charge in the range is fetched.
04Get Shopify orders (optional)
The Shopify node fetches orders created in the same date range. It ships disabled; enable it and connect your store if you sell through Shopify.
05Get GA4 traffic (optional)
The Google Analytics node runs a GA4 report for users, sessions and page views by date. It also ships disabled, ready to enable with your property ID.
06Calculate the KPIs
A Code node totals gross sales, refunds, successful and failed payments, orders, order value and traffic for each of the two days, and builds a plain table of yesterday versus the same day last week.
07Write a plain-English summary
A Basic LLM Chain sends only the table to your chat model with strict rules: one overall sentence, up to four bullet points, no guessed reasons and no invented figures.
08Send by email and Slack
Gmail emails the summary with the raw figures underneath, and Slack posts it to your chosen channel, so the numbers reach people wherever they start their day.
THE REAL WORKFLOW YOU IMPORT · NODE NAMES AS THEY APPEAR IN N8N
002 / WHY IT EXISTS
Owners and managers often start the day by logging into three or four dashboards to see how yesterday went. Stripe for payments, Shopify for orders, Google Analytics for traffic. It takes time, the numbers are spread across tabs, and on busy mornings it simply does not happen, so a drop in sales or a spike in failed payments goes unnoticed for days.
This template is for small online businesses, subscription services and retailers that want one short message each morning. The figures are calculated in code, not by the AI, and the raw table is included under the summary so anyone can check the numbers. The AI only explains the figures it is given.
WHO IT'S FOR
- →Ecommerce owners selling through Shopify and taking payments with Stripe
- →Subscription and SaaS businesses that bill through Stripe
- →Managers who want a morning snapshot without opening dashboards
- →Small teams that share daily numbers in a Slack channel
003 / WHAT YOU NEED
Tick them off as you go. Nothing is saved; it's just a checklist.
004 / SET IT UP
- 01
Import the workflow JSON into n8n and read the Setup Notes sticky note.
- 02
Create a restricted Stripe key with read access to charges, add it as a Stripe credential, and select it in Get Stripe Charges.
- 03
If you use Shopify, enable Get Shopify Orders, add your store's access token credential and test the node.
- 04
If you use GA4, enable Get GA4 Traffic, connect Google Analytics and replace YOUR_GA4_PROPERTY_ID with your property ID.
- 05
Add your OpenAI credential to the Chat Model node, or replace it with an Anthropic Chat Model connected to Write Plain-English Summary.
- 06
Set the recipient address in Email the Digest and the channel in Post to Slack.
- 07
Run the workflow manually and compare the totals with your Stripe and Shopify dashboards for the same day before activating it.
005 / MAKE IT YOURS
- +Add Xero figures such as cash received or invoices issued yesterday using the Xero node.
- +Switch the comparison to a seven-day rolling average by widening the date range and changing the KPI calculation.
- +Send a weekly version on Monday mornings that compares last week with the week before.
- +Add an alert branch that posts to Slack straight away when failed payments or refunds pass a threshold you set.
- +Write each day's figures to a Google Sheet so you build a simple history for charts.
FOR AUSTRALIAN BUSINESSES
The schedule and the definition of yesterday both use Australia/Sydney time. If you trade on Perth or Brisbane time, change the workflow timezone and the zone in the two Code nodes so days line up with your Stripe and Shopify reports. Stripe amounts are converted from cents, and Stripe and Shopify totals usually include GST for Australian sales, so the digest shows sales including GST unless you adjust the calculation. Only aggregated totals are sent to the AI model, never customer names, emails or card details, which keeps personal information under the Privacy Act 1988 out of offshore AI APIs. For a fully onshore setup, self-host n8n in an Australian cloud region.
Need it hosted in Australia? →006 / TOOLS IN THIS WORKFLOW
n8n
AUTOMATION & AGENT PLATFORMS
A workflow automation platform that combines a visual node editor with code when you need it. It connects hundreds of apps and APIs and includes AI agent nodes that can call language models, tools and memory. Teams can self-host the free Community Edition on their own servers or use n8n's hosted cloud.
Best for australian organisations that need automation data to stay onshore
Onshore possibleFreemiumIntermediateDatarails
FINANCE & ACCOUNTING TOOLS
A financial planning and analysis platform for finance teams that work in Excel. It consolidates data from accounting, CRM and HR systems, then supports budgeting, forecasting, month-end close, cash management and reporting, with AI tools and a connector that lets AI assistants query governed finance data.
Best for mid-sized companies whose planning and analysis still runs on spreadsheets
OffshoreEnterpriseIntermediateJulius AI
PRODUCTIVITY & KNOWLEDGE TOOLS
An AI data analyst that lets you upload spreadsheets or connect data sources, then ask questions in plain English. It writes and runs code behind the scenes to clean data, run analyses and build charts, and can save repeatable analyses as notebooks or reports.
Best for small business owners analysing their own sales data
OffshoreFreemiumBeginnerChatGPT
OpenAI · ASSISTANTS & CHATBOTS
OpenAI's general-purpose AI assistant. It handles writing, coding, file and image analysis, data analysis and web research through a chat interface, with an API for building it into your own systems.
Best for small and mid-sized teams wanting one general assistant for everyday writing and analysis
AU optionFreemiumBeginner
MORE TEMPLATES
All templates →- 10 NODESAI
OPERATIONS & HR
Shopify Low Stock Alerts with AI Supplier Reorder Drafts
ShopifyOpenAI or AnthropicGmailSlackBeginner~30 minutes→ - 15 NODES
OPERATIONS & HR
Appointment Confirmations and SMS Reminders with Calendly and Twilio
CalendlyTwilioGmailIntermediate~45 minutes→ - 10 NODESAI
OPERATIONS & HR
AI Meeting Notes and Action Items to Notion
Google DriveOpenAI or AnthropicNotionGmailIntermediate~30 minutes→
007 / QUESTIONS
Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.
No. All totals and comparisons are calculated in a Code node from the raw Stripe, Shopify and GA4 data. The model only receives the finished table and writes a short summary. The raw table is included in the email so anyone can check the figures.
We set up n8n end to end: hosting in Australia, connecting your systems, testing with real data and handing over documentation.
Book a free call→