Parse and create LEDGERS contacts from unstructured data with GPT-4o
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on Google Sheets events. Along the way it connects Google Sheets, OpenAI Chat Model, Gmail and Ledgers Cloud (community).
How it runs
Trigger: On Google Sheets events.
- Contact Create Smart AI (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Form Loop (Loop Over Items (Split in Batches)): loops over the items in batches
- Create a contact (Ledgers): uses Ledgers
- LEDGERS Loop (Loop Over Items (Split in Batches)): loops over the items in batches
- Success/Failure (If): checks a condition and branches into true / false
- Contact Success (Gmail): uses Gmail
- Contact Failed (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @ledgers/n8n-nodes-ledgers-cloud is verified or supports 3.0 (used in Create a contact).
Nodes used (9)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Ledgers
@ledgers/n8n-nodes-ledgers-cloud.ledgers - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail - AI Agent
@n8n/n8n-nodes-langchain.agent - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - No Operation, do nothing
n8n-nodes-base.noOp - If
n8n-nodes-base.if
From the author
🤖 AI Contact Creator for LEDGERS (Works with Any Trigger) Before using this template: == 👉 Search for LEDGERS in the nodes list and install it from Community Nodes (required for this workflow to run).== 🔧 What This Workflow Does: This smart n8n template…