# Weekly Shopify sales report: order count and total sum to Slack and Google Sheets
This automation streamlines weekly sales reporting from Shopify. Every Monday at 10:00, it pulls new orders, calculates key metrics, sends a summary to Slack, and logs data in Google Sheets—eliminating manual exports and repetitive tasks.
## Who it´s for
- Shopify store owners who need regular sales reports.
- E-commerce managers tracking performance via Slack.
- Analysts collecting data for visualization and dashboards.
## What the automation does
- Triggers weekly via cron schedule every Monday at 10:00.
- Fetches all orders from Shopify API.
- Filters orders by creation date (e.g., after August 17, 2021).
- Calculates total count and sum of filtered orders.
- Sends a concise text report to a designated Slack channel.
- Appends data (date, count, sum) to Google Sheets for historical tracking.
## What´s included
- Ready-to-use n8n workflow.
- Trigger and conditional filtering logic (Date & Time + IF nodes).
- Integrations with Shopify, Google Sheets, and Slack.
- Basic textual instructions for setup and adaptation.
## Requirements for setup
- n8n account (cloud or self-hosted).
- Shopify store with API access (read permissions for orders).
- Google Account with access to Google Sheets.
- Slack workspace with posting rights in a channel.
## Benefits and outcomes
- Saves time on manual reporting.
- Keeps team informed in real time via Slack.
- Builds a continuous sales history in Google Sheets.
- Reduces human error in calculations.
- Enables transparency without IT involvement.
- Provides clean data for charts and comparisons.
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet