How to send Email from alteryx

[Abhi31]

I have a workflow , which runs every hour on scheduler. 

Is there a way that workflow can open the excel file ,  copy the data and distribute that result out via Gmail.

[TheOC]

Yes! What you would have to do is have this have the excel file as an input, and then input this data into the https://help.alteryx.com/current/designer/email-tool

This will take 5 minutes to set up the email tool, but you can see how to do so via gmail here:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Send-Emails-Through-Gmail-Us...

Hope this helps! 

[Abhi31]

I tried solving my problem using the link , but gives me error of couldn't connect to server. 

[TheOC]

This might be a problem with the firewall on your server. If you run that workflow on your local machine, does the email tool work?

[Abhi31]

I'm trying to run that on my local machine right now , gives error.

[TheOC]

can you give me a screenshot of the configuration window of your email tool, or send me your workflow please and i'll have a look and see if its the same on my side. I'd recommend removing your email/recipients however

[Abhi31]

Please see the workflow. It has the input file and email tool set-up like that

[TheOC]

hi @Abhi31 

I have ran this on my side with the following config:

And it seems to have worked fine. I did get an access denied error, but then i have to make an app password in Gmail:

https://support.google.com/accounts/answer/185833?hl=en

And i may have send a few tew many emails to myself:

My only guess on your side is either the gmail/gsuite account needs to be set up differently, or firewall on your side is stopping it. As most errors would make sense, but not connecting to server usually is a wrong SMTP input but yours was fine.

Sorry I cant help much more, hopefully with different experience on this can shed any light

[Abhi31]

Sent you a personal message , please see.