Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
How to use Send email plugin?
Added on July 26, 2023 9:12PM
Likes: 0
Replies: 6
rafael_rosado97
Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 62 Partner
Hi, everyone.
I want to send a mail using the Send email plugin. I set the field like this:
Recipient (column): mail
Sender (value): my_email@gmail.com
Subject (value): Example
Body (value): This is the body
SMTP Host: smtp.gmail.com
SMTP port: 587
But when I saw the output dataset, in each row(where each recipient's email is) it says: (530, '5.7.0 Must issue a STARTTLS command first. o18-20020a0cf4d2000000b0063d316af55csm424171qvm.3 - gsmtp', u'my_email@gmail.com')
Do you know why it occurs?
Than you, very much!
Operating system used: Linux
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,320 NeuronThis plugin only works with unauthenticated and unencrypted SMTP servers which of course Gmail is not.
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,617 NeuronDoes anyone know of a way to work with Gmail servers from within Dataiku DSS?
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,320 Neuron
Ah, an easy question for chatGPT:
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,320 Neuron
BTW I just tested using Gmail as a Mail SMTP messaging channel in Dataiku and it works fine. Here is my configuration:
-
rslay Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 1 Dataiker
Hi All!
It appears that Google made some updates for how it interacts with third-party applications when a user's account has enabled two-factor authentication. These steps worked for me to connect the Send Emails Plugin to Gmail
Notes:
- Confirm your Administrator has created a Mail (SMTP) channel in Administration -> Settings -> Notifications & Integrations
- Set the Host to smtp.gmail.com (Gmail SMTP)
- Set the Port to 587 (or 465 for SSL/TLS)
- If two-factor authentication is enabled, you must create a Google App Passwords. This auto-generated code should be used as the Password, versus a user's standard login information. I used this code both when setting up the Mail SMTP Channel (in the Administration section) and within the Send Emails Plugin
Links:
-
Start by checking out the plugin's documentation for step-by-step instructions. Also, if you're dealing with email lists, it's always a good idea to run them through an email verifier tool. It helps ensure your emails reach the right inboxes without any hiccups.
