Odoo Google Sheets Connector: Two-Way Sync, Automated
Export & Easy Data Management
Why Connect Odoo to Google Sheets?
Most teams already live in Google Sheets. It's where sales reports get built, inventory gets reviewed, and finance teams do their ad-hoc analysis. But if your business runs on Odoo, getting data from Odoo into a spreadsheet usually means manually exporting a CSV, cleaning it up, and pasting it in. Every time the data changes, you repeat the whole process.
The Odoo Google Sheets Connector by Creyox eliminates this entirely. It creates a direct, authenticated link between your Odoo instance and any Google Sheet, so your team can pull live Odoo data into Sheets with a click and push updates from Sheets back into Odoo just as easily. Set up an automatic refresh schedule and the sync happens in the background without anyone doing anything manually.
Whether your team needs a live sales dashboard, a shared inventory report, or an up-to-date customer list in a format everyone can edit and annotate, this connector gives you that, without replacing either platform or forcing anyone to change how they work.
Overview
The Creyox Odoo to Google Sheets Connector bridges both platforms with a smooth, configurable two-way data flow. You can export Odoo data including sales records, customer information, inventory details, and more directly into Google Sheets for quick analysis and team collaboration. Equally, any updates made inside Google Sheets can be synced back into Odoo, keeping your ERP records accurate without requiring manual re-entry.
Odoo records are mapped to Google Sheets rows and columns automatically, giving your spreadsheet a clean, structured view of your ERP data. You control how often the sync runs: set it to refresh automatically at defined intervals, or trigger it manually whenever you need a fresh pull. Either way, repetitive data entry and slow reporting processes are replaced with a live, always-current data pipeline between your ERP and your spreadsheets.
Every sync operation is logged in Odoo under Data Processing Logs, giving you a transparent record of all data transfers including timestamps, success or failure status, and details of what was synced. These logs make it easy to audit data flows, troubleshoot issues, and demonstrate accountability across your team's reporting processes.
Hot Features
◆ Real-Time Data Sync
◆ Data Transformation Options
◆ Easy-to-Configure Settings
◆ Smart Data Availability Check
◆ Seamless Communication
◆ User-Friendly Notifications
◆ Dynamic Table Selection
◆ Powerful Analytics
◆ Logging and Audit Trail
Features
◆ Real-Time Response Capture.
◆ Effortless Data Transfer.
◆ Continuous Synchronization.
◆ Automatic Mapping.
◆ Two-way sync , enabling seamless data exchange in both directions.
◆ User can see data log with in odoo.
◆
User-Friendly Setup and Configuration.
Work Flow
- Go to the Google Sheet Connector from the main Odoo dashboard.
- Navigate to Configuration from the main menu.
- Click New to create a new connector configuration.
- Click the Generate Token button to create an authentication token.
- Once generated, the authentication token will be displayed in the Access Token field.
- Copy this token and paste it into Google Sheets to establish a secure connection between Odoo and Google Sheets.
- Click on button Generate App Script to generate App Script to connect with Google Sheet.
- Generated App Script is Attached in chatter.
- Copy the Generated App script content.
- Open your Google Sheet and navigate to Extensions >> Apps Script to access the script editor.
- Navigate to Code.gs and paste the previously copied Apps Script code into the editor.
- This script will add the Odoo data import and export menu to your Google Sheet, allowing you to connect and synchronize data with Odoo.
- Now Odoo Connector menu will be visible In Google Sheets, navigate to Odoo Connector >> Set URL and Token.
- Enter the Odoo URL (Connector Url) and the authorization token (Access Token) generated from Configuration menu in Odoo.
- From your Google Sheet, go to Select Tables and Fetch Data to retrieve data from Odoo.
- Choose the required table to fetch data from Odoo and click Next: Select Columns.
- The data for each selected table will be imported into a separate sheet within the Google Sheet.
- Select the specific fields from which you want to fetch data, then click the Fetch Data button.
- This allows only the selected columns to be imported, ensuring that only relevant and important data is fetched into the Google Sheet.
- Once the process is complete, the imported data will appear in the Google Sheet.
- To export data from Google Sheets to Odoo, Navigate to Google Sheet >> Send data to odoo.
- Select the sheet containing the data you want to export to Odoo, then click Next: Select Columns.
- Select The Specific Fields of which you want to export the data >> click on button Export Data
- If a record already exists in Odoo with the same ID, the system will update the existing record with the new values.
- If no record exists in Odoo with the same ID, a new record will be created automatically.
- Even if the ID field is not selected during column selection, the system will still use the ID internally to identify records.
- The Exported Data Can Be found in Odoo.
- Navigate to Google Sheet >> Setup Automatic Import Refresh.
- Select Tables and Enter the Hours for each table in which You want to Automatically fetch data from Odoo to Sheets.
- The sheet data will be refreshed automatically based on the selected time interval.
- Navigate to Google Sheet >> Setup Automatic Export Refresh.
- Select Tables and Enter the Hours for each table in which You want to Automatically export data from Sheets to Odoo.
- The sheet data will be exported automatically based on the selected time interval.
- Navigate to Google Sheet >> Refresh Now.
- Select specific tables and click on Refresh Selected to fetch records of selected tables from odoo to sheets.
- In Odoo Navigate to Odoo To Sheets >> Data Processing Logs .
- This section displays transaction logs for data synchronization between Odoo and Google Sheets.
- It shows how many records were successfully imported or exported, how many failed, along with analytical reasons for any failures.
