Automated Odoo Product Image Import From Google Drive
detail.loadingPreview
Streamline your e-commerce operations by automating the import of product images into Odoo directly from Google Drive. This workflow regularly scans your designated Google Drive folder, intelligently categorizes images based on filenames, and uploads them to the correct Odoo product templates or variants, all while keeping your Drive organized.
About This Workflow
This n8n workflow offers a powerful solution for businesses managing extensive product catalogs in Odoo and storing their product imagery in Google Drive. It eliminates the tedious, manual process of uploading images, saving significant time and reducing potential errors. Operating on a user-defined schedule (e.g., every 10 minutes), the workflow efficiently identifies new image files (JPG, PNG), automatically extracts product or template SKUs and types from their filenames, and then intelligently routes them to the corresponding product.template or product.product records in Odoo for seamless attachment. Upon successful processing, the original image files are neatly moved to a 'done' folder in Google Drive, and a summary notification is dispatched to Google Chat, ensuring a fully automated, transparent, and efficient image management pipeline from cloud storage to ERP.
Key Features
- Automated Image Discovery: Scheduled scanning of a designated Google Drive folder for new
.pngand.jpgproduct images. - Intelligent Filename Parsing: Automatically extracts product model (
templateorproduct) and SKU from image filenames (e.g.,template_SKU.png,product_SKU_Variant.jpg). - Seamless Odoo Integration: Connects directly with Odoo to find the correct
product.templateorproduct.productrecord and upload the image. - Automated File Organization: Moves processed images from the input folder to a 'done' folder in Google Drive, maintaining a tidy storage.
- Real-time Notifications: Sends Google Chat alerts with a summary of successfully imported images after each run.
- Configurable Scheduling: Easily adjust how often the workflow checks for new images.
How To Use
- Configure Schedule Trigger: Set the desired frequency for the workflow to check for new images (e.g., every 10 minutes).
- Set Up Google Drive Nodes: Connect your Google Drive account to n8n. In the
Find Filesnode, specify the 'input' folder where raw product images will be placed. In theMove Imagesnode, specify a 'done' folder for processed images. - Configure Odoo Nodes: Connect your Odoo instance. Ensure your Odoo products/templates have
default_codefields that correspond to the SKUs extracted from your image filenames. Review and configure theFind Templates,Find Products, andUpload Imagesnodes for correct resource and operation settings. - Adjust Filename Parsing (Code Node): If your image filename naming convention differs from
model_SKU.extension(e.g.,template_P123.pngorproduct_P123_RED.jpg), modify the JavaScript code in theDecorate Imagesnode to accurately parse yourmodelandskuinformation. - Configure Google Chat Node: Connect your Google Chat account and provide the space ID where you wish to receive notifications about completed image imports.
Apps Used
Workflow JSON
{
"id": "03451297-0717-4997-b9c4-3eff32de1871",
"name": "Automated Odoo Product Image Import From Google Drive",
"nodes": 26,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 03451297-0717...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Automate Getty Images Editorial Search & CMS Integration
This n8n workflow automates searching for editorial images on Getty Images, extracts key details and embed codes, and prepares them for seamless integration into your Content Management System (CMS), streamlining your content creation process.
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.