Connect Google Workspace to Odoo: Complete Integration Guide

Why Connect Google Workspace to Odoo?

Most businesses already live in Google Workspace — Gmail for email, Calendar for scheduling, Drive for documents, and Contacts for their address book. Odoo has its own email, calendar, and document systems, but forcing teams to abandon Google tools creates friction. The smarter approach is connecting them so data flows between both systems automatically.

Integration Points

Setup: Gmail Integration

1. Google OAuth Configuration

• Go to Google Cloud Console (console.cloud.google.com)
• Create a project or use existing one
• Enable Gmail API in APIs & Services
• Create OAuth 2.0 credentials (Web application type)
• Add authorized redirect URI: https://yourodoo.com/google_gmail/confirm
• Note the Client ID and Client Secret

2. Odoo Gmail Setup

• Go to Settings → General Settings → Discuss section
• Enable "Gmail Authentication" under Email Servers
• Enter Google Client ID and Client Secret
• Each user connects their own Gmail account via OAuth
• Configure outgoing mail to use Gmail SMTP

Setup: Google Calendar Sync

1. Enable Google Calendar API

• In Google Cloud Console, enable Google Calendar API
• Use the same OAuth credentials or create new ones
• Add authorized redirect URI for calendar: https://yourodoo.com/google_calendar/sync

2. Odoo Calendar Configuration

• Go to Settings → General Settings → Integrations
• Enable "Google Calendar" synchronization
• Enter Client ID and Client Secret
• Each user authorizes calendar access individually
• Events sync bidirectionally — create in either system

3. What Syncs

• Meeting title, description, date, time, and duration
• Attendees (matched by email address)
• Recurrence rules for repeating events
• Meeting location or video call link
• Event modifications and cancellations

Setup: Google Drive Integration

1. Enable Google Drive API

• Enable Drive API in Google Cloud Console
• Configure OAuth credentials with Drive scopes

2. Odoo Drive Configuration

• Enable Google Drive in Odoo settings
• Configure default Drive folder for Odoo attachments
• Link Drive documents to Odoo records (sales orders, projects, contacts)
• Generate Drive documents from Odoo templates

Setup: Google SSO (Single Sign-On)

1. OAuth Provider Configuration

• In Odoo: Settings → General Settings → Integrations → OAuth Authentication
• Enable Google OAuth provider
• Enter Client ID from Google Cloud Console
• Users can sign in with their Google Workspace accounts

2. User Provisioning

• Match Google Workspace email to Odoo user email
• Optionally auto-create Odoo users on first Google login
• Map Google Workspace groups to Odoo access groups

Google Contacts Sync

• Use Google People API to sync contacts bidirectionally
• Match on email address as unique identifier
• Sync name, email, phone, company, and address fields
• Handle contact groups as Odoo tags
• Schedule periodic sync (hourly or daily)

Common Pitfalls

• OAuth consent screen — Configure the consent screen properly. In production, submit for Google verification to remove "unverified app" warnings.
• Scope permissions — Request only needed scopes. Broad permissions trigger additional Google review.
• Token refresh — Google OAuth tokens expire. Ensure your integration handles automatic token refresh.
• Calendar conflicts — Bidirectional sync can create duplicates if both systems modify the same event simultaneously. Establish one system as the primary for conflicts.

Getting Started

Deploy Odoo on DeployMonkey and enable Google Workspace integrations in Settings. Start with Gmail (most immediate productivity gain), then add Calendar and Drive. The configuration requires Google Cloud Console setup but no custom code.