Gmail and Auth account generate 2 different accounts

The behavior you describe between a user identity associated with a database connection (service specific username/email and password credentials) and a user identity associated with Google social credentials is the expected one.

By default the user identities are independent and treated as different users even if they happen to be used by the same person (same email address even). If you want your application to allow username/email and password credentials alongside social providers while still treating users with the same verified email address as one identity then you need to perform account linking. See the reference documentation for additional information, but if you scenario revolves around automatic account linking for identities that have the same verified email address then you can accomplish that through a rule (check the available templates).