Job brief analysis with OpenAI to find relevant templates and log in Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs when a chat message arrives. Along the way it connects OpenAI Chat Model and Google Sheets. It also calls api.n8n.io over HTTP.
How it runs
Trigger: When a chat message arrives.
- AI Agent: runs an AI agent, with model: OpenAI Chat Model
- Parse Keywords (Code): runs custom JavaScript code
- Converting to Array (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Split Out: splits a list into separate items
- Search Templates (HTTP Request): calls api.n8n.io
- Append row in sheet (Google Sheets): append
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Edit Fields (Edit Fields (Set)): sets 1 field: URL
- Update row in sheet (Google Sheets): update
Services it uses
HTTP calls to: api.n8n.io
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 (9)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set
From the author
Who’s it for Recruiters, freelancers, and ops teams who scan job briefs and want quick, relevant n8n template suggestions, saved in a Google Sheet for tracking. What it does Parses any job text, extracts exactly 5 search keywords, queries the n8n template…