Google Sheets Connector Odoo 18 & Excel Pro

$ 180.00

v 18.0 Third Party

Availability	Odoo Online Odoo.sh On Premise
Odoo Apps Dependencies	Discuss (mail)
Lines of code	3540
Technical Name	`gs_odoo_connector`
License	LGPL-3
Website	http://github.com/ayyan420

You bought this module and need support? Click here!

Availability	Odoo Online Odoo.sh On Premise
Odoo Apps Dependencies	Discuss (mail)
Lines of code	3540
Technical Name	`gs_odoo_connector`
License	LGPL-3
Website	http://github.com/ayyan420

Google Sheets & Excel Connector Pro

The most complete bidirectional sync integration for Odoo 18. Real-time push, delta sync, visual query builder, 6 financial Excel templates, and the powerful IMPORTODOO() formula — all in one module.

⚡ Real-time Push 🔄 Bidirectional Sync Delta Sync 10-50x 6 Financial Templates IMPORTODOO() 7 REST API Endpoints LGPL-3 Licensed

14+

Features

3,165

Lines of Code

HTTP Endpoints

Excel Templates

$180

Lifetime License

Purchase & Direct Support — Contact Ayyan Saddiqui

WhatsApp: +92 316 4705102 | Call: 0316 4705102

Email: ayyansaddiqui420@gmail.com

Documentation & Resources

Features Reference PDF Complete feature deep-dives, comparison table & technical specs drive.google.com/file/d/1qNMImTZ28JfZiUZKksxapXY3Zo9rvf0u/view?usp=sharing	Setup & User Guide PDF Step-by-step installation, Google Cloud setup & full configuration drive.google.com/file/d/1VYXUED5c2AElcs1JJPyzSy8boe3v0xMi/view?usp=sharing
Developer Portfolio More Odoo modules & open-source work by Ayyan Saddiqui github.com/ayyan420

Lifetime License

$180

Unlimited Users | One-time Payment | No Recurring Fees

✓ Certified for Odoo 18.0 (also)	✓ 365 Days Priority Support
✓ Lifetime Updates Included	✓ LGPL-3 Open-Source Friendly
✓ Full Source Code Access	✓ 14+ Features, 3,165 Lines of Code
✓ 6 Pre-built Excel Financial Templates	✓ 7 REST HTTP API Endpoints

To purchase: Email ayyansaddiqui420@gmail.com or WhatsApp +92 316 4705102

14 Production-Grade Features

Every feature built for real business workflows — not demos.

FEATURE 01

Delta / Incremental Sync PERFORMANCE

10-50x faster than full sync for large datasets. Only pushes records whose write_date changed since last run. Eliminates rate-limit errors on large datasets.

Tracks last_delta_sync timestamp per connector
Orders of magnitude fewer API calls — no rate-limit errors
Compatible with the auto-refresh scheduler
Newly created rows appended; updated rows found by _odoo_id column
Works with Google Sheets Apps Script delta mode

FEATURE 02

Visual Query Builder NO-CODE

Filter records without writing a single line of code. Non-technical users can build domain filters using a point-and-click interface. No JSON arrays, no Python syntax.

AND / OR combinator for rule sets
Full dropdown of model fields with friendly labels
Operator choices adapt to field type: text / number / date / boolean
Live record count preview updates as rules are added
Saves generated domain back to the connector automatically

FEATURE 03

Data Transformation Layer DATA QUALITY

13 transform types — clean data without post-processing. Transforms run in sequence, chained so output of one feeds the next.

Value Map: draft to Quotation, sale to Confirmed
Round Number, Date Format, Prefix/Suffix, UPPER/lower/Title Case
Find & Replace, Default if Empty, Multiply by Factor
Currency Format: 1500 becomes $1,500.00

FEATURE 04

Data Validation Dropdowns DATA INTEGRITY

Selection field values auto-populate as Google Sheets dropdown menus, preventing write-back errors from typos or invalid values.

Reads selection values from ir.model.fields at sync time
Applied to the correct column range automatically
Works for any selection field on any Odoo model
Pairs perfectly with the Approval Workflow feature

FEATURE 05

Pivot-Table Ready Output EXCEL POWER USERS

Correct Python types exported — no #VALUE errors in Excel pivot tables. Forces all columns to use correct native types.

Integers exported as actual numbers, not "42" as text
Monetary fields as Python floats with proper precision
Dates as ISO strings that Excel recognises natively
Booleans as True/False — not "True" strings

FEATURE 06

Pre-built Financial Excel Templates FINANCE TEAMS

6 one-click reports with branded formatting, auto-filters, frozen headers, and colour-coded data. No configuration required.

Invoice Aging: 0-30 / 31-60 / 61-90 / 90+ day buckets, colour-coded
Budget vs Actuals: variance with % column and red/green highlights
Sales Pipeline: all orders by status with colour-coded rows
Inventory Reorder: items below reorder point highlighted red
Payroll Summary: basic / allowances / deductions / net per employee
Cash Flow Snapshot: customer inflows vs vendor outflows

