AutomationMart
Home/Browse/Fetch Odoo customer data and export to JSON or Excel
n8n

Fetch Odoo customer data and export to JSON or Excel

n8nn8n9 modulesv1.0
UNSUPPORTED_SLUG_FORMAT

Odoo Customers API – Export to JSON or Excel Odoo Customers API – Export to JSON or Excel provides a simple way to fetch customer records from your Odoo database and get them back either as a structured JSON response or a downloadable Excel (.xlsx) file. ⚙️ What it does - Listens for HTTP GET requests on the endpoint /api/v1/get-customers. - Checks for the required name parameter and builds a search filter automatically. - Queries the res.partner model to return only customer contacts (iscompany

At a glance

Fetch Odoo customer data and export to JSON or Excel 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
Fetch Odoo customer data and export to JSON or Excel workflow diagram

About this workflow

Odoo Customers API – Export to JSON or Excel Odoo Customers API – Export to JSON or Excel provides a simple way to fetch customer records from your Odoo database and get them back either as a structured JSON response or a downloadable Excel (.xlsx) file. ⚙️ What it does - Listens for HTTP GET requests on the endpoint /api/v1/get-customers. - Checks for the required name parameter and builds a search filter automatically. - Queries the res.partner model to return only customer contacts (iscompany = false). - Delivers results in JSON by default, or as an Excel (.xlsx) export when responseformat=excel is included. 📥 Parameters - name — Required. Used for partial matching on customer names (via Odoo’s Like filter). - responseformat — Optional. Accepts json (default) or excel. 🔗 Examples Excel Example GET /api/v1/get-customers?name=Demo&responseformat=excel JSON Example GET /api/v1/get-customers?name=Demo&responseformat=json 🧩 Default fields displayname, name, email, phone, mobile, parentid, companyid, countrycode, countryid 🛠️ Setup - Open the Odoo node and connect your Odoo API credentials. - Adjust the fieldsList in the node if you want to include more data fields (e.g., address, city, or VAT). - Trigger the flow from its webhook URL or run it manually inside n8n to test the output. 💡 Notes - Built and tested for n8n v1.108.2+

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

Send instant replies to new Yelp leads with LeadResponder.ai

Automate replies for new Yelp leads. This workflow helps small businesses win clients through immediate engagement the moment they reach out and increasing revenue by 30%. How it works Yelp is monitored every minute for new leads. Once a lead is detected, an automated reply is sent immediately. Setup steps First, sign up at to obtain an API key. Then, enter the key into the workflow settings. Customization Upgrade from static messages to AI-generated personalization. Additionally, you can automa

Free

🛠️ HighLevel tool MCP server 💪 all 17 operations

Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? Join the community Complete MCP server exposing all HighLevel Tool operations to AI agents. Zero configuration needed - all 17 operations pre-built. ⚡ Quick Setup 1. Import this workflow into your n8n instance 2. Activate the workflow to start your MCP server 3. Copy the webhook URL from the MCP trigger node 4. Connect AI agents using the MCP URL 🔧 How it Works • MCP Trigger: S

Free

Automated video download from Sample.cat using Airtop Browser Automation

README Automating Video File Download from Sample.cat with Airtop.ai Use Case Automating file downloads from web pages is useful for scenarios like bulk media retrieval, dataset access, or recurring content backups. This workflow ensures a hands-free, consistent process for retrieving downloadable content. What This Automation Does This automation performs a reliable download of a video file from a specified webpage using the following steps: - Initiates an Airtop browser session. - Opens a spec

Free

Automate email responses for customer support queries

Every time a new email is received, Make will automatically send an automated reply to the sender.

Free

Add TypeScript Intellisense support to code nodes with JSDoc

Are you writing complex Code nodes and need Intellisense support? Follow this simple pattern to get autocomplete for any n8n or custom classes.

Free

Extract Clean Web Content with Anti-Bot Fallback for AI Agents & Workflows

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Clean Web Content Extraction with Anti-Bot Fallback Extract clean and structured text from any webpage with optional fallback to an anti-bot scraping service. Ideal for AI tools and content workflows. 🧠 How it Works This sub-workflow enables reliable and clean scraping of any public webpage by simply passing a url parameter. It is designed to be embedded into other workflows or used as a tool fo

Free

Extract and clean YouTube video transcripts with RapidAPI

Here is your refined template description with detailed step-by-step instructions, markdown formatting, and customization guidance. --- YouTube Transcript Extraction Workflow This n8n workflow extracts and processes transcripts from YouTube videos using the YouTube Transcript API on RapidAPI. It allows users to retrieve subtitles from YouTube videos, clean them up, and return structured transcript data for further processing. Table of Contents - Problem Statement & Target Audience - Pre-con

Free

Post on X using Airtop and automate content pipelines

About The Post to X Automation Seamlessly automate posting to X using Airtop and Make. How to Automate Posting to X with Airtop Consistently engaging your audience on X (formerly Twitter) can be a challenge, particularly when done manually. Developers and automation engineers often struggle with repetitive tasks like scheduling tweets, maintaining consistent posting cycles, and integrating content from various sources or AI-generated feeds. Manually managing content updates increases fatigue, hu

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