Back to Templates

Job Brief Analysis with OpenAI to Find Relevant Templates and Log in Google Sheets

Created by

Created by: Jeremiah Wright || jerrywright

Jeremiah Wright

Last update

Last update 21 hours ago

Share


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 library, and appends the matched templates (ID, name, description, author) to Google Sheets, including the canonical template URL.

How it works

1. Trigger receives a message or paste-in job brief.
2. LLM agent returns 5 concise search terms (JSON).
3. For each keyword, an HTTP request searches the n8n templates API.
4. Results are split and written to Google Sheets; the workflow builds the public URL from ID+slug.

Set up

1. Add credentials for OpenAI (or swap the LLM node to your provider).
2. Create a Google Sheet with columns: Template ID, Name, User, Description, URL.
3. In the ⚙️ Config node, set: GOOGLE_SHEETS_DOC_ID, GOOGLE_SHEET_NAME, N8N_TEMPLATES_API_URL.

Requirements

• n8n (cloud or self-hosted)
• OpenAI (or alternative LLM) credentials
• Google Sheets OAuth credentials

Customize

• Change the model/system prompt to tailor keyword extraction.
• Swap Google Sheets for Airtable/Notion.
• Extend filters (e.g., only AI/CRM templates) before writing rows.