Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Nov 23, 2022 2:28:33 AM
Sep 16, 2021 7:18:26 AM
This article gives an overview of the available blocks in the Google Sheets connector in Qlik Application Automation. It will also go over some basic examples of creating a new spreadsheet, adding new sheets to it, adding some information to the sheet as well as removing information from it.
You will find the mentioned example attached to this article in JSON format so you can upload it to your workspace and get started with it easily.
This connector supports operations to manage spreadsheets, adding/removing sheets from spreadsheets, manipulating sheet data, and a few other support operations.
Authentication for this connector is based on the oAuth2 Protocol.
Let's start with the example prepared:
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
Hello, is it possible to send the sheet by email?
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
Hope this helps!
Thanks!
Afeefa TK
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
Can We Link Google spreadsheets sales data into Qlik sense and automation?
Can We Link Google Sheets to app and visualize with spreadsheets and after update i will change the data in google sheets and automatically change in the Qlik sense App