Import Odoo Product Images from Google Drive

Who is this for?

This workflow is designed for businesses and developers who want to automatically sync product images from Google Drive to Odoo without manual intervention.

Use Case

Managing product images in Odoo often requires manual uploads and updates. This workflow automates the process by detecting images in a specific Google Drive folder, matching them with corresponding product records in Odoo, and updating the product images accordingly. It ensures that Odoo’s product catalog always has the latest images without manual work.

How it works

• Find Files: Scans a designated Google Drive folder for images.
• Filter Images: Identifies files that are either .jpg or .png.
• Validate Naming Convention: Ensures that images follow the required naming format:
  • template_{sku}.png or template_{sku}.jpg for product templates.
  • product_{sku}.png or product_{sku}.jpg for individual products.
• Extract Metadata: Parses the file name to retrieve model and SKU information.
• Match with Odoo: Searches for corresponding product templates or product records in Odoo based on SKU.
• Download Images: Retrieves images from Google Drive.
• Convert to Base64: Encodes images for Odoo compatibility.
• Update Odoo: Updates product images across multiple resolutions in Odoo.
• Cleanup: Moves processed images to a "done" folder or deletes them.
• Announce Completion: Sends a notification via Google Chat with the summary of updated images.
• Scheduled Execution: Runs automatically every 30 minutes or can be triggered manually.

Set up steps

1. Ensure images are correctly named following the format:
   • template_{sku}.png or template_{sku}.jpg (for product templates).
   • product_{sku}.png or product_{sku}.jpg (for individual products).
2. Configure Google Drive credentials in n8n.
3. Configure Odoo credentials with API access.
4. Set the correct folder IDs for input and processed images.
5. Enable the scheduler to automate the process at regular intervals.
6. Test manually before deployment.