send a google sheets sheet by email

[Alejandro-juarez22]

I want to send a google sheet by mail but I can't find the way, can you help me?

[Frank_S]

There is a google sheets connector within Qlik Cloud application automation.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_QlikAutomation/connector-blo...

Application Automation connectors

Qlik Application Automation includes a set of connectors that let you integrate third-party services and applications into your data analytics workflows. This section lists the available connectors and what they are used for.

You may wish to being to explore your requirement therein.

Kind regards...

[Alejandro-juarez22]

Thanks for your answer, I know the connectors but I'm not getting my automation to send the google sheet

[Frank_S]

I suggest that you disable the 'send mail' object and do a 'test' run to ensure that there are no errors in your automation.

Once your tests are good with 'send mail' block disabled, you will then need to

• re-enable the send mail block
• ensure that your send mail object is configured accurately. 

Keep in mind that simple authentication has been disabled by providers such as google and microsoft. 

If the issue is with your SMTP provider which you use in your Send Mail object, then you may wish to try a different email provider. See suggestions in the link below.

• Tutorial: use Sendgrid bulk email service SMTP wit... - Qlik Community - 2001715

Kind regards...

[AfeefaTk · Accepted solution]

Hi @Alejandro-juarez22 

Unfortunately, It's not possible to send the google sheet as an attachment via email using QAA

We can achieve it using Microsoft Excel files where we can convert excel report to pdf and send it as an attachment using Send Mail block

For more info refer to the below article

https://community.qlik.com/t5/Official-Support-Articles/How-to-convert-Excel-reports-to-PDF-using-Ql...

Hope this helps!

Thanks!

Afeefa TK

[AfeefaTk]

Hi @Alejandro-juarez22 

UPDATE

We found a way to send Microsoft excel report as an attachment using Send Mail block. Please take a look at this article.

Thanks