{"product_id":"n8n-workflow-track-msme-45-day-payments-slack-alerts","title":"n8n Workflow: Track MSME 45-Day Payments \u0026 Slack Alerts","description":"\u003ch3\u003eAutomate MSME 45-Day Payment Tracking with Slack Alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors Micro\/Small MSME vendor bills for Section 43B(h) compliance, calculates 15\/45-day deadlines and tax-at-risk, and automatically sends \u003cstrong\u003eSlack alerts\u003c\/strong\u003e plus a CFO briefing with an \u003cstrong\u003eapprove\/hold\u003c\/strong\u003e step—backed by updates to your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e bill register.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily (Mon–Sat)\u003c\/strong\u003e on a schedule or starts instantly when bills\/payments are posted via a \u003cstrong\u003ewebhook\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eLoads \u003cstrong\u003eVendor Master\u003c\/strong\u003e and \u003cstrong\u003eVendor Bills\u003c\/strong\u003e from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e. If a \u003cstrong\u003eZoho Books organization ID\u003c\/strong\u003e is configured, it optionally pulls the latest vendor bills from Zoho Books.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends new bills\u003c\/strong\u003e and updates payment \u003cstrong\u003estatus\/amounts\u003c\/strong\u003e in the Google Sheets bill register using webhook payloads and Zoho Books balances.\u003c\/li\u003e\n  \u003cli\u003eOptionally verifies new or stale vendors using a \u003cstrong\u003eUdyam verification API\u003c\/strong\u003e, then writes the latest MSME category and verification status back to the Vendor Master sheet.\u003c\/li\u003e\n  \u003cli\u003eFor each unpaid Micro\/Small MSME bill, calculates \u003cstrong\u003e15\/45-day deadlines\u003c\/strong\u003e, \u003cstrong\u003edays left\/overdue\u003c\/strong\u003e, \u003cstrong\u003eestimated tax-at-risk\u003c\/strong\u003e, and \u003cstrong\u003eestimated MSMED interest\u003c\/strong\u003e, then triggers \u003cstrong\u003eSlack alerts\u003c\/strong\u003e as bills approach or exceed the limit.\u003c\/li\u003e\n  \u003cli\u003eCreates a cash-constrained \u003cstrong\u003epayment plan\u003c\/strong\u003e, generates a \u003cstrong\u003eCSV payment-priority list\u003c\/strong\u003e, and uploads it to Slack.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to draft a \u003cstrong\u003eCFO briefing\u003c\/strong\u003e, sends a Slack \u003cstrong\u003eapprove\/hold\u003c\/strong\u003e request, and writes the decision back to the relevant bill rows in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMSME compliance teams needing daily visibility into 45-day payment cutoff risk.\u003c\/li\u003e\n  \u003cli\u003eOps\/SaaS operators consolidating bill updates from Zoho Books into a single Google Sheets register.\u003c\/li\u003e\n  \u003cli\u003eTeams that want proactive Slack notifications and a structured approval workflow for payment prioritization.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (vendor master + bill register)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eZoho Books\u003c\/strong\u003e (optional bill sync via organization ID)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUdyam API\u003c\/strong\u003e (vendor MSME verification + category)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e (alerts, CSV priority list posting, approve\/hold request)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e (CFO briefing drafting)\u003c\/li\u003e\n  \u003cli\u003en8n nodes mentioned in the workflow: \u003cstrong\u003eif, set, code, slack, switch, webhook\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164145275059,"sku":"N8N-20524","price":63.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ab_UcplcST-aR4BxIoIo4_U5LcbDeL.png?v=1791277261","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-track-msme-45-day-payments-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}