Automatically Track Odoo Products in Google Sheets 📦
Adam Browder
September 11, 2025
When your team adds a new product in Odoo, the data often needs to reach more than one place. Marketing might pull it into a pricing catalog, finance may load it into reports, and operations could sync it into a BI dashboard. Many teams use Google Sheets as the central hub for this, but copying product details by hand slows everything down. With Workload, you can automatically track Odoo Products in Google Sheets the moment they’re created.
Each product record in Odoo moves directly into a new row in your spreadsheet. The automation includes the product name, price, category, and quantity. Even complex fields, such as category IDs hidden inside arrays, are formatted cleanly so every value drops into the right column.
Once the product data is in Google Sheets, it’s easy to connect it to other systems. Reports stay accurate, exports update in real time, and every team works with the same current information. You save hours of manual work and cut down on errors while keeping your data ready for whatever comes next.
🧩 Essentials
Before you build, here are the accounts you’ll need:
⭐ Odoo – Your ERP system where new products are created and managed.
✅ Google Sheets – Stores product details in rows for reporting or syncing to other tools.
🚀 Workload account (free or paid) – Create your automation without writing code.
Workload makes connecting these tools seamless. Just sign in and grant access when prompted—no developer setup or configuration needed.
🎨 Make It Yours
You can customize this automation to fit the way your team manages product data:
📦 Filter by Product Type
Only send physical goods into Google Sheets while skipping services or internal records.
🧹 Clean Categories with Workload’s AI Wizard
Split or rename category fields so your columns stay accurate and consistent.
📢 Branch by Department
Log products into Sheets for finance while also sending Slack alerts to sales when new items appear.
🔖 Add Extra Fields
Map SKUs, supplier info, or notes into extra columns to create a richer product database.
⚙️ How to Automatically Track Odoo Products in Google Sheets
Every app expects data in a specific format—whether it’s how dates are written, how names are separated, or how fields are labeled. You can use our in-house tool AI Wizard by Workload to clean up or adjust data between steps. If your trigger already sends clean data, you may not need formatting at all.
Step 1: Create a New Track Odoo Products in Google Sheets Automation
Open the Workload Dashboard and click Create Workflow.
Give your automation a title, such as New Odoo Products to Google Sheets.
Step 2: Set Up the Odoo Trigger
Click inside the Trigger box and select Odoo ERP Self Hosted.
Choose the event New Product, then click Continue.
Click Sign in to connect your Odoo account if you haven’t already. For help, follow our step-by-step guide on how to connect Odoo to Workload. Once connected, click Continue.
Select the Odoo database you want to monitor, then click Continue.
Test the trigger to pull in sample product data and once you have a successful response, click Continue.
Step 3: Format Category Data with AI Formatter
Click into the action step and click on the TOOLS menu. Next, choose AI Wizard by Workload (fka AI Formatter).
Select the event Format Data, then click Continue.
In the Input Data field, choose Category ID (categ_id:) from the trigger step.
Paste the prompt “Turn this array into an object” into the box, then click Continue.
Test the action to confirm the category is split into clean fields, then click Continue.
Step 4: Add the Google Sheets Action
Click the plus sign (+) to add another action step.
Next, select the Google Sheets app.
Choose the event Create Spreadsheet Row, then click Continue.
Click Sign in to connect your Google Sheets account if you haven’t already. For help, follow our step-by-step guide on how to connect Google Sheets to Workload. Once connected, click Continue.
Select the spreadsheet you want to update, then choose the worksheet tab.
Use the + Add To button to start mapping data to your Google Sheet. The column names match your spreadsheet. Use dynamic values pulled from the previous steps or input your own static choices. Click + Add To for more columns, then hit Continue when done. Here are the fields we used:
- Name – Product name (from Odoo trigger)
- Price – List price (from Odoo trigger)
- Category – Formatted category (from AI Formatter step)
- Quantity – Quantity available (from Odoo trigger)
Test the action to confirm the row is created in your Sheet. Once you have a successful response, click Continue.
Step 5: Test and Activate to Track Odoo Products in Google Sheets
Open your Google Sheet to confirm the new product row appears.
In the Workload Editor, check that each step shows a green dot, then activate the automation.
⚡ Making Odoo Products in Google Sheets Part of a Complete Product System
Once you’re automatically logging Odoo products into Google Sheets, you can expand the automation into a more powerful system:
🔔 Send Alerts for New Products
Post a Slack or Teams message whenever a new product appears so your team can act right away.
📊 Build Real-Time Dashboards
Connect Sheets to Looker Studio or another BI tool to track product performance and inventory trends.
🛒 Sync to eCommerce Platforms
Push new products from Sheets into Shopify or WooCommerce to keep your storefronts updated.
🗂️ Create a Central Product Database
Combine product data with suppliers, pricing, or categories in Sheets to serve as a master record for other automations.
🧠 Learn More with Workload
Keep exploring automation and save more time:
🎓 Visit Workload University for more video tutorials on building automations.
🆘 Browse the Help Center for setup guides and troubleshooting tips.
🔄 Explore more Odoo automation tutorials to see how else you can streamline your workflows.
🌐 Check out Google Sheets automations to expand your product tracking and reporting.
🎥 See It in Action
Tags
Ready to automate your workflows?
Start building powerful automations with Workload today.
Get Started Free