Analyze Shopify orders with Gemini AI and send weekly Slack insights

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

1. Connect your Shopify store with order read permissions 2. Add your Gemini API key for AI analysis 3. Set up Slack integration and choose your target channels (sales and alerts) 4. Configure Gmail credentials for stakeholder email reports 5. Create a Google Sheets document with a "Weekly Metrics" tab for data tracking 6. Update the email recipients and spreadsheet ID in the respective nodes

Requirements