Analyze Shopify orders with Gemini AI and send weekly Slack insights
Ready for 3.0What this workflow does
This workflow has 10 nodes and runs on a schedule (cron 0 9 * * MON). Along the way it connects Shopify, Slack, Gmail and Google Sheets. It also calls generativelanguage.googleapis.com over HTTP.
How it runs
Trigger: On a schedule (cron 0 9 * * MON).
- Get Last 7 Days Orders (Shopify): get many
- Aggregate Sales Data (Code): runs custom JavaScript code
- Gemini Sales Analysis (HTTP Request): calls generativelanguage.googleapis.com (POST)
- Parse AI Response (Edit Fields (Set)): sets 2 fields: aiInsights, weeklyMetrics
- Post to Slack Channel (Slack): uses Slack
- Email Report to Stakeholders (Gmail): uses Gmail
- Log Metrics to Google Sheets (Google Sheets): append row
- Check Revenue Drop >20% (If): checks a condition and branches into true / false
- Send Revenue Drop Alert (Slack): uses Slack
Services it uses
HTTP calls to: generativelanguage.googleapis.com
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 (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Shopify
n8n-nodes-base.shopify - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if
From the author
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…