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.
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-toolThis 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-Using-the-Alteryx-Email-Tool/ta-p/468838Hope this helps!
I tried solving my problem using the link , but gives me error of couldn't connect to server.