Issue with Google Integration in Twenty CRM - Google Sync Failed

[ralfdigitalagency]

Hello everyone,

I’m trying to integrate Google Calendar and Google Gmail with Twenty CRM following the official self-hosting guide: Setup Messaging & Calendar Sync. I’ve completed the following steps:

-Created a project in Google Cloud Console.
-Enabled the required APIs (Google Calendar API, Gmail API, and Google People API).
-Created OAuth credentials and obtained the Client ID and Client Secret.
-Configured the required scopes in Google Cloud Console:
+https://www.googleapis.com/auth/calendar.events
+https://www.googleapis.com/auth/gmail.readonly
+https://www.googleapis.com/auth/userinfo.email

Problem 1: Where to add the Scopes?
The guide is unclear on whether the scopes should be added to the .env file in the project or if they should just be configured in Google Cloud Console. I’ve added them in Google Cloud Console, but I’m unsure if I need to modify anything in the Twenty CRM configuration files as well.

Problem 2: "Connect to Google" Button not Appearing
Even though everything seems configured correctly, I can’t see the "Connect to Google" button in the Twenty CRM settings. Is there something I need to do to make it visible?

What I’ve tried so far:

Restarted the Docker container for Twenty CRM.
Checked the logs, and there don’t seem to be any obvious errors.
Double-checked all configurations in Google Cloud Console and Twenty CRM, but the button still doesn’t appear.

Details:
Twenty CRM version: v0.42.5
Docker version: latest
Operating system of the server: Ubuntu 24.04

Anyone with experience integrating Google into Twenty CRM, your help would be greatly appreciated!

[ralfdigitalagency]

UPDATE

I added this code to the docker-compose.yml file:

