Integrate Odoo with 500+ apps and services

Who is this for? This workflow is for everyone who wants to have easier access to their Odoo sales data without complex queries. Use Case To have a clear overview of your sales data in Odoo you typically needs to extract data from it manually to analyse it. This workflow uses OpenAI's language models to create an intelligent chatbot that provides conversational access to your Odoo sales opportunity data. How it works Creates a summary of all Odoo sales opportunities using OpenAI Uses that summary as context for the OpenAI chat model Keeps the summary up to date using a schedule trigger Set up steps: Configure the Odoo credentials Configure OpenAI credentials Toggle "Make Chat Publicly Available" from the Chat Trigger node.

Use Case: This n8n workflow automates the process of extracting information from emails. It uses OpenAI to summarize sales emails and adds this information in Odoo. How it works: When an email is received with a certain label, it sends the email to OpenAI for summarization A sales opportunity is created in Odoo with the email subject as title and the email summary as internal note Set up steps: Configure Google Cloud credentials with Gmail access In the Gmail node, choose an email label in the filter section Configure OpenAI credentials Configure Odoo credentials

Objective This workflow automatically imports product images from Google Drive and associates them with product models and variants in Odoo. Main Features Identifies images stored in a specific Google Drive folder. Filters files to process only .png and .jpg images. Extracts information from file names to associate each image with a product or model in Odoo. Updates image fields in Odoo. Cleans up old images and notifies the completion of the process. Workflow Steps 1. Triggering the Workflow Type**: Schedule Trigger & Manual Trigger Details**: Manually triggered via the "Click Manual" node. Automatically scheduled every 10 minutes via the "Schedule Trigger" node. 2. Finding Files in Google Drive Node**: Find Files Action**: Searches for files in the specified Google Drive folder (input). 3. Filtering Images Node**: Filter Images Action: Only **.png and .jpg images are kept for processing. 4. Decorating File Data Node**: Decorate Images Action**: Extracts information from the file name to retrieve: The model (model). The SKU (sku). 5. Identifying Image Type Node**: Switch Action: Determines whether the image is for a **product model (template) or a product variant (product). 6. Searching for the Product or Model in Odoo Nodes**: Find Templates: Searches for the product model in Odoo. Find Products: Searches for the product variant in Odoo. 7. Downloading and Converting Images Nodes**: Download Images Templates: Downloads images for product models. Download Images Products: Downloads images for product variants. Convert Base64 Images Templates: Converts images to base64 format for Odoo. Convert Base64 Images Products: Converts images to base64 format for Odoo. 8. Updating Images in Odoo Nodes**: Update Images Templates: Updates images for product models. Update Images Products: Updates images for product variants. 9. Cleaning and Finalizing the Process Nodes**: Search Old Images: Searches for old images in the destination folder. Drop Old Images: Deletes outdated images. Move Images: Moves processed images to a done folder on Google Drive. 10. Sending Process Completion Notification Nodes**: Sum Images: Counts the total number of processed images. Announce: Sends a Google Chat notification with the total imported images. Required Configuration 1. Connectors & API Credentials Google Drive API** (OAuth2) with the necessary permissions to access files. Odoo API** with permissions to read and update product models and variants. 2. File Naming Structure Files must be named as follows: <model>_<sku>.<png|jpg> Example: Product Model**: template_12345.jpg Product Variant**: product_67890.png Data Flow Summary A trigger (manual or automatic) initiates the process. The workflow fetches image files from Google Drive. It filters and identifies the images to be processed. It extracts the necessary information (model, SKU). Each image is associated with a product or model in Odoo. Images are downloaded, converted, and updated in Odoo. Old images are deleted, and new ones are moved to the processed folder. A notification is sent upon completion. Use Cases Automating product image imports for Odoo. Updating images without manual intervention. Centralizing images on Google Drive before integrating them into Odoo.