So, for anyone following this post looking for a “silver bullet” answer to all this, let me just say that @boston85719 is absolutely correct. You really need to consider whether or not its worth it in the end.
Here’s what I learned about the situation. When using a third-party signup option, Bubble creates an 0Auth token and uses that as the identifier for the user, instead of the email address. That user is then forever linked to that account via the token. However, if you collect the available Google user data (email, name, profile image), you can add the email to the account. If a user then performs the “forgot password” option, then can add a password to the account then then log in with either Google or directly with their email and newly created password. Not sure why anyone would actually do this, but it is possible. However, it does not work the other way around. If a user manually creates an account using their gmail address, and then attempts to signup or signin with Google credentials, they will get an error message as @boston85719 explained above.
So, it still becomes messy if a user attempts to mix and match the signin credentials. It is certainly possible to add a flag to the user account when they originally sign up with a third-party, and then present a message to the user when they try to sign in without using the 0Auth client, but is still doesn’t work the other way around, except to trap the 0Auth login failure and add an alert telling them to try signing in the normal way.