{"product_id":"odoo-daily-sales-summary-email-via-smtp-with-n8n-workflow","title":"Odoo Daily Sales Summary Email via SMTP with n8n Workflow","description":"\u003ch3\u003eGet an Odoo daily sales summary email—automatically sent via SMTP using an n8n workflow\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 18:00\u003c\/strong\u003e using an n8n \u003cem\u003eschedule trigger\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes the reporting window\u003c\/strong\u003e by calculating a start date based on configurable \u003cem\u003edays back\u003c\/em\u003e and a \u003cem\u003eUTC offset\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConnects to Odoo via JSON-RPC\u003c\/strong\u003e: authenticates, retrieves the user ID, and prepares subsequent API calls.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches sales orders\u003c\/strong\u003e where \u003ccode\u003edate_order\u003c\/code\u003e is on or after the calculated start date, pulling key fields such as customer, total amount, order state, and order date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies orders\u003c\/strong\u003e into quotation vs confirmed states and computes totals and counts, including \u003cem\u003econfirmed revenue\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a daily HTML email\u003c\/strong\u003e containing summary KPIs and an orders table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the report via SMTP\u003c\/strong\u003e with a generated subject and HTML body to your configured recipient(s).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSales managers who need a \u003cstrong\u003edaily Odoo sales report\u003c\/strong\u003e without exporting data.\u003c\/li\u003e\n  \u003cli\u003eOperators managing multiple teams who want automated \u003cstrong\u003econfirmed vs quotation\u003c\/strong\u003e visibility.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and automation engineers who deploy n8n workflows for \u003cstrong\u003eOdoo KPI reporting\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eTeams that prefer branded email summaries with an \u003cstrong\u003eorders table\u003c\/strong\u003e delivered each day.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e (daily at 18:00)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e (date window calculation, metrics logic, HTML builder)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e to Odoo using \u003cstrong\u003eJSON-RPC\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail Send\u003c\/strong\u003e via \u003cstrong\u003eSMTP\u003c\/strong\u003e (e.g., Gmail App Passwords supported)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e configure Odoo URL, database, login, API key, days-back window, and UTC offset in the workflow code; add SMTP credentials; set \u003ccode\u003etoEmail\u003c\/code\u003e and \u003ccode\u003efromEmail\u003c\/code\u003e; optionally adjust report language and currency in the HTML builder.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46042470842547,"sku":"N8N-19642","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ZLw2qEhEImQ4mCsWgwwwg_ovKaYbBb.png?v=1789549444","url":"https:\/\/buyflowscripts.com\/products\/odoo-daily-sales-summary-email-via-smtp-with-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}