FEATURE 07

Scheduled Email Reports AUTOMATION

Auto-send .xlsx snapshots on any schedule. Perfect for weekly sales summaries, monthly P&L snapshots, or daily inventory alerts.

Frequencies: daily, weekly (Mondays), monthly (1st), quarterly
Configurable send hour (0-23)
Recipients: Odoo partners or comma-separated raw email addresses
Dynamic subjects: {report_name}, {date}, {company} placeholders
Manual Send Now button for testing

FEATURE 08

Approval Workflow from Sheets WORKFLOW

Change a cell, trigger an Odoo server action. Managers can approve, confirm, or cancel records directly from Sheets — without logging into Odoo.

Works with any selection field on any model
Map any selection value to any Odoo Server Action
Example: Status "sale" fires "Confirm Sale Order"
Logs every approval trigger in the Processing Logs

FEATURE 09

IMPORTODOO() Live Formula LIVE DATA

A custom Google Sheets function — like VLOOKUP but fetches data directly from Odoo. Build live KPI dashboards that auto-update from Odoo.

=IMPORTODOO("sale.order", "amount_total", 42)
                    =IMPORTODOO("sale.order", "amount_total", 0, "[['state','=','sale']]", "sum")
                    =IMPORTODOO("account.move", "amount_residual", 0, "[['payment_state','=','not_paid']]", "sum")

Aggregate modes: value, sum, avg, count, min, max
Works on any model the connector token has access to
Part of the auto-generated Apps Script — no extra setup needed

FEATURE 10

Multi-model JOIN Sync POWER USERS

Merge two related Odoo models into one flat sheet — like a SQL LEFT JOIN. Eliminates VLOOKUP formulas to merge customer data into orders.

Configure a Join Model and Join Field
Join fields are always read-only — never written back
Example: sale.order + res.partner joined on partner_id

FEATURE 11

Multi-currency Support INTERNATIONAL

Original + base currency + exchange rate appended in every row. Three extra columns give international teams full currency visibility.

Three columns appended: _currency, _amount_base, _exchange_rate
Compatible with full, delta, and real-time push sync modes
Works on any model with a Many2one to res.currency

FEATURE 12

Conflict Detection DATA SAFETY

No silent overwrites. Compares sheet timestamp against current Odoo record on write-back. Three conflict strategies available.

Flag (recommended): conflicted rows turn orange with a note
Odoo Wins: Sheet changes ignored if Odoo record was modified
Sheet Wins: Sheet data overwrites Odoo regardless

FEATURE 13

Full Audit Trail COMPLIANCE

Every sync action logged with user, timestamp, and record count. Every operation is recorded in Processing Logs with full context.

Log types: info, fetch, write-back, push, error, warning
Searchable and filterable by connector / type / user / date
Auto-cleanup cron removes logs older than 90 days

FEATURE 14

Batch Import with Validation DATA IMPORT

Two-step wizard: validate all rows first with colour-coded preview, then commit only after confirmation. Rollback on error.

Step 1 — Validate: checks required fields, types, selection values
Colour-coded preview: green = valid, red = error with message
Step 2 — Commit: writes all valid rows in a single transaction
New records get Odoo ID written back into _odoo_id column

Complete Setup Guide

From zero to a live syncing connector in under 30 minutes.

1	System Requirements Compatible with Odoo 18. Install Python packages on your Odoo server: `pip install gspread google-auth google-auth-oauthlib openpyxl`

2	Create a Google Cloud Project Go to console.cloud.google.com and sign in Click the project dropdown, select New Project, name it and click Create Select the new project from the dropdown

3	Enable Required Google APIs APIs & Services, then Library Search for Google Sheets API, click Enable Search for Google Drive API, click Enable Both APIs are required. The connector will fail silently if either is disabled.

Create Service Account & Download JSON Key

APIs & Services, then Credentials, then + Create Credentials, then Service Account
Name it (e.g. odoo-sheets-connector), Create and Continue
Grant role: Editor, Continue, Done
Open the service account, Keys, Add Key, Create new key, JSON — file downloads automatically

Keep this JSON file secure like a password. Do not commit it to version control.

5	Share Your Google Sheet with the Service Account Open the JSON file, find the client_email field. Then: Open your Google Sheet, click Share (top right) Paste the client_email into the share field Set permission to Editor, click Send

6	Install the Module in Odoo Copy gs_odoo_connector_v2/ into your custom addons directory: `python3 odoo-bin -d YOUR_DATABASE_NAME -i gs_odoo_connector_v2 --stop-after-init` Or via Odoo UI: Apps, then Update Apps List, search "Google Sheets Connector Pro", Install.

Create Your First Connector

Navigate to Google Sheets, then Sheet Connectors, then New.

Field	What to Enter
Connector Name	e.g. Sales Orders Sync
Google Sheet URL	Paste the full URL from your browser
Odoo Model	e.g. Sale Order, Contact, Invoice
Max Records	Limit rows per sync (default: 500)

