Function tryAutoLinkWebsiteUserToSlack

server/src/slack/sync.ts:488–575

(
  workosUserId: string,
  email: string
)

 * with the same email and links them if found.
 */
export async function tryAutoLinkWebsiteUserToSlack(
  workosUserId: string,
  email: string
): Promise<AutoLinkResult> {
  try {
    // Find Slack user with this email
    const slackUser = await slackDb.findByEmail(email);

    if (!slackUser) {
      logger.debug({ email }, 'No Slack user found for website user email');
      return { linked: false, reason: 'no_slack_user' };
    }

    // Check if Slack user is already mapped to a different WorkOS user
    if (slackUser.workos_user_id && slackUser.workos_user_id !== workosUserId) {
      logger.debug(
        { email, existingWorkosUserId: slackUser.workos_user_id, newWorkosUserId: workosUserId },
        'Slack user already mapped to different WorkOS account'
      );
      return { linked: false, reason: 'slack_user_already_mapped' };
    }

    // Check if this WorkOS user is already mapped to a different Slack user
    const existingMapping = await slackDb.getByWorkosUserId(workosUserId);
    if (existingMapping && existingMapping.slack_user_id !== slackUser.slack_user_id) {
      logger.debug(
        { workosUserId, existingSlackUserId: existingMapping.slack_user_id },
        'WorkOS user already mapped to different Slack account'
      );
      return { linked: false, reason: 'workos_user_already_mapped' };
    }

    // Already linked (same accounts)
    if (slackUser.workos_user_id === workosUserId) {
      logger.debug({ workosUserId, slackUserId: slackUser.slack_user_id }, 'Users already linked');
      return { linked: false, reason: 'already_linked' };
    }

    // Skip bots and deleted users
    if (slackUser.slack_is_bot) {
      return { linked: false, reason: 'slack_user_is_bot' };
    }
    if (slackUser.slack_is_deleted) {
      return { linked: false, reason: 'slack_user_is_deleted' };
    }

    // Link the accounts
    await slackDb.mapUser({
      slack_user_id: slackUser.slack_user_id,
      workos_user_id: workosUserId,
      mapping_source: 'email_auto',
    });

    logger.info(
      { workosUserId, slackUserId: slackUser.slack_user_id, email },
      'Auto-linked website user to Slack account by email'
    );