Skip to main content

How to send emails from your Gmail account with SMTP with Qlik Application Automation

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Emile_Koslowski
Employee
Employee

How to send emails from your Gmail account with SMTP with Qlik Application Automation

Last Update:

Sep 26, 2022 10:47:43 AM

Updated By:

Emile_Koslowski

Created date:

Jul 19, 2021 8:20:24 AM

Sending an email over SMTP is only possible with the "Send Mail" block from the Mail connector. Do not confuse this with the native "Send Email" block in Blendr.io standalone environment.

Note: Google has deprecated app passwords & less secure app access for personal accounts since May 2022. This deadline does not apply for Google Workspace or Google Cloud Identity customers, these account types have a later deadline that is not yet communicated. (source)

With the new "Send Mail" block, it is now possible to send emails from your personal email account using SMTP.

For Gmail, execute the following steps to enable SMTP:

  1. Enable IMAP: go to Settings -> all settings -> Forwarding and POP/IMAP -> enable IMAP
  2. Generate an app password (see Sign in with app passwords)
  3. Enter the following settings when creating the connection:
    1. sender email address: your full email address
    2. username: leave empty
    3. host: smtp.gmail.com
    4. password: the app password (see Sign in with app passwords)
    5. port: 587
    6. security: STARTTLS


The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Labels (2)
Comments
rafael-attux
Luminary Alumni
Luminary Alumni

Hello @Emile_Koslowski .

This block only works with GMAIL, or it's just an example? I'm trying to configure an AWS SMTP with this block, but without success.

Emile_Koslowski
Employee
Employee

Hi @rafael-attux , 

This block should work with any SMTP server.
I haven't tried to connect to AWS SMTP myself, feel free to send me an email with the error and any additional information.

DanaL
Creator
Creator

Hi,

Thanks for the detailed explanation.

After applying the Gmail adjustments,  I'm getting an error message after running the automation:

DanaL_0-1645796980996.png

Any idea why?

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @DanaL!

I would recommend posting your query in our Qlik Application Automation forum, which is monitored by our engineers and has an active community.

All the best,
Sonja 

samscudd
Contributor
Contributor

Hi All!

First off, thanks for a very informative post!  

Secondly, does anyone know if it is possible for me to connect to my Gmail account if I have two-factor authentication enabled?

Cheers,

Sam

 

 

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @samscudd 

With MFA enabled, use an app password: Sign in with app passwords.

All the best,
Sonja 

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Just noticed that Google is making Less Secure Application access a thing of the past at the end of next month:
https://support.google.com/accounts/answer/6010255

2022-04-21_12-36-09.png

 

From then the App Password approach, mentioned by @Emile_Koslowski and @Sonja_Bauernfeind will be the only way to use a Workspace / GMail account for sending mail from Qlik apps.

Steve

 

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

I've added some additional notes on setting up App Passwords in this blog post:
https://www.quickintelligence.co.uk/google-smtp-and-imap-to-break-gmail/

Steve

Emile_Koslowski
Employee
Employee

Hi Steve,

Thank you for sharing this!

I'll update the article accordingly.

Kind regards,

Emile

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Thanks @Emile_Koslowski 

Version history
Last update:
‎2022-09-26 10:47 AM
Updated by: