Odoo Daily Sales Summary Email via SMTP with n8n Workflow

Get an Odoo daily sales summary email—automatically sent via SMTP using an n8n workflow

This n8n automation pulls your most recent Odoo sales orders every day, calculates key sales KPIs, generates a localized HTML report (English or Arabic), and emails it using an SMTP connection—so you can monitor performance without manual reporting.

What this workflow does

• Runs daily at 18:00 using an n8n schedule trigger.
• Computes the reporting window by calculating a start date based on configurable days back and a UTC offset.
• Connects to Odoo via JSON-RPC: authenticates, retrieves the user ID, and prepares subsequent API calls.
• Fetches sales orders where date_order is on or after the calculated start date, pulling key fields such as customer, total amount, order state, and order date.
• Classifies orders into quotation vs confirmed states and computes totals and counts, including confirmed revenue.
• Builds a daily HTML email containing summary KPIs and an orders table.
• Sends the report via SMTP with a generated subject and HTML body to your configured recipient(s).

Use cases

• Sales managers who need a daily Odoo sales report without exporting data.
• Operators managing multiple teams who want automated confirmed vs quotation visibility.
• SaaS operators and automation engineers who deploy n8n workflows for Odoo KPI reporting.
• Teams that prefer branded email summaries with an orders table delivered each day.

Technical details

• Schedule Trigger (daily at 18:00)
• Code (date window calculation, metrics logic, HTML builder)
• HTTP Request to Odoo using JSON-RPC
• Email Send via SMTP (e.g., Gmail App Passwords supported)

Setup: configure Odoo URL, database, login, API key, days-back window, and UTC offset in the workflow code; add SMTP credentials; set toEmail and fromEmail; optionally adjust report language and currency in the HTML builder.