Recruiting Automation via n8n/Zapier
Budget: $30 – $250 USD
We’re building light automations to centralize email across ~51 inboxes, run sourcing searches (role+location) across public web/portals, and send digest alerts to Microsoft Teams/Slack. You’ll design, implement, and document reliable workflows using n8n (preferred) or Zapier.
Key Deliverables
Centralized Email Hub (M365 Graph → DB)
Read mail (headers + metadata; bodies optional) across ~51 M365 mailboxes using Microsoft Graph (Application perms) and delta sync.
Store in NocoDB / Postgres (normalized schema, dedupe by message id).
Views/API endpoints for “Unread Today”, “High importance”, “By account”.
Candidate Finder MVP
Webhook input: role, location, optional skills.
SERP API calls (e.g., SerpAPI/Serper) + GitHub search; rank/dedupe results.
Output JSON + CSV; optional upload to SharePoint and Teams message.
Teams/Slack Digests
Scheduled digests (hourly/daily): top unread or top candidate links.
MessageCards (Teams) / Block Kit (Slack) formatting.
Documentation & Handover
README with env vars, credentials, and importable workflow JSONs.
Runbooks: error handling, rate limits, secrets rotation.
Tech Stack (preferred)
n8n (cloud or self-host). Zapier acceptable for simpler flows.
Microsoft Graph (OAuth2 client credentials), Exchange Online access policies.
NocoDB (or Postgres) as the central store.
SharePoint/OneDrive uploads, Teams Incoming Webhooks (and/or Slack).
SERP provider (SerpAPI/Serper), GitHub Search API.
Requirements
Proven builds with n8n (or Zapier) integrating Graph, web APIs, and DBs.
OAuth2 client-credentials, pagination, delta sync, retries/backoff.
Comfortable with JSON transforms, regex/PRX, and dedupe/scoring logic.
Security-minded (no scraping behind logins; API keys handled securely).
Clear documentation and handover.
Nice to Have
Azure/Entra ID app registrations, Exchange ApplicationAccessPolicy.
Postgres/NocoDB modeling; SharePoint/Graph file operations.
Experience in recruiting workflows (boolean search, sourcing heuristics).
Success Criteria
Stable delta sync for all 51 mailboxes (5–10 min cadence).
Candidate Finder returns ranked top links + CSV within <20s typical.
Teams/Slack digests are readable, de-duplicated, and low-noise.
Clean README + importable JSONs; we can re-deploy in under 30 minutes.
Deliverable Milestones
Design + Credentials Setup (Entra app, scopes, test token) — 10%
Email Hub Seed + Delta (DB schema, first 10 mailboxes live) — 30%
All 51 Mailboxes + Dash Views + Teams Digest — 30%
Candidate Finder MVP + CSV/SharePoint + Digest — 20%
Docs, Handover, Knowledge Transfer — 10%
Key Deliverables
Centralized Email Hub (M365 Graph → DB)
Read mail (headers + metadata; bodies optional) across ~51 M365 mailboxes using Microsoft Graph (Application perms) and delta sync.
Store in NocoDB / Postgres (normalized schema, dedupe by message id).
Views/API endpoints for “Unread Today”, “High importance”, “By account”.
Candidate Finder MVP
Webhook input: role, location, optional skills.
SERP API calls (e.g., SerpAPI/Serper) + GitHub search; rank/dedupe results.
Output JSON + CSV; optional upload to SharePoint and Teams message.
Teams/Slack Digests
Scheduled digests (hourly/daily): top unread or top candidate links.
MessageCards (Teams) / Block Kit (Slack) formatting.
Documentation & Handover
README with env vars, credentials, and importable workflow JSONs.
Runbooks: error handling, rate limits, secrets rotation.
Tech Stack (preferred)
n8n (cloud or self-host). Zapier acceptable for simpler flows.
Microsoft Graph (OAuth2 client credentials), Exchange Online access policies.
NocoDB (or Postgres) as the central store.
SharePoint/OneDrive uploads, Teams Incoming Webhooks (and/or Slack).
SERP provider (SerpAPI/Serper), GitHub Search API.
Requirements
Proven builds with n8n (or Zapier) integrating Graph, web APIs, and DBs.
OAuth2 client-credentials, pagination, delta sync, retries/backoff.
Comfortable with JSON transforms, regex/PRX, and dedupe/scoring logic.
Security-minded (no scraping behind logins; API keys handled securely).
Clear documentation and handover.
Nice to Have
Azure/Entra ID app registrations, Exchange ApplicationAccessPolicy.
Postgres/NocoDB modeling; SharePoint/Graph file operations.
Experience in recruiting workflows (boolean search, sourcing heuristics).
Success Criteria
Stable delta sync for all 51 mailboxes (5–10 min cadence).
Candidate Finder returns ranked top links + CSV within <20s typical.
Teams/Slack digests are readable, de-duplicated, and low-noise.
Clean README + importable JSONs; we can re-deploy in under 30 minutes.
Deliverable Milestones
Design + Credentials Setup (Entra app, scopes, test token) — 10%
Email Hub Seed + Delta (DB schema, first 10 mailboxes live) — 30%
All 51 Mailboxes + Dash Views + Teams Digest — 30%
Candidate Finder MVP + CSV/SharePoint + Digest — 20%
Docs, Handover, Knowledge Transfer — 10%