Import Odoo Product Images from Google Drive

Import Odoo Product Images from Google Drive automates the retrieval and updating of product images, enhancing efficiency by filtering and processing images every 10 minutes. It seamlessly integrates with Google Drive and Odoo, ensuring that product visuals are up-to-date and properly managed, ultimately improving product presentation and inventory accuracy.

7/8/2025
19 nodes
Complex
schedulecomplexfiltergoogle driveschedule triggersummarizegooglechatodooextractfromfileautomationadvancedlogicroutingcronfilesstorage
Categories:
Schedule TriggeredComplex Workflow
Integrations:
FilterGoogle DriveSchedule TriggerSummarizeGoogleChatOdooExtractFromFile

Target Audience

This workflow is ideal for:
- E-commerce Managers: Who need to regularly update product images in Odoo from Google Drive.
- Marketing Teams: Looking to automate the process of managing product visuals to enhance online presence.
- IT Professionals: Responsible for integrating different systems and ensuring seamless data flow between Google Drive and Odoo.
- Small Business Owners: Who want to streamline their operations and save time on manual image uploads.

Problem Solved

This workflow addresses the challenge of manually updating product images in Odoo from Google Drive. By automating the process, it:
- Reduces time spent on repetitive tasks, allowing teams to focus on strategic activities.
- Minimizes human errors associated with manual uploads.
- Ensures that the latest product images are always available in the system, enhancing customer engagement and satisfaction.

Workflow Steps

  • Schedule Trigger: The workflow initiates every 10 minutes to check for new images in Google Drive.
    2. Find Files: It searches for image files within a specified folder in Google Drive.
    3. Filter Images: The workflow filters the files to only include images with extensions .png or .jpg.
    4. Decorate Images: Each image's name is parsed to extract relevant information such as model and SKU.
    5. Switch Node: Depending on the model type (either template or product), the workflow routes to the appropriate processing path.
    6. Find Templates/Products: It queries Odoo to find corresponding templates or products based on the extracted SKU.
    7. Download Images: The images are downloaded from Google Drive for both templates and products.
    8. Convert Base64: The downloaded images are converted from binary to a proper format for Odoo.
    9. Update Images: The workflow updates the respective images in Odoo for both templates and products.
    10. Move Images: Successfully processed images are moved to a designated 'done' folder in Google Drive.
    11. Summarize and Announce: Finally, a summary of the total images processed is sent via Google Chat to notify the team.

    • Customization Guide

    Users can customize this workflow by:
    - Adjusting the Schedule: Modify the interval in the Schedule Trigger to meet specific needs (e.g., every 5 minutes instead of 10).
    - Changing Folder Paths: Update the folder IDs in the Find Files node to point to different directories in Google Drive.
    - Extending Filters: Add more image formats in the Filter Images node to include other types of files.
    - Modifying Update Fields: Customize which image fields in Odoo are updated by altering the fields in the Update Images nodes.
    - Integrating Additional Notifications: Enhance the workflow by adding more notification channels or custom messages in the Announce node.