Odoo and Microsoft Excel automations
Odoo holds invoices, and “When an invoice is paid” adds a Microsoft Excel row with “Add Row To Table”.
Set up an automation: when an invoice is paid in Odoo, add row to table in Microsoft Excel
Build itOr have an AI agent work across Odoo and Microsoft Excel: it decides what to do in each on every run, on a schedule or when you ask it in its chat.
Odoo and Microsoft Excel in practice
Used for
Odoo holds invoices, and “When an invoice is paid” adds a Microsoft Excel row with “Add Row To Table”.
Best template
“When an invoice is paid” in Odoo, then “Add Row To Table” in Microsoft Excel. It runs when an invoice is marked paid, so the table lists paid invoices only.
Watch out
“Lead created or updated” fires on edits too, so “Add Row To Table” can add the same lead twice.
Odoo and Microsoft Excel templates
Pick one and Captain builds it with you.


When an invoice is paid in Odoo, add row to table in Microsoft Excel
Build this

When an invoice is created in Odoo, add row to table in Microsoft Excel
Build this

When a helpdesk ticket is created or updated in Odoo, add row to table in Microsoft Excel
Build this

When lead created or updated in Odoo, add row to table in Microsoft Excel
Build this

When opportunity created or updated in Odoo, add row to table in Microsoft Excel
Build this

When a contact is created or updated in Odoo, add row to table in Microsoft Excel
Build this

When an invoice is paid in Odoo, update row in Microsoft Excel
Build this

When an invoice is created in Odoo, update row in Microsoft Excel
Build this

When a helpdesk ticket is created or updated in Odoo, update row in Microsoft Excel
Build this

When lead created or updated in Odoo, update row in Microsoft Excel
Build this

When opportunity created or updated in Odoo, update row in Microsoft Excel
Build this

When a contact is created or updated in Odoo, update row in Microsoft Excel
Build this
Odoo and Microsoft Excel triggers and actions
Every one of both apps. A trigger starts the work; actions are the steps.
Triggers
6- When a contact is created or updatedRuns the workflow automatically whenever a contact is created or updated in Odoo.
- Opportunity created or updatedRuns the workflow automatically whenever an opportunity is created or updated in Odoo.
- Lead created or updatedTriggers when a lead is created or updated in your Odoo CRM.
- When a helpdesk ticket is created or updatedRuns the workflow automatically whenever a helpdesk ticket is created or updated with the specified status.
- When an invoice is createdRuns the workflow automatically whenever an invoice or refund is created or updated in Odoo.
- When an invoice is paidRuns the workflow automatically whenever an invoice is marked as paid in your account.
No triggers match.
Actions
15- Create sales opportunityStart a new sales opportunity in Odoo to efficiently manage and track potential business deals.
- Add new leadGenerate a new lead in your Odoo CRM system.
- Update contactUpdate an existing contact's information and return the updated details.
- Get leadsRetrieve leads from Odoo, search by ID, email, or name, or list leads using filters, sorting, and pagination.
- Update opportunityFind an opportunity by ID, email, or title, update the selected fields, and return the updated record.
- Find opportunitiesFind CRM opportunities using filters or by ID, name, or email and retrieve their details.
- Create contactCreate a contact with name, contact details, address, and optional fields, then return the created record.
- Update leadFind a lead by ID, email, or name and update selected fields.
- Find contactsFind or list Odoo contacts using filters, pagination, or specific criteria (ID, email, name, phone, or internal reference).
- Create helpdesk ticketCreate a helpdesk ticket with customer information, team, assignee, priority, tags, description, and other optional fields.
- Mark an opportunity as wonLocate an opportunity by ID, email, or name, mark it as Won, and return its updated details.
- Mark opportunity as lostMark an opportunity as lost and optionally add a lost reason and feedback.
- Delete contactDelete a contact in Odoo by ID and return the deleted contact's basic details.
- Delete opportunityDelete an opportunity in Odoo CRM.
- Delete leadDelete a lead in Odoo and return the deleted lead's details.
No actions match.
Actions
4- Find rowFind a Row in a table by column and value
- Create spreadsheetCreate a New Spreadsheet
- Update rowUpdate Row
- Add row to tableAdd a row to an Excel table
No actions match.
Questions about Odoo and Microsoft Excel
What can start a Odoo and Microsoft Excel automation?
“When an invoice is paid”, “When an invoice is created”, “When a helpdesk ticket is created or updated”, “Lead created or updated” and “Opportunity created or updated”, and the others in the templates above.
All Odoo integrations · All Microsoft Excel integrations · Every app, A to Z