Daily Shopify order summary in Slack

Gemini sums up the day's Shopify orders and sends the report. This n8n template runs every day at 23:59 in your local time zone, reads the day's orders from the Shopify API and processes the figures. Google Gemini turns the numbers into a readable daily report. Each daily summary is appended to a Google Sheet, the report is sent as an HTML email and posted to Slack. When there are no orders, Slack gets a short notice and no email is sent, and errors are posted to a chosen Slack channel. It suits store owners and managers who want one report per day.

n8nRead on 2026-11-165 steps

Steps

  1. Trigger: Trigger
    Every day at 23:59.
  2. IngestionShopify
    Reads the day's orders.
  3. ProcessingShopify
    Computes the figures.
  4. AI generationGoogle Gemini
    Gemini writes the daily report.
  5. Output: DistributionSlack
    Google Sheet row, HTML email and Slack.

Limits

  • The page names Gemini but no model version.

What it does well

  • Days without orders send a short Slack notice instead of an empty email.

Before you import

Needs the store admin URL and an API token with orders:read, a Slack bot with chat:write, Google Sheets and Gmail sign-in, and a Google Gemini API key.

Similar templates