Synchronize Google calendar with SotaERP

Synchronize Google Calendar with SotaERP to see and manage meetings from both platforms (updates go in both directions). This integration helps organize schedules, so a meeting is never missed.

See also

Setup in Google

Select (or create) a project

Create a new Google API project and enable the Google Calendar API. First, go to the Google API Console and log into the Google account.

Note

If this is the first time visiting this page, Google will prompt the user to enter a country and agree to the Terms of Service. Select a country from the drop-down list and agree to the ToS.

Next, click Select a project and select (or create) an API project to configure OAuth in, and store credentials. Click New Project.

Create a new API project to store credentials.

Tip

Give the API Project a clear name, like “SotaERP Sync”, so it can be easily identified.

Enable Google calendar API

Now, click on Enabled APIs and Services in the left menu. Select Enabled APIs and Services again if the Search bar doesn’t appear.

Enable APIs and Services on the API Project.

After that, search for Google Calendar API using the search bar and select Google Calendar API from the search results. Click Enable.

Enable the Google Calendar API.

Create credentials

The Client ID and the Client Secret are both needed to connect Google Calendar to SotaERP. This is the last step in the Google console. Begin by clicking Credentials in the left menu. Then, click Create Credentials, and select OAuth client ID, Google will open a guide to create credentials.

Under Create OAuth Client ID, select Website application for the Application Type field, and type My SotaERP Database for the Name.

  • Under the Authorized JavaScript Origins section, click + Add URI and type the company’s SotaERP full URL address.

  • Under the Authorized redirect URIs section, click + Add URI and type the company’s SotaERP URL address followed by /google_account/authentication. Finally, click Create.

Add the authorized JavaScript origins and the authorized redirect URIs.

A Client ID and Client Secret will appear, copy these to a notepad.

Setup in SotaERP

Once the Client ID and the Client Secret are located, open the SotaERP database and go to Settings ‣ General Settings ‣ Integrations ‣ Google Calendar. Check the box next to Google Calendar.

The Google Calendar checkbox in General Settings.

Next, copy and paste the Client ID and the Client Secret from the Google Calendar API credentials page into their respective fields below the Google Calendar checkbox. Then, click Save.

Sync calendar in SotaERP

Finally, open the Calendar app in SotaERP and click on the Google sync button to sync Google Calendar with SotaERP.

Click the Google sync button in SotaERP Calendar to sync Google Calendar with SotaERP.

Note

When syncing Google Calendar with SotaERP for the first time, the page will redirect to the Google Account. From there, select the Email Account that should have access, then select Continue (should the app be unverifed), and finally select Continue (to give permission for the transfer of data)`.

Give SotaERP permission to access Google Calendar.

Now, SotaERP Calendar is successfully synced with Google Calendar!

Warning

SotaERP highly recommends testing the Google calendar synchronization on a test database and a test email address (that is not used for any other purpose) before attempting to sync the desired Google Calendar with the user’s production database.

Once a user synchronizes their Google calendar with the SotaERP calendar:

  • Creating an event in SotaERP causes Google to send an invitation to all event attendees.

  • Deleting an event in SotaERP causes Google to send a cancellation to all event attendees.

  • Adding a contact to an event causes Google to send an invitation to all event attendees.

  • Removing a contact from an event causes Google to send a cancellation to all event attendees.

Events can be created in Google Calendar without sending a notification by selecting Don’t Send when prompted to send invitation emails.