Unable to use “Output Block Data” as input in “Append Rows to Sheet” block in Qlik Sense SaaS Automation

sanil_barik — Thu, 16 Oct 2025 08:36:45 GMT

Hello Everyone,

I’m currently working on an automation in Qlik Sense SaaS that retrieves app and sheet details using multiple blocks and then writes the collected data to a Google Sheet.

However, I’m facing an issue - I’m not able to use the output data from the previous block (which contains the app details) as the input for the Append Rows to Sheet block.

Here’s what I’ve tried so far:

I used a List variable (AppDetails) to store all the details from earlier blocks.
When I configure the “Append Rows to Sheet” block, the output data or variable (AppDetails) is not available or selectable in the input field.
I also tried using Add Operation and other approaches to format or pass the data, but no success so far.

I’ve attached a screenshot for reference to show how the data is flowing between the blocks.

Could someone please guide me on how to properly pass the output block data (or list variable) into the Append Rows to Sheet block in the latest Qlik SaaS Automation interface?

Thanks in advance for your help!
– Sanil Kumar Barik

Re: Unable to use “Output Block Data” as input in “Append Rows to Sheet” block in Qlik Sense SaaS Automation

salmankojar — Fri, 07 Nov 2025 06:32:50 GMT

Hi @sanil_barik the attached screenshot shows that you are using append rows to sheet block outside the loop where your data content is generated. You can't get the data of a block which is used inside the loop block unless you are reading it from the same loop or else storing it in some variable.

topic Re: Unable to use “Output Block Data” as input in “Append Rows to Sheet” block in Qlik Sense SaaS Automation in Qlik Automate

Unable to use “Output Block Data” as input in “Append Rows to Sheet” block in Qlik Sense SaaS Automation

Re: Unable to use “Output Block Data” as input in “Append Rows to Sheet” block in Qlik Sense SaaS Automation