Automated Daily E-commerce Order Summary via AI and Supabase

This workflow automates the generation and emailing of a daily summary report of recent e-commerce orders. Triggered every morning at 8 am, it connects to a Supabase database to retrieve orders from the last 24 hours, along with associated client, product, and order item details. An AI-powered agent then processes this data to create a comprehensive yet concise plain text report, including total orders, revenue, and detailed order breakdowns. The report is then automatically emailed to the specified recipient. This workflow is ideal for online store owners or teams aiming to streamline daily reporting, maintain oversight of recent sales, and improve operational efficiency without manual intervention.