topic Re: send a google sheets sheet by email in Qlik Automate

send a google sheets sheet by email

Alejandro-juarez22 — Wed, 16 Nov 2022 16:42:54 GMT

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

Re: send a google sheets sheet by email

Frank_S — Wed, 16 Nov 2022 18:29:39 GMT

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-blocks/connectors-list.htm

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...

Re: send a google sheets sheet by email

Alejandro-juarez22 — Wed, 16 Nov 2022 18:39:50 GMT

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

Re: send a google sheets sheet by email

Frank_S — Wed, 16 Nov 2022 19:04:38 GMT

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...

Re: send a google sheets sheet by email

AfeefaTk — Tue, 29 Nov 2022 06:32:48 GMT

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

Re: send a google sheets sheet by email

AfeefaTk — Thu, 16 Feb 2023 04:25:49 GMT

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