Need to automate export table data into Google sheet

[Subashchandra_28]

I have a Qlik Cloud report with a table that I want to automate exporting to Google Sheets. I used the Qlik Cloud Automations option, but I encountered the following error: "Object data can't be bigger than 100,000 cells."

The table in my report contains a total of 36,000 records. Is there any solution or incremental process I can follow to resolve this issue? Below is the automation process I am currently using.

Please let me know if there are any modifications I need to make to my automation process.

Thanks ,

Subash Chandra

[David_Friend]

@Subashchandra_28 so does your table have more then 100,000 cells?

[Subashchandra_28]

Yes, Its more than 100000 cells.

[paulcalvet]

Hello,

if your table have moore than 100 000 cells, maybe you can loop on a dimension to export your data.

Regards

[Subashchandra_28]

Hi Paulcalvet,

Thank you for the quick response.

I'm new to the automation process, can you explain what to do and where to add in the processes. If you have any JSON file for the automation process, please share here.

Thanks,

M Subash Chandra 

[paulcalvet]

You have an example of cycled report here, it's the same logic.

Regards,