{"product_id":"apify-insolvency-monitor-polish-watchlist-to-gmail-sheets","title":"Apify Insolvency Monitor: Polish Watchlist to Gmail \u0026 Sheets","description":"\u003ch3\u003eApify Insolvency Monitor: automatic Polish watchlist alerts to Gmail \u0026amp; Google Sheets\u003c\/h3\u003e\n\u003cp\u003eGet notified only when new insolvency or restructuring-related entries appear for your Polish counterparties. This n8n workflow checks your Google Sheets watchlist against the \u003cstrong\u003eKRZ National Debtor Register\u003c\/strong\u003e and the \u003cstrong\u003eMSiG court gazette\u003c\/strong\u003e via \u003cstrong\u003eApify\u003c\/strong\u003e, then emails you a consolidated alert—optionally posting to \u003cstrong\u003eSlack\u003c\/strong\u003e—without spamming duplicates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every Monday at 07:00\u003c\/strong\u003e (or manually with a sample watchlist for testing).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your watchlist from Google Sheets\u003c\/strong\u003e and normalizes \u003cstrong\u003eNIP\/KRS\u003c\/strong\u003e identifiers, keeping only rows with valid identifiers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches the KRZ National Debtor Register\u003c\/strong\u003e for each company using Apify and formats results into alert-ready entries (including registry errors).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDe-duplicates previous findings\u003c\/strong\u003e by dropping KRZ items already reported in earlier executions.\u003c\/li\u003e\n  \u003cli\u003eFor newly detected KRZ proceedings, uses Apify to fetch \u003cstrong\u003eproceeding type, status, case number, and start date\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches the MSiG court gazette\u003c\/strong\u003e for the \u003cstrong\u003elast 8 days\u003c\/strong\u003e, formats notices (or errors), and again removes items already reported previously.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCombines all new KRZ + MSiG items\u003c\/strong\u003e into a single table-based HTML email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends one HTML email via Gmail\u003c\/strong\u003e and can optionally \u003cstrong\u003epost the text version to Slack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor high-risk Polish suppliers\/customers weekly and quickly flag potential insolvency risk.\u003c\/li\u003e\n  \u003cli\u003eCompliance and due-diligence teams who need timely court-gazette and debtor-register updates.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators using n8n to automate counterparty risk monitoring without manual searching.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify\u003c\/strong\u003e API integration (requires an Apify API token).\u003c\/li\u003e\n  \u003cli\u003eGoogle Sheets integration to read columns: \u003cstrong\u003ecompany\u003c\/strong\u003e, \u003cstrong\u003enip\u003c\/strong\u003e, \u003cstrong\u003ekrs\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e node to send one consolidated HTML email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e node (optional) to post alerts.\u003c\/li\u003e\n  \u003cli\u003en8n logic nodes used: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eInstall the community node \u003cstrong\u003e@apify\/n8n-nodes-apify\u003c\/strong\u003e if you’re self-hosting, then connect your credentials and select the sheet containing your watchlist.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46094165278899,"sku":"N8N-19939","price":22.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/njFRffUbwhHhx7CiIn6v8_MWWjPVXh.png?v=1790413794","url":"https:\/\/buyflowscripts.com\/products\/apify-insolvency-monitor-polish-watchlist-to-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}