Summarize daily Shopify orders with Gemini, Google Sheets, Gmail and Slack

🛍️ Shopify Daily Order Reporting: AI Summaries & Multichannel Alerts

Summary E-commerce store management made easy. The workflow pulls your daily Shopify orders, calculates essential metrics like revenue and fulfillment rates, and categorizes them by status (shipped, returned, cancelled, or pending). Gemini AI then transforms this data into a polished daily summary, logs the metrics into Google Sheets, and delivers the final report directly to your team via Slack and email.

Perfect for store owners and managers who want a hands-off, easy-to-read daily brief on how the store performed.

Key Features Automated Math: Instantly calculates total orders, revenue, average order value, and categorizes whether orders are paid, shipped, returned, cancelled, or pending. AI-Powered Summaries: Our AI (Gemini) reads your order data and writes a clean daily summary that looks good in Slack and email. Multichannel Updates: Delivers the final summary directly to your inbox via Gmail and your team's Slack channel simultaneously. Centralized Logging: Every daily summary is appended to a Google Sheet for easy long-term tracking. Safety Net Alerts: If any step fails (like a Shopify API timeout or a full Google Sheet), an error message appears in the dedicated Slack channel you select.

🧩 Nodes Used Schedule Trigger: Initiates the workflow daily at the specified time. Set: Defines global configuration variables like the recipient email and sheet URL. Shopify: Fetches the daily updated orders from your store. Code: Custom JavaScript to calculate metrics and categorize orders safely. If: Routes the workflow logic based on whether new orders were found. Google Sheets: Appends the parsed daily metrics to your tracking sheet. Advanced AI (Gemini Model & Chain): Generates the formatted summary text. Gmail: Sends the HTML formatted daily report via email. Slack: Delivers reports, zero-order notices, and error alerts to specified channels. Error Trigger: Catches workflow failures for global error handling.

How It Works 1. Trigger: Runs automatically every day at 23:59 (in your local timezone). 2. Ingestion: Connects to Shopify's order system and pulls all orders from the current day. 3. Processing: Sorts the raw data into actionable categories (shipped, refunded, cancelled, pending). 4. AI Generation: Gemini translates the numbers into a readable daily report. If there are no orders for the day, Slack gets a quick "no updates" ping, and the email is NOT sent. 5. Distribution: Logs the data to Google Sheets, emails the summary via Gmail, and posts it to Slack.

---

🛠️ Setup Instructions