Import Odoo Product Images from Google Drive
This workflow enables the automatic import of product images from Google Drive into the Odoo system. It regularly scans a specified folder, filters and downloads images, converts them into the format required by Odoo, and updates the corresponding product records. After processing is complete, it automatically archives the processed images and sends notifications, ensuring transparency and timeliness of information. This improves image management efficiency and reduces the burden of manual operations, making it suitable for e-commerce, retail, and manufacturing industry enterprises.
Workflow Name
Import Odoo Product Images from Google Drive
Key Features and Highlights
This workflow automates the import of product images from Google Drive into the Odoo system. It periodically scans a specified Google Drive folder for image files, intelligently filters and distinguishes between product template images and specific product images, automatically downloads and converts them into the format required by Odoo, and updates the corresponding product records to complete the entire image synchronization process. Upon completion, the workflow also automatically moves the processed images and sends notifications via Google Chat to ensure transparency and timely information sharing.
Core Problems Addressed
- Manual uploading and management of product images is time-consuming and error-prone;
- Efficient synchronization of images between Google Drive and Odoo system is required;
- Complex association between image formats and product SKUs makes automation difficult;
- Processed images need to be archived to avoid duplicate handling.
Application Scenarios
Suitable for enterprises in e-commerce, retail, or manufacturing industries that use Odoo as their product management system and store product images on Google Drive. It is especially beneficial for e-commerce operations teams, inventory managers, and digital transformation projects that require frequent bulk updates of product images to enhance data synchronization efficiency.
Main Process Steps
- Trigger Mechanism: Initiate the workflow via scheduled intervals (every 10 minutes) or manual trigger.
- File Retrieval: Search all files within the specified Google Drive folder.
- Image Filtering: Filter files ending with .png or .jpg extensions.
- Image Data Decoration: Parse filenames to extract model type (template or product) and SKU number.
- Branch Processing:
- For template images, query Odoo product template data;
- For specific product images, query Odoo product data.
- Image Download: Download the corresponding image files from Google Drive.
- Image Conversion: Convert image binary data to Base64 format compatible with Odoo API.
- Odoo Update: Update the image data into the corresponding product template or product records in Odoo.
- Historical Image Management: Identify and delete previously processed old images in Google Drive to avoid redundancy.
- Image Archiving: Move processed images to the “done” folder for archival.
- Notification: Send a summary notification of the completed process via Google Chat.
Involved Systems or Services
- Google Drive: File storage, search, download, move, and delete operations;
- Odoo ERP: Product template and product data querying and image updating;
- Google Chat: Workflow completion notification delivery;
- n8n: Workflow automation platform for task orchestration and execution.
Target Users and Value
- Odoo system administrators and maintenance personnel;
- Product operations and content management teams;
- E-commerce platform and supply chain management staff;
- Enterprise users requiring automated product image synchronization and management.
This workflow significantly enhances the automation and accuracy of product image management, reduces manual operations, lowers error rates, and ensures product information and visual content remain up-to-date, thereby boosting enterprise digital operation efficiency.