Automate Odoo Product Image Import from Google Drive
detail.loadingPreview
Streamline your Odoo product management by automatically importing images from Google Drive. This workflow ensures your product catalog is always up-to-date with the latest visuals, saving you manual effort and time.
About This Workflow
This powerful n8n workflow automates the tedious process of uploading product images to Odoo. It intelligently scans a designated Google Drive folder for new or updated image files (PNG and JPG). Each image is then processed, extracting product model and SKU information from its filename (e.g., 'MODEL_SKU.png'). The workflow smartly routes images based on their model, distinguishing between product templates and other uses. Finally, processed images are moved to a 'done' folder in Google Drive, and a notification is sent upon completion, ensuring a seamless and efficient image management pipeline for your Odoo store.
Key Features
- Automated Image Fetching: Automatically pulls image files from a specified Google Drive folder.
- Intelligent File Filtering: Supports both PNG and JPG image formats.
- Smart Filename Parsing: Extracts product model and SKU from image filenames for accurate association.
- Conditional Routing: Directs images based on their identified model, streamlining Odoo product template management.
- Completion Notifications: Alerts you via Google Chat once the import process is complete.
How To Use
- Connect Google Drive: Authenticate n8n with your Google Drive account using OAuth2.
- Configure Folder Access: Specify the Google Drive folder containing your product images in the 'Find Files' node.
- Define Image Types: The 'Filter Images' node is pre-configured to accept
.pngand.jpgfiles. Adjust if you use other formats. - Set Filename Convention: Ensure your image filenames follow a
MODEL_SKU.extension(e.g.,Tshirt_RED001.png) convention for correct parsing. - Odoo Integration: Configure your Odoo connection details in the 'Find Templates' node to link images to existing product templates using the
default_code(SKU). - Set Automation Schedule: The 'Schedule Trigger' node is set to run every 10 minutes. Adjust this interval as needed.
- Configure Google Chat Notification: Set up your Google Chat webhook and space ID in the 'Announce' node to receive completion alerts.
Apps Used
Workflow JSON
{
"id": "e809356c-28a5-4927-b879-f02664abd9c8",
"name": "Automate Odoo Product Image Import from Google Drive",
"nodes": 7,
"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: e809356c-28a5...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
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.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.