{"product_id":"odoo-timesheet-to-invoice-n8n-workflow-gmail-slack-alerts","title":"Odoo Timesheet to Invoice n8n Workflow: Gmail \u0026 Slack Alerts","description":"\u003ch3\u003eTurn Odoo Timesheets into Slack reminders, Gmail summaries, and draft invoices—fully automated in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your \u003cstrong\u003eOdoo timesheets\u003c\/strong\u003e for missing or low weekly hours, sends \u003cstrong\u003eSlack alerts\u003c\/strong\u003e to employees, emails a weekly hours-by-project report via \u003cstrong\u003eGmail\u003c\/strong\u003e, and creates \u003cstrong\u003edraft Odoo invoices\u003c\/strong\u003e for projects with enough unbilled hours—then notifies PMs in Slack when those invoices are marked paid.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvery Friday at 5pm:\u003c\/strong\u003e fetches this week’s Odoo timesheet entries and active employees from Odoo, flags employees with \u003cstrong\u003e0\u003c\/strong\u003e or \u003cstrong\u003eunder 10 hours\u003c\/strong\u003e, and sends each employee a \u003cstrong\u003eSlack reminder\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly Gmail email:\u003c\/strong\u003e aggregates the same Odoo timesheet data by project and emails the PM team a \u003cstrong\u003eGmail summary table\u003c\/strong\u003e showing hours logged per project.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvery day at 6pm:\u003c\/strong\u003e pulls the last \u003cstrong\u003e90 days\u003c\/strong\u003e of Odoo timesheet entries, matches projects to an \u003cstrong\u003eops-maintained billing map\u003c\/strong\u003e, and calculates \u003cstrong\u003eunbilled hours\u003c\/strong\u003e since the last invoiced date stored in workflow static data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDraft invoice creation:\u003c\/strong\u003e for projects with \u003cstrong\u003eat least 10 unbilled hours\u003c\/strong\u003e, creates a \u003cstrong\u003edraft customer invoice in Odoo\u003c\/strong\u003e with a summarized hourly line item, then emails the client the draft invoice details via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents double-billing:\u003c\/strong\u003e updates the workflow’s stored “last invoiced” date per project so future runs only bill newly logged hours.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHourly paid notifications:\u003c\/strong\u003e checks Odoo invoices for recent payment updates and posts a \u003cstrong\u003e“paid” notification\u003c\/strong\u003e to a PM \u003cstrong\u003eSlack\u003c\/strong\u003e channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling:\u003c\/strong\u003e emails the ops team via Gmail if Odoo data fetches fail, and logs downstream Slack\/Gmail\/invoice failures without stopping the run.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce timesheet forgetfulness by reminding employees via \u003cstrong\u003eSlack\u003c\/strong\u003e when weekly hours are missing or low.\u003c\/li\u003e\n  \u003cli\u003eSend consistent weekly project utilization reports to PMs using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomate invoicing preparation from Odoo time logs using a billing threshold (10 unbilled hours) and a persisted “last invoiced” state.\u003c\/li\u003e\n  \u003cli\u003eKeep PMs informed when invoices move to a paid status—without manual checking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Odoo (timesheets via \u003ccode\u003eaccount.analytic.line\u003c\/code\u003e), Gmail, Slack\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes mentioned in this template:\u003c\/strong\u003e set, code, no op, odoo, gmail, slack\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e Friday 5pm (weekly checks + reminders), daily 6pm (billing + draft invoices), hourly (paid notifications)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirement:\u003c\/strong\u003e add an \u003cstrong\u003eOdoo API credential\u003c\/strong\u003e with access to timesheets (e.g., \u003ccode\u003eaccount.analytic.line\u003c\/code\u003e)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865766518963,"sku":"N8N-18354","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/FUvG_L9o-HMzsdrDA_LYR_tWVJeYtZ.png?v=1787044713","url":"https:\/\/buyflowscripts.com\/products\/odoo-timesheet-to-invoice-n8n-workflow-gmail-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}