Track MSME 45-day payments for Section 43B(h) with Sheets, Zoho, Slack, OpenAI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 24 nodes and runs on a schedule (cron 30 9 * * 1-6) (plus 1 other trigger). Along the way it connects Google Sheets, Slack and OpenAI.
How it runs
Trigger: On a schedule (cron 30 9 * * 1-6) (plus 1 other trigger).
- Set Finance Config (Edit Fields (Set)): sets 19 fields: company_name, sheet_id, vendors_sheet…
- Sync Zoho Books Today? (If): checks a condition and branches into true / false
- Pull Zoho Books Bills (HTTP Request): calls an HTTP API
- Get Vendor Master (Google Sheets): uses Google Sheets
- Get Vendor Bills (Google Sheets): uses Google Sheets
- Plan 43B(h) Actions (Code): runs custom JavaScript code
- Route by Action Type (Switch): routes items into 6 branches
- Add New Bill to Sheet (Google Sheets): append
- Prepare Bill Update (Code): runs custom JavaScript code
- Verify Vendor on Udyam API (HTTP Request): calls an HTTP API (POST)
…plus 12 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Slack
n8n-nodes-base.slack - OpenAI
@n8n/n8n-nodes-langchain.openAi - Convert to File
n8n-nodes-base.convertToFile
From the author
Quick overview This workflow tracks MSME vendor bills for Section 43B(h) compliance using Google Sheets as a bill register, optionally syncing bills from Zoho Books, verifying vendors via a Udyam API, and sending Slack alerts, a CSV payment-priority list, and…