Who is this for
Who is this for E-commerce store owners and sales managers who want AI-powered insights from their Shopify data without manually crunching numbers every week. What it does This workflow automatically analyzes your Shopify sales performance every Monday morning and delivers intelligent insights via Slack and email. It pulls the last 7 days of orders, calculates key metrics (revenue, order count, average order value), and sends the data to Gemini AI for trend analysis and actionable recommendations. The AI identifies patterns in your sales data and provides specific suggestions for improving performance. All metrics are logged to Google Sheets for historical tracking, and the team receives instant alerts when revenue drops more than 20% compared to the previous week. How to set up Connect your Shopify store with order read permissions Add your Gemini API key for AI analysis Set up Slack integration and choose your target channels (#sales and #alerts) Configure Gmail credentials for stakeholder email reports Create a Google Sheets document with a "Weekly Metrics" tab for data tracking Update the email recipients and spreadsheet ID in the respective nodes Requirements Shopify store with API access Google Gemini API key Slack workspace Gmail account Google Sheets access How to customize Adjust the revenue drop threshold in the IF node (default: 20%), modify the schedule frequency, customize Gemini prompts for different analysis types, or add additional Slack channels for department-specific reports. An n8n automation workflow template by Oka Hironobu.
Oka Hironobu
web
free
Others in the same category, ranked by how often they are opened.
