{"product_id":"sync-weekly-odoo-sales-kpis-to-google-sheets-slack-n8n","title":"Sync Weekly Odoo Sales KPIs to Google Sheets \u0026 Slack (n8n)","description":"\u003ch3\u003eSync Odoo weekly Sales KPIs to Google Sheets \u0026amp; Slack—automatically every Monday (n8n)\u003c\/h3\u003e\n\u003cp\u003eGet your previous week’s Odoo sales performance summarized and shared in one place: a Google Sheets KPI tracker, a “Top Products” leaderboard, and a formatted Slack weekly update—triggered every Monday at 7:00 AM by an n8n workflow.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule:\u003c\/strong\u003e Automatically executes every Monday at \u003cstrong\u003e7:00 AM\u003c\/strong\u003e and computes the previous week’s \u003cstrong\u003eMonday–Sunday\u003c\/strong\u003e date window and label.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls sales KPIs from Odoo:\u003c\/strong\u003e Retrieves \u003cstrong\u003esales orders\u003c\/strong\u003e from Odoo, then aggregates \u003cstrong\u003eorder count\u003c\/strong\u003e and \u003cstrong\u003etotal sales value\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates invoice performance:\u003c\/strong\u003e Pulls \u003cstrong\u003einvoices\u003c\/strong\u003e from Odoo and computes \u003cstrong\u003etotal invoiced\u003c\/strong\u003e, \u003cstrong\u003epaid (invoiced minus residual)\u003c\/strong\u003e, and \u003cstrong\u003eoutstanding\u003c\/strong\u003e amounts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRanks top products:\u003c\/strong\u003e Retrieves \u003cstrong\u003esale order lines\u003c\/strong\u003e and ranks the \u003cstrong\u003etop five products by revenue\u003c\/strong\u003e for the week.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites to Google Sheets:\u003c\/strong\u003e\n    \u003cul\u003e\n      \u003cli\u003eAppends \u003cstrong\u003eone KPI summary row\u003c\/strong\u003e to the \u003cstrong\u003e“KPI Tracker”\u003c\/strong\u003e tab.\u003c\/li\u003e\n      \u003cli\u003eAppends \u003cstrong\u003eweekly top-product rows\u003c\/strong\u003e to the \u003cstrong\u003e“Top Products”\u003c\/strong\u003e tab.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts to Slack:\u003c\/strong\u003e Sends a formatted weekly KPI summary to your chosen Slack channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError routing:\u003c\/strong\u003e Routes any step failures (Odoo, Google Sheets, or Slack) to a configurable \u003cstrong\u003ealert placeholder\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLeadership teams want a consistent weekly view of \u003cstrong\u003eOdoo sales KPIs\u003c\/strong\u003e without manual reporting.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers need a reliable \u003cstrong\u003en8n Odoo → Google Sheets → Slack\u003c\/strong\u003e pipeline for KPI tracking.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators track weekly order volume, invoiced\/paid\/outstanding amounts, and top-selling products.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow\u003c\/strong\u003e nodes: set, code, no op, odoo, slack, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOdoo models:\u003c\/strong\u003e \u003cem\u003esale.order\u003c\/em\u003e, \u003cem\u003eaccount.move\u003c\/em\u003e, \u003cem\u003esale.order.line\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e OAuth credential; requires spreadsheet ID plus tabs \u003cstrong\u003e“KPI Tracker”\u003c\/strong\u003e and \u003cstrong\u003e“Top Products”\u003c\/strong\u003e with matching column headers\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack:\u003c\/strong\u003e OAuth credential; configurable target channel (e.g., “leadership-team”)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862249758899,"sku":"N8N-18316","price":65.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/gcx8tfa7fMXBKLxz2rbNa_JG40QWAA.png?v=1786957821","url":"https:\/\/buyflowscripts.com\/products\/sync-weekly-odoo-sales-kpis-to-google-sheets-slack-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}