Generate Daily E-Commerce Order Reports with Supabase, GPT-4.1 and Gmail
n8n9 modulesv1.0This n8n workflow automates the generation and delivery of a daily order summary via email. It leverages an AI Agent to fetch and summarize e-commerce order data from the last 24 hours stored in Supabase, providing a concise overview of the daily business operations. How it works - Scheduled Trigger: The workflow is triggered every day at 8 AM. - Sender Email Configuration: A manual step allows you to set the sender's email address. - AI Agent: An AI Agent node acts as the central intelligence,
At a glance
Generate Daily E-Commerce Order Reports with Supabase, GPT-4.1 and Gmail is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects agent, gmailTool, lmChatOpenAi, scheduleTrigger. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- agent, gmailTool, lmChatOpenAi, scheduleTrigger, set, supabaseTool
- Modules
- 9
- Price
- Free
- Version
- v1.0
About this workflow
This n8n workflow automates the generation and delivery of a daily order summary via email. It leverages an AI Agent to fetch and summarize e-commerce order data from the last 24 hours stored in Supabase, providing a concise overview of the daily business operations. How it works - Scheduled Trigger: The workflow is triggered every day at 8 AM. - Sender Email Configuration: A manual step allows you to set the sender's email address. - AI Agent: An AI Agent node acts as the central intelligence, interacting with various tools to gather and process data. - Supabase Data Fetching: The AI Agent calls "Get Orders," "Get Order Items," "Get Clients," and "Get Products" tables to retrieve relevant e-commerce data from your Supabase database. - OpenAI Chat Model: An OpenAI Chat Model with the 4.1 model is integrated to help the AI Agent understand and summarize the fetched data into a human-readable format. - Gmail Summary: Finally, the workflow sends a summarized report to your specified email address using the "Send Gmail Summary" node. Set up steps This setup will take approximately 15-20 minutes. 1. Download the workflow: Download this workflow and import it into your n8n instance. 2. Configure the Daily 8am trigger: Ensure the "Daily 8am" trigger is active and set to your desired timezone. 3. Set Sender Email: In the "Set Sender Email" node, manually enter the email address you wish to use as the sender for the daily reports. 4. Configure AI Agent: - Chat Model: Connect your OpenAI Chat Model credential. - Memory & Tools: Ensure all the necessary nodes ("Get Orders", "Get Order Items", "Get Clients", "Get Products", "Send Gmail Summary") are correctly linked to the AI Agent. In our workflow we call data from 4 tables in Supabase. 5. Configure Supabase Database Connections: - For each of the "Get Orders," "Get Order Items," "Get Clients," and "Get Products" nodes, you will need to configure your Supabase credentials to access your e-commerce database. - Select the tables (e.g., orders, orderitems, clients, products) that you want the AI agent to pull data from in your Supabase schema. 6. Configure Gmail Credentials: In the "Send Gmail Summary" node, connect your Gmail account credentials to allow n8n to send emails on your behalf. 7. Test the workflow: Run the workflow manually to ensure all connections are working correctly and the email summary is generated as expected. Requirements - n8n instance: An active n8n instance (self-hosted or cloud). - Supabase Account: A Supabase account with your e-commerce order data accessible. - OpenAI API Key: An OpenAI API key for the Chat Model. - Gmail Account: A Gmail account credentials to send the daily summaries. Need help? Feel free to contact us at 1 Node. Get instant access to a library of free resources we created.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Lead qualification and scoring with Jotform, Gemini AI, and Slack
Send sales forecast charts and answer Q&A on WhatsApp with OpenAI
Automatic email unsubscribe handler: Outlook to BigQuery integration
Automatic YouTube shorts generator
Lightroom cloud to Instagram auto poster (AI captions)
Ai fitness coach Strava data analysis and personalized training insights
Multilingual RSS to WordPress publishing with OpenAI, ACF, and AI-generated images
Voiceflow demo support chatbot
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you