Qliksense to Google sheet /excel automation/add on

[Neeru]

Hello all,

I would like to know if there is any chance to do automation to write data from Qliksense to google sheet/excel?
For example, automating values in the Qliksense table to the required column and row in google sheet/excel?

Please let me know if anyone has any leads 

Thank you 🙂

Regards,
Neeru

[MarkGeurtsen · Accepted solution]

Hi,

It is possible to get data from Qlik Sense using an automation through the block Get Straight Table Data. This block only works on tables in Qlik Sense.

We have connectors for Google Sheets or Microsoft Excel and it should be possible to write the rows returned from the Qlik Sense table into a worksheet / table into either of these.

Of course it is possible to also make selections beforehand in an automation. The block Get Straight Table Data is limited to 100,000 cells.

Does this answer your question? See attachment for example.

[martinpohl]

how can I use the attached json file?

Thank you

[PietMichielRappelet · Accepted solution]

Hi Martin, please take a look at: 

https://community.qlik.com/t5/Knowledge/How-to-upload-and-download-automations/ta-p/1781602

[martinpohl]

perfect,

didn't know