Configurazione Google OAuth

  CALENDAR_PROVIDER_GOOGLE_ENABLED: ${CALENDAR_PROVIDER_GOOGLE>      AUTH_GOOGLE_CLIENT_ID: ${AUTH_GOOGLE_CLIENT_ID}
  AUTH_GOOGLE_CLIENT_SECRET: ${AUTH_GOOGLE_CLIENT_SECRET}
  AUTH_GOOGLE_CALLBACK_URL: ${AUTH_GOOGLE_CALLBACK_URL}
  AUTH_GOOGLE_APIS_CALLBACK_URL: ${AUTH_GOOGLE_APIS_CALLBACK_U>

and got this (see attachment), did I configured it right?

[byayex]

Have a similar issue, everything is configured like above but i get an „sync failed“ text on my account but no error logs.

[naiki-devlab]

I do have similar issue with a self hosted docker deployment on my ubuntu VPS.

ive set the google related env vars from the admin panel as per the documentation page.
i can go throught the entire oauth auth flow and i get redirected as should be, but the sync is still failling

please provide fix, documentation or bounty for this problem

[Rixita]

Hi all, I have the same issue as the others in this thread are having. Would be great if there was a solution for this issue.
Thanks.

[salesbay]

We upgraded to version 0.55.6, but the issue persists. We had to manually adjust the settings to get it to work, yet we still frequently experience timeouts.

[Rixita]

Hi @salesbay, could you please elaborate on what you mean by "manually adjust the settings to get it to work"? I’d like to try that as a temporary solution.
thx.

[byayex]

I fixed my error by running the migration commands aswell as rerunning the cron commands

[Rixita]

@byayex Do you run in docker? could you share which commands you used for the migration commands? That would be great, thanks

[byayex]

Yes I run in docker. I used
yarn database:migrate:prod yarn command:prod upgrade

and the cron jobs

# from your worker container yarn command:prod cron:messaging:messages-import yarn command:prod cron:messaging:message-list-fetch yarn command:prod cron:calendar:calendar-event-list-fetch yarn command:prod cron:calendar:calendar-events-import yarn command:prod cron:messaging:ongoing-stale yarn command:prod cron:calendar:ongoing-stale yarn command:prod cron:workflow:automated-cron-trigger

This fixed it for me.

[alex-osti]

Hey,

Had the same issue - the worker service needs identical environment variables as the main service (except for command). Here's the fix:

version: '3.8'
services:
  twenty:
    image: 'twentycrm/twenty:${TAG:-latest}'
    environment:
      - SERVER_URL=$SERVICE_FQDN_TWENTY
      - FRONT_BASE_URL=$SERVICE_FQDN_TWENTY
      # ... (other vars) ...
  
  worker:
    image: 'twentycrm/twenty:${TAG:-latest}'
    # --- Ensure ALL environment vars match `twenty` ---
    environment:
      - SERVER_URL=$SERVICE_FQDN_TWENTY  # Must match
      - FRONT_BASE_URL=$SERVICE_FQDN_TWENTY  # Must match
      # ... (include ALL other vars from `twenty`) ...
    command: 'yarn worker:prod'
    depends_on:
      twenty:
        condition: service_healthy

  # ... (db, redis, volumes config) ...

Key Notes:

1. The worker must mirror twenty’s environment section to avoid issues.
2. Only command and depends_on should differ.

[tuladhar]

I'm on v0.52.6, and getting the same "Sync failed". Here's what I did.

• Added scope (see below)
• Ran the migration commands and rerunning the cron commands as mentioned above, didn't work.
• Reconnect didn't work.
• Remove account and connect back didn't work.

In worker logs, I get this SQL error which seems promising, atleast not flying blind:

worker-1  | [Nest] 34  - 07/16/2025, 2:58:07 AM     LOG [GmailGetMessagesService] Messaging import for workspace 67f48241-fcbb-4252-8c9c-9465c3f961ca and account 0177eebd-1fac-
464c-93ab-87a1f5cf7560 formatting 200 messages in 54ms                                                                                                                          
worker-1  | query failed: INSERT INTO "workspace_65k3f2g8u1ggvb661r6jxiq4q"."messageChannelMessageAssociation"("messageId", "messageChannelId", "deletedAt", "updatedAt", "creat
edAt", "id", "direction", "messageThreadExternalId", "messageExternalId") VALUES ($1, $2, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $3, $4) ON CONFLICT ( "messageChannelId",
 "messageId" ) WHERE ( "deletedAt" IS NULL ) DO UPDATE SET "messageChannelId" = EXCLUDED."messageChannelId", "messageId" = EXCLUDED."messageId", "messageThreadExternalId" = EXC
LUDED."messageThreadExternalId", "messageExternalId" = EXCLUDED."messageExternalId", "updatedAt" = DEFAULT  RETURNING "deletedAt", "updatedAt", "createdAt", "id", "direction", 
"messageThreadExternalId", "messageExternalId" -- PARAMETERS: ["afcc76b8-8a1e-4dc6-a1f5-1840cbb48431","5da2c04a-b9cf-4c55-b091-b801ade1ebd1","1975983337895569","197cd9da9e758e0f"]
worker-1  | error: error: there is no unique or exclusion constraint matching the ON CONFLICT specification
worker-1  | Exception Captured
worker-1  |   undefined
worker-1  | Exception Captured
worker-1  |   undefined
worker-1  |   [
worker-1  |     'Unknown error importing messages for message channel 5da2c04a-b9cf-4c55-b091-b801ade1ebd1 in workspace 67f48241-fcbb-4252-8c9c-9465c3f961ca: there is no unique or exclusion constraint matching the ON CONFLICT specification'
worker-1  |   ]
worker-1  |   [
worker-1  |     MessageImportException [Error]: there is no unique or exclusion constraint matching the ON CONFLICT specification
worker-1  |         at MessageImportExceptionHandlerService.handleUnknownException (/app/packages/twenty-server/dist/src/modules/messaging/message-import-manager/services/messaging-import-exception-handler.service.js:110:15)
worker-1  |         at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
worker-1  |         at async MessageImportExceptionHandlerService.handleDriverException (/app/packages/twenty-server/dist/src/modules/messaging/message-import-manager/services/messaging-import-exception-handler.service.js:62:17)
worker-1  |         at async MessagingMessagesImportService.processMessageBatchImport (/app/packages/twenty-server/dist/src/modules/messaging/message-import-manager/services/messaging-messages-import.service.js:122:13)
worker-1  |         at async MessagingMessagesImportJob.handle (/app/packages/twenty-server/dist/src/modules/messaging/message-import-manager/jobs/messaging-messages-import.jo$.js:63:9)
worker-1  |         at async MessageQueueExplorer.invokeProcessMethods (/app/packages/twenty-server/dist/src/engine/core-modules/message-queue/message-queue.explorer.js:111:17)
worker-1  |         at async MessageQueueExplorer.handleProcessor (/app/packages/twenty-server/dist/src/engine/core-modules/message-queue/message-queue.explorer.js:103:13)
worker-1  |         at async /app/packages/twenty-server/dist/src/engine/core-modules/message-queue/message-queue.explorer.js:79:17
worker-1  |         at async Worker.processFn (/app/packages/twenty-server/dist/src/engine/core-modules/message-queue/drivers/bullmq.driver.js:41:13)
worker-1  |         at async /app/node_modules/bullmq/dist/cjs/classes/worker.js:520:32 {
worker-1  |       code: 'UNKNOWN'
worker-1  |     }
worker-1  |   ]

Scopes

TODO:

• I'll now try upgrade to newest 1.x version, and see if this resolves.

[tuladhar]

✅ Google Synced!

⚠️ WARNING: After upgrading to v1.1, there's "pending migration" issue. But that's a diff. problem, see here.