Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Alejandro-juarez22
Contributor II
Contributor II
‎2022-11-16 11:42 AM

send a google sheets sheet by email

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

Labels (1)
Labels
1,231 Views
0 Likes
1 Solution

Accepted Solutions
AfeefaTk
Support
Support
‎2022-11-29 01:32 AM

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

View solution in original post

1,125 Views
0 Likes
5 Replies
Frank_S
Support
Support
‎2022-11-16 01:29 PM

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

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
1,220 Views
0 Likes
Alejandro-juarez22
Contributor II
Contributor II
‎2022-11-16 01:39 PM
Author

In response to Frank_S

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

qlik.jpg

1,216 Views
0 Likes
Frank_S
Support
Support
‎2022-11-16 02:00 PM

In response to Alejandro-juarez22

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.

Kind regards...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
1,214 Views
0 Likes
AfeefaTk
Support
Support
‎2022-11-29 01:32 AM

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

1,126 Views
0 Likes
AfeefaTk
Support
Support
‎2023-02-15 11:25 PM

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 

939 Views
0 Likes