Connect Qlik and Google Sheets

Qlik reports when apps are created, reloaded, published, exported or deleted, and when users are added or removed. FlowMattic writes those events to Google Sheets, giving BI admins an app inventory, a reload history and a user list for licence reviews, all in a file anyone in IT can open.

Try FlowMattic free See example workflows

8 triggers 19 actions 5 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Qlik2 triggers

Do this in Google Sheets19 actions

1. TriggerApps

2. ActionAdd New Row

When Qlik fires Apps, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Qlik and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Log Qlik app events to an inventory sheet

Every app event adds a row with app name, owner and event type, so admins have a record of what exists and what changed.

AppsAdd New Row

View the template

Keep a log of user accounts created and deleted

Each user event becomes a row with name, email and action, so licence reviews start from a dated list.

UsersAdd New Row

Keep a reload history for each app

A Filter passes only reload events and writes them to a history tab, so you can see whether a dashboard refreshed before a morning meeting.

AppsFilterAdd New Row

Keep one row per app with its latest status

Look the app up in the inventory tab and update it on publish or deletion, so the list shows what is live and what is retired.

AppsLookup Row DataRouterUpdate Row

Remove a user from the active list when they are deleted

A Router checks whether the user was created or deleted. Deletions find the person's row and remove it, so the seat count stays honest.

UsersRouterLookup Row DataDelete Row

Set up: an app event log

At the end, each app event in Qlik adds a row to your inventory sheet.

Prepare the inventory
Create headers such as App ID, App name, Owner, Event and Time.
Connect Google Sheets
Under Connects, add a Google account that can edit the inventory.
Choose the Apps trigger
Create a workflow with the Qlik Apps trigger and complete the setup shown in the trigger step.
Reload a test app
Reload or publish an app in Qlik so FlowMattic captures an event.
Map and turn on
Add Google Sheets Add New Row, map the app fields, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

Qlik app icon — Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

From Qlik	To Google Sheets
App ID	App ID
App name	App name
Owner	Owner
Event type	Event
Event time	Time

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

The Apps trigger covers created, deleted, data updated, reloaded, published and exported events. Use the event type in a Filter or Router to tell them apart.
The Users trigger fires for both new and deleted users, so route on the event type before you write or delete rows.
Use the app ID rather than the name to find rows, since app names can change.

Qlik

Integration page

Triggers (2)

AppsTriggers when an app is Created, Deleted, Data Updated, Reloaded, Published, or Exported.
UsersTriggers when a user is Created or Deleted.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Qlik and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Admin data on your server

App and user events pass through your WordPress site to the sheet, with no other automation provider holding them.

Busy reload schedules cost the same

Runs are unlimited, so apps that reload every hour need no bigger plan.

Audits from a sheet

Licence and governance reviews start from a dated list rather than screenshots of the Qlik console.

Common questions

How do I log Qlik app activity in Google Sheets?

Create a workflow with the Qlik Apps trigger and a Google Sheets Add New Row step. Map the app ID, name, event and time, test with a reload and switch it on.

Can I track Qlik licence seats?

Yes. Use the Users trigger to add a row when a user is created and delete their row when they are removed. A row count shows seats in use.

Can I see failed or missing reloads?

You can see the reloads that happened. Filter app events to reloads and write them to a history tab, then compare the times with your expected schedule.

Can the sheet change anything in Qlik?

No, these workflows read Qlik events and write rows. Apps and users are still managed in Qlik.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Qlik and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Qlik integration 1.0.0, Google Sheets integration 2.2.4.