AutomationMart
Home/Browse/Export Odoo company data via API endpoint with JSON/Excel output options
n8n

Export Odoo company data via API endpoint with JSON/Excel output options

n8nn8n9 modulesv1.0
UNSUPPORTED_SLUG_FORMAT

How it works This workflow provides an API endpoint /api/v1/get-companies that retrieves company records directly from your Odoo database. It’s built for teams who need to query or export company data — either as structured JSON for integrations or as Excel (.xlsx) for reporting. When a request is made, the workflow: 1. Accepts query parameters (name, responseformat). 2. Validates the name input (required for company search). 3. Fetches all matching companies from Odoo using a like

At a glance

Export Odoo company data via API endpoint with JSON/Excel output options is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects UNSUPPORTED_SLUG_FORMAT. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
UNSUPPORTED_SLUG_FORMAT
Modules
9
Price
Free
Version
v1.0
Export Odoo company data via API endpoint with JSON/Excel output options workflow diagram

About this workflow

How it works This workflow provides an API endpoint /api/v1/get-companies that retrieves company records directly from your Odoo database. It’s built for teams who need to query or export company data — either as structured JSON for integrations or as Excel (.xlsx) for reporting. When a request is made, the workflow: 1. Accepts query parameters (name, responseformat). 2. Validates the name input (required for company search). 3. Fetches all matching companies from Odoo using a like filter for partial name matches. 4. Returns results as a JSON response or Excel file depending on the responseformat parameter. This makes it ideal for quickly exporting or syncing company information with other tools. Setup steps 1. Open the Webhook node and note the endpoint /api/v1/get-companies. 2. Connect your Odoo API credentials in the Odoo node. 3. Optionally update the fieldsList in the Odoo node to include more company details (VAT, address, etc.). 4. Test using a browser or Postman: - /api/v1/get-companies?name=Tech&responseformat=json - /api/v1/get-companies?name=Tech&responseformat=excel

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Build your own Youtube MCP server

This n8n demonstrates how to build a simple Youtube MCP server to look up videos on Youtube and download their transcripts for research purposes. Youtube videos are a great source of new and updated information on a variety of cutting edge developments but they''re are not always simple to understand and lengthy videos may take too much time. Using this MCP server, you extract and feed their transcripts for your AI agents which then allows it to breakdown the content into manageble learnings and

Free

Generate recipes from ingredients with Ollama AI Chef Agent

What It Does The Chef Agent is your AI-powered kitchen companion—ready to turn leftover ingredients into meal inspiration. It's a simple, fun n8n automation that: - Accepts a list of ingredients via webhook - Uses Ollama AI to suggest 5 creative recipes or food ideas - Recommends up to 3 missing ingredients to improve the dish - Returns a fallback message if the AI is unavailable - Includes setup notes for beginners Requirements - An active n8n instance (local or hosted) - Ollama AI running loca

Free

Correlating messages over Logic Apps using Service Bus

which shows how we can correlate messages over Logic Apps using Azure Service Bus

Free

Create Dynamic Workflows Programmatically via Webhooks & n8n API

Overview This workflow exposes an HTTP endpoint (webhook) that accepts a JSON definition of an n8n workflow, validates it, and—if everything is correct—dynamically creates that workflow in the n8n instance via its internal API. If any validation fails or the API call encounters an error, an explanatory message with details is returned. Workflow Diagram Step-by-Step Details 1. Webhook Type: Webhook (POST) Path: /webhook/create-workflow Purpose: Expose a URL to receive a JSON definition of a wo

Free

Capture vCard QR code contacts with AllCodeRelay and add them to KlickTipp

Community Node Disclaimer: This workflow uses KlickTipp community nodes. Introduction This workflow captures vCard contact data from a scanned QR code using AllCodeRelay and automatically creates a contact in KlickTipp. It is built for event lead capture and fast contact transfer: scan a vCard QR code, send the scan result to a webhook, parse the vCard into clean contact fields, and submit the contact to KlickTipp with Double Opt-In (DOI). This template is ideal for marketers, sales teams, and e

Free

Remote IOT sensor monitoring via MQTT and InfluxDB

Read and store IOT sensor data with the MQTT Trigger and InfluxDB tonyduffy@protonmail.com This workflow is for users wanting a practical example of how to obtain data from remote IOT systems using the MQTT protocol in an n8n environment. The template provides typical n8n node implementation and configuration settings necessary to read and store IOT data. The workflow reads the temperature and humidity data from a remote IOT system in this case a DHT22 sensor connected to a ESP32 micro controlle

Free

Create PDF from images for free via Google Slides and Google Drive

This n8n template offers a free and automated way to convert images from a Google Drive folder into a single PDF document. It uses Google Slides as an intermediary, allowing you to control the final PDF's page size and orientation. If you're looking for a no-cost solution to batch convert images to PDF and need flexibility over the output dimensions (like A4, landscape, or portrait), this template is for you! It's especially handy for creating photo albums, visual reports, or simple portfolios d

Free

AI recruiting pipeline: Job to candidate shortlist with Apollo & Airtable

Who’s it for Recruiting agencies, executive search firms, and in-house talent teams that want to automate candidate sourcing and prequalification. Instead of spending hours searching, scoring, and writing outreach, this workflow turns any job description into a ready-to-use shortlist with personalized messages. Youtube Walkthrough []( What it does (How it works) This workflow takes a job description (title, description, and location) and runs a complete recruiting automation pipeline: - Normaliz

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free