Monitor Polish counterparties for insolvency with Apify, Google Sheets and Gmail
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 19 nodes and runs on a schedule (every week at 07:00) (plus 1 other trigger). Along the way it connects Google Sheets, Gmail, Slack and Apify (community).
How it runs
Trigger: On a schedule (every week at 07:00) (plus 1 other trigger).
- Read watchlist (Google Sheets) (Google Sheets): read
- Sample watchlist (Code): runs custom JavaScript code
- Clean identifiers (Edit Fields (Set)): sets 3 fields: company, nip, krs
- Only valid identifiers (Filter): keeps only the items that match a condition
- KRZ: debtor register search (Apify): run actor and get dataset (actors)
- MSiG: court gazette notices (Apify): run actor and get dataset (actors)
- Shape KRZ findings (Code): runs custom JavaScript code
- Shape MSiG notices (Code): runs custom JavaScript code
- New KRZ entries only (Remove Duplicates): removes duplicate items
- New MSiG notices only (Remove Duplicates): removes duplicate items
…plus 7 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in KRZ: debtor register search, MSiG: court gazette notices, KRZ: proceeding details).
Nodes used (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - Apify
@apify/n8n-nodes-apify.apify - Remove Duplicates
n8n-nodes-base.removeDuplicates - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow runs every Monday to check a Google Sheets watchlist of Polish companies against the KRZ National Debtor Register and MSiG court gazette via Apify, then emails (and optionally Slack-posts) only newly detected insolvency or…