Contractor 1099 + W-9 Season Kit (n8n template)
Tested on: self-hosted n8n 2.44.6. 53 unit tests and 40 end-to-end checks all passing, plus a live run with real email.
January is a bad time to find out a contractor you paid $4,000 never sent a W-9. This kit keeps an eye on it all year, from your own payment list.
What you get:
- W-9 chase. Polite emails to each contractor with no W-9 on file, with your secure upload link. Reminders on day 7, 14 and 30, then it stops and tells you who never answered. Weekends skipped, a cap per run, and it never asks anyone to email a tax ID.
- Payment tracker. Every Monday: total paid per contractor in 2026, with card and PayPal-type payments left out (those usually go on a 1099-K). Flags anyone at or over $2,000 with no W-9, people getting close, missing TINs, and corporations vs. attorneys. It only emails you when something new needs attention.
- January 1099-NEC prep. A countdown from Jan 2 to the Feb 1, 2027 due date, with a CSV of everyone who probably needs a form and what is still missing.
- Sheet template. Contractors and Payments tabs, with sample data so you can see every email before you add your own. Works with Google Sheets or a published CSV link.
- Error handler that emails you the problem and the likely fix.
All numbers come from code working on your own records. No AI, no TINs stored, nothing sent anywhere but your email provider.
Not tax advice
This is a bookkeeping aid, not tax or legal advice. It does not decide whether you must file, and it does not file anything. Thresholds, deadlines and rules change and have exceptions. Check IRS.gov (Form 1099-NEC instructions) or ask a tax professional before you file.
What's in the download
- 5 workflow files (Settings, W-9 Chase, Payment Tracker, January Prep, Error Handler)
- Sheet template / demo CSVs
- Setup guide (README), testing guide, test report, license
- Screenshots
Good to know
- Setup takes about 15 minutes: import, pick the Settings workflow in four nodes, add a Resend credential, point it at your Sheet.
- Email is sent through Resend (free tier is enough for most small businesses). Set emailProvider to none to only log.
- The totals are only as complete as your payment list.
License, refunds and support
A downloadable, self-serve template, not a service. You run it in your own n8n; VNCNT Labs has no access to your data.
License: single account. Use it in your own n8n instances and ones you run for your clients. Do not resell or redistribute the files. Full terms in LICENSE.txt.
Refunds within 14 days, see vncntlabs.com/refund. Questions: hello@vncntlabs.com
Sold by FAMVII LLC dba VNCNT Labs. n8n, Google, Resend and Gmail are trademarks of their owners. VNCNT Labs is not affiliated with them or with the IRS.
Compatibility notes
Built and tested on self-hosted n8n 2.44.6. Not yet verified: reading a live Google Sheet (the Sheet: Read nodes ship switched off; the same data path was tested with CSV links), Gmail sending, n8n Cloud, other n8n versions including 1.x, queue mode, and contractor lists larger than the 8 contractors and 14 payments we tested. Full details are in the test report inside the download.