Templates / Classify & enrich contacts with GPT-4o-mini for Google Sheets, Airtable, and HubSpot

Classify & enrich contacts with GPT-4o-mini for Google Sheets, Airtable, and HubSpot

Ready for 3.0

by Avkash Kakdiya ✓ · 521 views · created 2025-08-07 · Lead Generation, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 10 nodes and runs on a schedule (every hour). Along the way it connects Google Sheets, OpenAI Chat Model, Airtable and HubSpot.

How it runs

Trigger: On a schedule (every hour).

  1. 📄 Read Pending Contacts (Google Sheets): uses Google Sheets
  2. Filter: keeps only the items that match a condition
  3. 🧹 Clean Contact Data (Code): runs custom JavaScript code
  4. 🧠 LLM - GPT-4o-mini (AI Agent): runs an AI agent, with model: 🧠 Classify Role & Seniority
  5. 🧩 Parse or Fallback Role Tags (Code): runs custom JavaScript code
  6. 📊 Update Contact in Sheet (Google Sheets): append or update
  7. 🔁 Sync to Airtable (Airtable): create or update
  8. 📬 Push to HubSpot (HubSpot): uses HubSpot

Services it uses

Google SheetsOpenAI Chat ModelAirtableHubSpot

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 (8)

From the author

How it works This workflow enhances contact intelligence by retrieving new or updated contact data, enriching it using AI and external APIs, and then updating your CRM or contact management system with intelligent insights. It automates the process of…

Excerpt from Avkash Kakdiya's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.