On the Authentication tab, upload your .json file and click Test Connection. A green banner means success!

Install Apps Script for Write-back & IMPORTODOO()

In the connector form, Authentication tab, API Token, click Generate Token
Click Download Apps Script — a .gs file downloads
Open your Google Sheet, Extensions, Apps Script
Replace the default Code.gs content with the downloaded script, press Ctrl+S
Refresh the Sheet — an Odoo Integration menu appears in the toolbar
Click Odoo Integration, Test connection, then Advanced, Go to project (unsafe), Allow

The "unverified app" warning is normal for all custom Apps Scripts. It is safe — you control this script. The warning will not appear again once authorized.

Visual Query Builder

Click the Query Builder button in the connector form header
Select AND (match all rules) or OR (match any rule)
Click Add a line, pick a Field, choose an Operator, enter a Value
Live record count shows matching records at the bottom
Click Apply Filter to Connector — domain is saved automatically

Troubleshooting

gspread not installed: Run pip install gspread google-auth google-auth-oauthlib then restart Odoo.

Cannot open spreadsheet: Verify Sheet URL is complete. Service account email must be added as Editor. Both Google APIs must be enabled.

Orange rows after write-back: Record was modified in Odoo after last fetch. Fetch again, make changes, then send again.

IMPORTODOO() returns #ERROR: Check the API Token in the script. Test with: =IMPORTODOO("res.users","name",1)

Competitive Comparison

Side-by-side against the most popular alternatives on the Odoo App Store.

Capability	echoBitz ($245)	CData ($$$)	Pro Connector ($180)
Bidirectional sync	Yes	Yes	Yes — Full
True real-time push (ORM hooks)	No	Yes	Yes — Built-in
Delta / incremental sync	No	No	Yes — 10-50x Faster
Visual query builder (no JSON)	No	No	Yes — Point-and-Click
Data transformation layer (13 rules)	No	Partial	Yes — Advanced
Data validation dropdowns	No	No	Yes
Pre-built Excel financial templates	No	No	Yes — 6 Included
Scheduled email .xlsx reports	No	No	Yes — Automatic
IMPORTODOO() live formula	No	No	Yes — Live Dashboards
Conflict detection on write-back	No	Partial	Yes — 3-Strategy
Full audit log	Partial	No	Yes — Full
Role-based access control	No	No	Yes
Price	$245	$$$+	$180 Lifetime

Technical Specifications

Odoo Version	18.0 (also tested)
Lines of Code	3,165 across 15 Python files + 15 XML files
HTTP Endpoints	/gs/ping, /gs/fetch, /gs/writeback, /gs/cell_value, /gs/fields, /gs/form_submit, /gs/selection_values
Python Dependencies	gspread >= 6.0, google-auth >= 2.0, google-auth-oauthlib >= 1.0, openpyxl >= 3.1
Authentication	Google Service Account JSON (server-side, no expiry) + API Token (Apps Script)
Google APIs Required	Google Sheets API + Google Drive API
Cron Jobs	Auto-refresh (every 15 min), Email reports (hourly), Log cleanup (daily)
Security Groups	Google Sheets: User (read + sync), Google Sheets: Manager (full access)
License	LGPL-3 (Odoo Proprietary License)

Row Colour Coding After Write-back

Colour	Meaning
Light Green	Row successfully created or updated in Odoo
Light Red	Error — check the last column for the error message
Light Orange	Conflict — record was modified in Odoo since last fetch
White	Row not yet synced to Odoo

Screenshot Gallery — 25 Real Module Screenshots

Real screenshots from the production module. No mockups.

#01 Professional Dashboard	#02 Dynamic Metadata Map
#03 Visual Query Builder	#04 Field Mapping Interface
#05 Real-time Audit Logs	#06 Managed Financial Templates
#07 Email Report Engine	#08 Sync Settings Panel
#09 IMPORTODOO() Live Cell	#10 Connector Form View
#11 Full Audit Visibility	#12 Batch Import Wizard
#13 Transform Chaining	#14 Data Validation Dropdowns
#15 Multi-currency Config	#16 Conflict Detection
#17 Schedule Configuration	#18 Approval Flow UI
#19 Write-back Preview	#20 Multi-model JOIN Config
#21 Delta Incremental Logic	#22 Apps Script Odoo Menu
#23 Live KPI Dashboard	#24 Role-based Access Control
#25 Data Integrity Check

Ready to connect Odoo to Google Sheets?

Get started for $180 — Lifetime License

Unlimited Users | One-time Payment | 365 Days Support | Odoo 18

+92 316 4705102

ayyansaddiqui420@gmail.com

2026 Ayyan Saddiqui | LGPL-3 License | github.com/ayyan420

Please log in to comment on this module

The author can leave a single reply to each comment.
This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
If you want to start a discussion with the author or have a question related to your purchase, please use the support page.