Google Workspace Email Configuration Issue

[mayurpansheriya]

Information about bug

We are unable to configure Google Workspace Email Domin in our ERPNext due to some change in Google Workspace. Please refer below link.

https://support.google.com/a/answer/2956491?hl=en&src=supportwidget0&authuser=0

Module

integrations

Version

ERPNext: v15.61.1
Frappe Framework: v15.68.1

Installation method

docker

Relevant log output / Stack trace / Full Error Message.

Traceback (most recent call last):
  File "apps/frappe/frappe/email/doctype/email_queue/email_queue.py", line 167, in send
    ctx.fetch_smtp_server()
  File "apps/frappe/frappe/email/doctype/email_queue/email_queue.py", line 250, in fetch_smtp_server
    self.smtp_server = self.email_account_doc.get_smtp_server()
                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/email/doctype/email_account/email_account.py", line 496, in get_smtp_server
    return self._smtp_server_instance
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/functools.py", line 1001, in __get__
    val = self.func(instance)
          ^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/email/doctype/email_account/email_account.py", line 500, in _smtp_server_instance
    config = self.sendmail_config()
             ^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/email/doctype/email_account/email_account.py", line 483, in sendmail_config
    "password": self._password,
                ^^^^^^^^^^^^^^
  File "apps/frappe/frappe/email/doctype/email_account/email_account.py", line 338, in _password
    return self.get_password(raise_exception=raise_exception)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/model/base_document.py", line 1151, in get_password
    return get_decrypted_password(self.doctype, self.name, fieldname, raise_exception=raise_exception)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/utils/password.py", line 41, in get_decrypted_password
    frappe.throw(
  File "apps/frappe/frappe/__init__.py", line 609, in throw
    msgprint(
  File "apps/frappe/frappe/__init__.py", line 574, in msgprint
    _raise_exception()
  File "apps/frappe/frappe/__init__.py", line 525, in _raise_exception
    raise exc
frappe.exceptions.AuthenticationError: Password not found for Email Account Mayur password

[DipenFrappe]

We already have the OAuth configuration in the email, maybe config issue at your end.