n8n Workflow: Track MSME 45-Day Payments & Slack Alerts

Automate MSME 45-Day Payment Tracking with Slack Alerts

This 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 Slack alerts plus a CFO briefing with an approve/hold step—backed by updates to your Google Sheets bill register.

What this workflow does

• Runs daily (Mon–Sat) on a schedule or starts instantly when bills/payments are posted via a webhook.
• Loads Vendor Master and Vendor Bills from Google Sheets. If a Zoho Books organization ID is configured, it optionally pulls the latest vendor bills from Zoho Books.
• Appends new bills and updates payment status/amounts in the Google Sheets bill register using webhook payloads and Zoho Books balances.
• Optionally verifies new or stale vendors using a Udyam verification API, then writes the latest MSME category and verification status back to the Vendor Master sheet.
• For each unpaid Micro/Small MSME bill, calculates 15/45-day deadlines, days left/overdue, estimated tax-at-risk, and estimated MSMED interest, then triggers Slack alerts as bills approach or exceed the limit.
• Creates a cash-constrained payment plan, generates a CSV payment-priority list, and uploads it to Slack.
• Uses OpenAI (gpt-4o-mini) to draft a CFO briefing, sends a Slack approve/hold request, and writes the decision back to the relevant bill rows in Google Sheets.

Use cases

• MSME compliance teams needing daily visibility into 45-day payment cutoff risk.
• Ops/SaaS operators consolidating bill updates from Zoho Books into a single Google Sheets register.
• Teams that want proactive Slack notifications and a structured approval workflow for payment prioritization.

Technical details

• Google Sheets (vendor master + bill register)
• Zoho Books (optional bill sync via organization ID)
• Udyam API (vendor MSME verification + category)
• Slack (alerts, CSV priority list posting, approve/hold request)
• OpenAI (gpt-4o-mini) (CFO briefing drafting)
• n8n nodes mentioned in the workflow: if, set, code, slack, switch, webhook