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 it

Or 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

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.

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.

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

Connect Odoo and Microsoft Excel

Or pick another template above. Free to start.

Build it with Captain
Odoo and Microsoft ExcelBuild it