Google Calendar sychronization

Estimated reading: 3 minutes 226 views

Odoo Calendar can be synchronised two ways with Google Calendar, so meetings created in either system appear in both. Setting this up starts in the Google Cloud console before finishing the connection in Odoo.

How to set up a Google API project

  1. Go to the Google API Console and log in.
  2. Click Select a project, then New Project, name it (for example Odoo Sync) and click Create.

How to enable the Google Calendar API

  1. Go to APIs & Services > Enabled APIs and services.
  2. Search for Google Calendar API and click Enable.

How to configure the OAuth consent screen

  1. Go to OAuth consent screen and click Get started.
  2. Set User Type to External (required for personal Gmail accounts).
  3. Enter an App name (for example Odoo) and a User support email, then continue through Audience and Contact Information, agree to the terms, and click Create.

Under Branding > Authorized domains, add your domain, for example odoo.com. While the app is in testing mode, add each Gmail account that needs to sync under Audience > Test users.

How to create credentials

  1. Go to Credentials > Create Credentials > OAuth client ID.
  2. Set Application Type to Web Application and give it a name, such as My Odoo Database.
  3. Under Authorized JavaScript origins, add your Odoo database’s full URL.
  4. Under Authorized redirect URIs, add your Odoo URL followed by /google_account/authentication, then click Create.

Save the Client ID and Client Secret shown, as the secret cannot be viewed again later.

How to set up Google Calendar in Odoo

  1. Go to Settings > Calendar and tick Google Calendar.
  2. Paste the Client ID and Client Secret into their fields and click Save.

How to sync your calendar

  1. Open the Calendar app in Odoo and click the Google sync button.
  2. Log in to the Google account to sync, then click Continue to accept the unverified app warning if it appears, and again to grant permission.

Before you sync

Test the sync on a test database and test Gmail account first. Once synced, creating, deleting, or adding or removing a contact from an event in Odoo causes Google to send an invitation or cancellation to attendees; choosing Don’t Send when prompted in Google Calendar avoids sending a notification for events created there. Make sure the web.base.url system parameter in Odoo matches the domain used in the Google redirect URI.

How to troubleshoot the sync

  1. Go to Settings > Manage Users, select the user, and open the Calendar tab.
  2. Click Reset Account under the Google calendar.

Choose how to handle existing events (leave them, delete from Google, delete from Odoo, or delete from both) and whether the next sync covers only new events or all existing events, then click Confirm.

Frequently asked questions

Why do I need test users in Google Cloud?

While the OAuth consent screen is in testing mode, only users added as test users can sync a personal Gmail account; without them, syncing fails with an access denied error.

What happens if I choose Desktop App instead of Web Application for the credentials?

Google will show a redirect URI mismatch error; delete the credentials and recreate them with Web Application selected instead.

Need help?

Need help setting up Google Calendar sync in Odoo? Contact support@thoughtlogik.com or see our Odoo implementation services.

Leave a Reply

Your email address will not be published. Required fields are marked *

Learn how we helped 100 top brands gain success

Subscribe

×
Cancel