Track and store open job listings with Firecrawl, OpenAI, and Airtable
Ready for 3.0What this workflow does
This AI workflow has 17 nodes and runs on a schedule (every week at 09:00). Along the way it connects Airtable and OpenAI. It also calls api.firecrawl.dev over HTTP.
How it runs
Trigger: On a schedule (every week at 09:00).
- Fetch Known Vacancies from Airtable (Airtable): search
- Fetch Organisations from Airtable (Airtable): search
- Merge: merges the data from its input branches
- Batch Process for Organisations (Loop Over Items (Split in Batches)): loops over the items in batches
- Batch Process for New Roles (Loop Over Items (Split in Batches)): loops over the items in batches
- If: checks a condition and branches into true / false
- Append Vacancy to Airtable (Airtable): create
- Verify Career URL Status (HTTP Request): calls an HTTP API (HEAD)
- Post to Firecrawl for Discovery (HTTP Request): calls api.firecrawl.dev (POST)
- If: checks a condition and branches into true / false
…plus 6 more steps. See the full node list below.
Services it uses
HTTP calls to: api.firecrawl.dev
Uses Firecrawl. New users get 10% off with our link.
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 (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Airtable
n8n-nodes-base.airtable - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Split Out
n8n-nodes-base.splitOut - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick overview This workflow runs weekly to keep an Airtable jobs database up to date by validating or discovering each organisation’s career page with Firecrawl, extracting open roles with OpenAI, and creating new vacancy records while skipping roles that…