Sample code for 30+ languages & platforms
SQL Server Requires Chilkat v11.0.0+

Gmail SMTP: Send Email with OAuth2

See more GMail SMTP/IMAP/POP Examples

Send an email through smtp.gmail.com:587 with STARTTLS and an OAuth2 access token. Chilkat constructs the SASL XOAUTH2 authentication exchange; do not put the access token in SmtpPassword. Port 465 with implicit TLS is an alternative.

This example sends a real email. Set the mailbox to the account that authorized the token and use a recipient you control. The From address is that mailbox; another address must be an authorized Gmail send-as identity. Gmail normally saves SMTP submissions in Sent, so do not automatically append another copy through IMAP.

SMTP acceptance does not prove inbox delivery. Account sending limits, recipient limits, spam filtering, and Workspace policies still apply. A connection failure after message data was transmitted can leave the result uncertain; blind retries can create duplicate mail. Authentication/session logs can contain credentials and message data.

This example reads gmail-mail-token.json from a private working directory. Authorize the account first, then refresh the access token before it expires. The separate filename avoids confusing this full-mail grant with a narrower Gmail REST token. Store credentials in protected application storage; never distribute a user's token file with an application.

Gmail SMTP, IMAP, and POP3 use the https://mail.google.com/ OAuth scope. Narrower Gmail REST scopes such as gmail.send or gmail.readonly do not authorize these protocols. Public applications using this restricted scope must meet Google's verification requirements. See Gmail OAuth scopes and XOAUTH2.

Google documentation

Chilkat SQL Server Downloads

SQL Server
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @iTmp1 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Assumes Chilkat is unlocked. See Global Unlock Sample.

    DECLARE @token int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @token OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @token, 'LoadFile', @success OUT, 'gmail-mail-token.json'
    IF @success <> 1
      BEGIN

        PRINT 'Could not read gmail-mail-token.json from the private working directory.'
        EXEC @hr = sp_OADestroy @token
        RETURN
      END
    EXEC sp_OAMethod @token, 'JsonTypeOf', @iTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @token, 'StringOfEquals', @iTmp1 OUT, 'access_token', '', 1
    IF (@iTmp0 <> 1) or (@iTmp1 = 1)
      BEGIN

        PRINT 'An OAuth access token is required. Authorize or refresh the account first.'
        EXEC @hr = sp_OADestroy @token
        RETURN
      END
    DECLARE @mailbox nvarchar(4000)
    SELECT @mailbox = 'user@example.com'
    DECLARE @mailman int
    EXEC @hr = sp_OACreate 'Chilkat.MailMan', @mailman OUT

    EXEC sp_OASetProperty @mailman, 'SmtpHost', 'smtp.gmail.com'
    EXEC sp_OASetProperty @mailman, 'SmtpPort', 587
    EXEC sp_OASetProperty @mailman, 'SmtpSsl', 0
    EXEC sp_OASetProperty @mailman, 'StartTLS', 1
    EXEC sp_OASetProperty @mailman, 'RequireSslCertVerify', 1
    --  Alternative: port 465 with SmtpSsl=true and StartTLS=false (implicit TLS).
    EXEC sp_OASetProperty @mailman, 'SmtpUsername', @mailbox
    EXEC sp_OASetProperty @mailman, 'SmtpPassword', ''
    EXEC sp_OAMethod @token, 'StringOf', @sTmp0 OUT, 'access_token'
    EXEC sp_OASetProperty @mailman, 'OAuth2AccessToken', @sTmp0

    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT

    EXEC sp_OASetProperty @email, 'From', @mailbox
    EXEC sp_OASetProperty @email, 'Subject', 'Sample message'
    EXEC sp_OASetProperty @email, 'Body', 'This message was sent through Gmail SMTP using OAuth2.'
    EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Recipient', 'recipient@example.net'
    IF @success <> 1
      BEGIN

        PRINT 'Could not add the recipient.'
        EXEC @hr = sp_OADestroy @token
        EXEC @hr = sp_OADestroy @mailman
        EXEC @hr = sp_OADestroy @email
        RETURN
      END

    --  This sends a real message. Replace the recipient with an address you control.
    EXEC sp_OAMethod @mailman, 'SendEmail', @success OUT, @email
    IF @success <> 1
      BEGIN
        EXEC sp_OAMethod @mailman, 'CloseSmtpConnection', @success OUT

        PRINT 'SMTP send failed. Check the token, mailbox, recipient, and Gmail sending limits.'
        --  Inspect LastErrorText privately if needed; do not publish authentication/session logs.
        --  A lost connection after DATA can leave acceptance uncertain. Avoid blindly retrying.
        EXEC @hr = sp_OADestroy @token
        EXEC @hr = sp_OADestroy @mailman
        EXEC @hr = sp_OADestroy @email
        RETURN
      END
    EXEC sp_OAMethod @mailman, 'CloseSmtpConnection', @success OUT
    IF @success <> 1
      BEGIN

        PRINT 'Gmail accepted the message, but closing the connection failed. Do not resend it.'
        EXEC @hr = sp_OADestroy @token
        EXEC @hr = sp_OADestroy @mailman
        EXEC @hr = sp_OADestroy @email
        RETURN
      END

    PRINT 'Gmail accepted the message for delivery.'

    EXEC @hr = sp_OADestroy @token
    EXEC @hr = sp_OADestroy @mailman
    EXEC @hr = sp_OADestroy @email


END
GO