Templates / Analyze Shopify orders with Gemini AI and send weekly Slack insights

Analyze Shopify orders with Gemini AI and send weekly Slack insights

Ready for 3.0

by Oka Hironobu ✓ · 223 views · created 2026-03-04 · Market Research, AI Summarization

Ready 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 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).

  1. Get Last 7 Days Orders (Shopify): get many
  2. Aggregate Sales Data (Code): runs custom JavaScript code
  3. Gemini Sales Analysis (HTTP Request): calls generativelanguage.googleapis.com (POST)
  4. Parse AI Response (Edit Fields (Set)): sets 2 fields: aiInsights, weeklyMetrics
  5. Post to Slack Channel (Slack): uses Slack
  6. Email Report to Stakeholders (Gmail): uses Gmail
  7. Log Metrics to Google Sheets (Google Sheets): append row
  8. Check Revenue Drop >20% (If): checks a condition and branches into true / false
  9. Send Revenue Drop Alert (Slack): uses Slack

Services it uses

ShopifySlackGmailGoogle Sheets

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)

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…

Excerpt from Oka Hironobu's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.